public static string SearchDetail(string data)
{
string res = string.Empty;
try
{
string sql = "SELECT [customer_name],[Customer_Address_Code],[Customer_Part_No],[Customer_Part_Revision],[part_no] " +
" ,[part_name],[Ship_Date],[Lot_No],[BATCH_NO],[Standard_Quantity],[Quantity],[JOB_SEQUENCE] FROM " +
"[FGA_PLATFORM].[dbo].[FGA_LoadDetail_T] where loadid = '" + data + "'";
DataSet ds = new DataSet();
ds = FGA_DAL.Base.SQLServerHelper.Query(sql);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
List <EDIReleaseModel> luw = new List <EDIReleaseModel>();
foreach (DataRow row in ds.Tables[0].Rows)
{
EDIReleaseModel ERM = new EDIReleaseModel(row);
luw.Add(ERM);
}
JavaScriptSerializer jssl = new JavaScriptSerializer();
res = jssl.Serialize(luw);
res = res.Replace("\\/Date(", "").Replace(")\\/", "");
}
}
catch (Exception e)
{
}
return(res);
}
public static string SearchData()
{
//按用户查看EDI的数据
UsersModel model = (UsersModel)HttpContext.Current.Session[SysConst.S_LOGIN_USER];
string ET = "";
string sql = "";
if (model.USERNAME == "Honda_front")
{
ET = "Front";
}
if (model.USERNAME == "Honda_rear")
{
ET = "Rear";
}
if (model.USERNAME == "Honda_side")
{
ET = "Side";
}
string res = string.Empty;
try
{
if (model.USERNAME != "administrator")
{
sql = "SELECT [customer_name],[Customer_Address_Code],[Customer_Part_No],[Customer_Part_Revision] " +
" ,[part_no],[Due_Date] ,[Ship_Date],[ORDER_NO] ,[Lot_No],[BATCH_NO]" +
" ,[Standard_Quantity],[Quantity],[JOB_SEQUENCE],[EDI_RowID],[MasterID] " +
" FROM [FGA_PLATFORM].[dbo].[FGA_EDI_862_T] where rstatus = 0 and PARTTYPE = '" + ET + "' " +
"order by [Ship_Date],[MasterID],[JOB_SEQUENCE]";
}
if (model.USERNAME == "administrator")
{
sql = "SELECT [customer_name],[Customer_Address_Code],[Customer_Part_No],[Customer_Part_Revision] " +
" ,[part_no],[Due_Date] ,[Ship_Date],[ORDER_NO] ,[Lot_No],[BATCH_NO]" +
" ,[Standard_Quantity],[Quantity],[JOB_SEQUENCE],[EDI_RowID],[MasterID] " +
" FROM [FGA_PLATFORM].[dbo].[FGA_EDI_862_T] " +
"order by [Ship_Date],[MasterID],[JOB_SEQUENCE]";
}
DataSet ds = new DataSet();
ds = FGA_DAL.Base.SQLServerHelper.Query(sql);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
List <EDIReleaseModel> luw = new List <EDIReleaseModel>();
foreach (DataRow row in ds.Tables[0].Rows)
{
EDIReleaseModel ERM = new EDIReleaseModel(row);
luw.Add(ERM);
}
JavaScriptSerializer jssl = new JavaScriptSerializer();
res = jssl.Serialize(luw);
res = res.Replace("\\/Date(", "").Replace(")\\/", "");
}
}
catch (Exception e)
{
}
return(res);
}
