public static string QuerySubscribeInfo(string subscribestart, string subscribeend, string declarationcode, string istrigger, string busitype, string busiunit, string ordercode,
string cusno, string contract, string submitstart, string submitend, int pagesize, int lastnum)
{
string sum = "0";
WGUserEn user = (WGUserEn)HttpContext.Current.Session["user"];
if (user == null || user.GwyUserID <= 0)
{
return("");
}
DataTable infodt = SubscribeModel.getNewSubscribeInfo_Decl(subscribestart, subscribeend, declarationcode, istrigger, busitype, busiunit, ordercode, cusno, contract,
submitstart, submitend, pagesize, lastnum, user.GwyUserID, out sum);
//DataTable infodt = SubscribeModel.getNewSubscribeInfo_Decl(subscribestart, subscribeend, declarationcode, istrigger, busitype, busiunit, ordercode, cusno, contract,
// submitstart, submitend, pagesize, lastnum, 1124, out sum);
if (infodt == null || infodt.Rows.Count == 0)
{
return("");
}
try
{
foreach (DataRow dr in infodt.Rows)
{
if (string.IsNullOrEmpty(dr["transname"].ToString2()))
{
dr["transname"] = "";
}
if (string.IsNullOrEmpty(dr["tradename"].ToString2()))
{
dr["tradename"] = "";
}
if (string.IsNullOrEmpty(dr["status"].ToString2()))
{
dr["status"] = "";
}
if (string.IsNullOrEmpty(dr["customsstatus"].ToString2()))
{
dr["customsstatus"] = "";
}
dr["sum"] = sum;
}
IsoDateTimeConverter iso = new IsoDateTimeConverter();//序列化JSON对象时,日期的处理格式
iso.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
string json = JsonConvert.SerializeObject(infodt, iso);
return(json);
}
catch (Exception e)
{
LogHelper.Write("MyBusiness_QueryData:" + e.Message);
return("");
}
}
public static string NewQuerySubscribeInfo()
{
WGUserEn user = (WGUserEn)HttpContext.Current.Session["user"];
if (user == null || user.GwyUserID <= 0)
{
return("");
}
DataTable infodt = SubscribeModel.getNewSubscribeInfo_Decl(user.GwyUserID);
//DataTable infodt = SubscribeModel.getNewSubscribeInfo_Decl(1124);
if (infodt == null || infodt.Rows.Count == 0)
{
return("");
}
try
{
foreach (DataRow dr in infodt.Rows)
{
if (string.IsNullOrEmpty(dr["transname"].ToString2()))
{
dr["transname"] = "";
}
if (string.IsNullOrEmpty(dr["tradename"].ToString2()))
{
dr["tradename"] = "";
}
if (string.IsNullOrEmpty(dr["status"].ToString2()))
{
dr["status"] = "";
}
if (string.IsNullOrEmpty(dr["customsstatus"].ToString2()))
{
dr["customsstatus"] = "";
}
}
IsoDateTimeConverter iso = new IsoDateTimeConverter();//序列化JSON对象时,日期的处理格式
iso.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
string json = JsonConvert.SerializeObject(infodt, iso);
return(json);
}
catch (Exception e)
{
LogHelper.Write("MyBusiness_QueryData:" + e.Message);
return("");
}
}