void loadAppParameter()
{
/*
* string strSQL = "select * from(select dbo.f_convertDateToChar(dbo.f_getAplDate())ApplicationDate,dbo.f_getAppParameterValue('callcutoff') CallCutOff,dbo.f_getAppParameterValue('tglfin') TglFin, dbo.f_getAppParameterValue('lat') lat, dbo.f_getAppParameterValue('lng') lng)a";
*
* _DBcon c = new _DBcon();
* foreach (System.Data.DataRow row in c.executeTextQ(strSQL))
* {
* strApplicationDate = row["ApplicationDate"].ToString();
* strCallCutOff = row["CallCutOff"].ToString();
* strTglFin = row["TglFin"].ToString();
* }
*/
_DBcon c = new _DBcon();
foreach (System.Data.DataRow row in c.executeProcQ("xml_login_loading", new _DBcon.sComParameter[] {
new _DBcon.sComParameter("@user_id", System.Data.SqlDbType.VarChar, 50, hfUser.Value)
}))
{
strApplicationDate = row["ApplicationDate"].ToString();
strCallCutOff = row["CallCutOff"].ToString();
strTglFin = row["TglFin"].ToString();
str_branch_id = row["branch_id"].ToString();
str_branch_name = row["branch_name"].ToString();
}
}
public s_service_device[] xml_service_device_list(string sn, string status, string name, string status_opr, string status_send, string inventory, string branch_id)
{
List <s_service_device> data = new List <s_service_device>();
_DBcon c = new _DBcon();
foreach (System.Data.DataRow row in c.executeProcQ("xml_service_device_list", new _DBcon.sComParameter[] {
new _DBcon.sComParameter("@sn", System.Data.SqlDbType.VarChar, 50, sn),
new _DBcon.sComParameter("@status", System.Data.SqlDbType.Char, 1, status),
new _DBcon.sComParameter("@name", System.Data.SqlDbType.VarChar, 50, name),
new _DBcon.sComParameter("@status_opr", System.Data.SqlDbType.Char, 1, status_opr),
new _DBcon.sComParameter("@status_send", System.Data.SqlDbType.Char, 1, status_send),
new _DBcon.sComParameter("@inventory", System.Data.SqlDbType.Char, 1, inventory),
new _DBcon.sComParameter("@branch_id", System.Data.SqlDbType.VarChar, 10, branch_id)
}))
{
data.Add(new s_service_device(
Convert.ToInt64(row["service_device_id"]), row["date_in"].ToString(), row["sn"].ToString(), row["device"].ToString(), row["customer_name"].ToString(),
Convert.ToBoolean(row["guarantee_sts"]), Convert.ToBoolean(row["inventory_sts"])
));
}
return(data.ToArray());
}