public class MOBILEUSER
{
public int LOGICALREF { get; set; }
public int CAPIUSERREF { get; set; }
public string NAME { get; set; } = string.Empty;
public string KEY_ { get; set; } = string.Empty;
public string DEFINITION_ { get; set; }
public int SLSMANREF { get; set; }
public string SLSMANCODE { get; set; } = string.Empty;
public string FCMREGID { get; set; } = string.Empty;
public int CONFTYPE { get; set; }
public double CONF_SAMOUNT { get; set; }
public double CONF_FAMOUNT { get; set; }
public double CONF_SPERCENT { get; set; }
public double CONF_FPERCENT { get; set; }
public short ACTIVE { get; set; }
public string NTF_ORFICHEREF { get; set; } = string.Empty;
public string NTF_ORFICHENO { get; set; } = string.Empty;
}
private List<MOBILEUSER> GET_MOBILEUSER_LIST()
{
List<MOBILEUSER> MUL = new List<MOBILEUSER>();
try
{
DataTable DT = sqlLGDB.ExecuteDataSet(new SqlCommand(string.Format("SELECT * FROM BM_MOBILEUSER WHERE ACTIVE = 0"))).Tables[0];
foreach (DataRow R in DT.Rows)
{
MOBILEUSER U = new MOBILEUSER();
try { U.LOGICALREF = (int)R["LOGICALREF"]; } catch { }
try { U.CAPIUSERREF = (int)R["CAPIUSERREF"]; } catch { }
try { U.NAME = (string)R["NAME"]; } catch { }
try { U.KEY_ = (string)R["KEY_"]; } catch { }
try { U.DEFINITION_ = (string)R["DEFINITION_"]; } catch { }
try { U.SLSMANREF = (int)R["SLSMANREF"]; } catch { }
try { U.SLSMANCODE = (string)R["SLSMANCODE"]; } catch { }
try { U.FCMREGID = (string)R["FCMREGID"]; } catch { }
try { U.CONFTYPE = (int)R["CONFTYPE"]; } catch { }
try { U.CONF_SAMOUNT = (double)R["CONF_SAMOUNT"]; } catch { }
try { U.CONF_FAMOUNT = (double)R["CONF_FAMOUNT"]; } catch { }
try { U.CONF_SPERCENT = (double)R["CONF_SPERCENT"]; } catch { }
try { U.CONF_FPERCENT = (double)R["CONF_FPERCENT"]; } catch { }
try { U.ACTIVE = (short)R["ACTIVE"]; } catch { }
MUL.Add(U);
}
}
catch (Exception E)
{
WRITELOG("GET_MOBILEUSER_LIST", E, false);
}
return MUL;
}
{
public int LOGICALREF { get; set; }
public int CAPIUSERREF { get; set; }
public string NAME { get; set; } = string.Empty;
public string KEY_ { get; set; } = string.Empty;
public string DEFINITION_ { get; set; }
public int SLSMANREF { get; set; }
public string SLSMANCODE { get; set; } = string.Empty;
public string FCMREGID { get; set; } = string.Empty;
public int CONFTYPE { get; set; }
public double CONF_SAMOUNT { get; set; }
public double CONF_FAMOUNT { get; set; }
public double CONF_SPERCENT { get; set; }
public double CONF_FPERCENT { get; set; }
public short ACTIVE { get; set; }
public string NTF_ORFICHEREF { get; set; } = string.Empty;
public string NTF_ORFICHENO { get; set; } = string.Empty;
}
private List<MOBILEUSER> GET_MOBILEUSER_LIST()
{
List<MOBILEUSER> MUL = new List<MOBILEUSER>();
try
{
DataTable DT = sqlLGDB.ExecuteDataSet(new SqlCommand(string.Format("SELECT * FROM BM_MOBILEUSER WHERE ACTIVE = 0"))).Tables[0];
foreach (DataRow R in DT.Rows)
{
MOBILEUSER U = new MOBILEUSER();
try { U.LOGICALREF = (int)R["LOGICALREF"]; } catch { }
try { U.CAPIUSERREF = (int)R["CAPIUSERREF"]; } catch { }
try { U.NAME = (string)R["NAME"]; } catch { }
try { U.KEY_ = (string)R["KEY_"]; } catch { }
try { U.DEFINITION_ = (string)R["DEFINITION_"]; } catch { }
try { U.SLSMANREF = (int)R["SLSMANREF"]; } catch { }
try { U.SLSMANCODE = (string)R["SLSMANCODE"]; } catch { }
try { U.FCMREGID = (string)R["FCMREGID"]; } catch { }
try { U.CONFTYPE = (int)R["CONFTYPE"]; } catch { }
try { U.CONF_SAMOUNT = (double)R["CONF_SAMOUNT"]; } catch { }
try { U.CONF_FAMOUNT = (double)R["CONF_FAMOUNT"]; } catch { }
try { U.CONF_SPERCENT = (double)R["CONF_SPERCENT"]; } catch { }
try { U.CONF_FPERCENT = (double)R["CONF_FPERCENT"]; } catch { }
try { U.ACTIVE = (short)R["ACTIVE"]; } catch { }
MUL.Add(U);
}
}
catch (Exception E)
{
WRITELOG("GET_MOBILEUSER_LIST", E, false);
}
return MUL;
}