public static string getDetail(string transferNO)
{
string res = string.Empty;
try
{
string sql = "SELECT [SerialNO],[PartNO],[F_Location],[Quantity] FROM [WMS_BarCode_V10].[dbo].[IPTransfer_Detail_t] where [TransferNO] = '" + transferNO + "' ";
DataSet ds = new DataSet();
ds = FGA_DAL.Base.SQLServerHelper_WMS.Query(sql);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
List <InterPlantTransferModel> luw = new List <InterPlantTransferModel>();
foreach (DataRow row in ds.Tables[0].Rows)
{
InterPlantTransferModel ERM = new InterPlantTransferModel(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(string transferNO, string status, string fdate, string tdate, string roler)
{
UsersModel model = (UsersModel)HttpContext.Current.Session[SysConst.S_LOGIN_USER];
string puser = model.USERNAME;
string res = string.Empty;
try
{
string sql = "SELECT [TransferNO],[Factory],[Transtatus],[Creator],[CreateDate],[T_Location],[Receiver],[ReceptionDate]" +
"FROM [WMS_BarCode_V10].[dbo].[InterPlantTransfer_H] where 1=1 and isnull(dr,'0') = '0' ";
if (!"administrator".Equals(puser) && !"FGAMaterialMag".Equals(roler))
{
sql = sql + " and T_Location IN (SELECT [Location] FROM [IPTransfer_Receiver_t] WHERE [Receiver] ='" + puser + "')";
}
if (!"All".Equals(status))
{
sql = sql + " and [Transtatus] like '" + status + "'";
}
if (!String.IsNullOrEmpty(transferNO))
{
sql = sql + " and [TransferNO] like '" + transferNO + "'";
}
if (!String.IsNullOrEmpty(fdate))
{
sql = sql + " and [CreateDate] >= cast('" + fdate + "' as datetime)";
}
if (!String.IsNullOrEmpty(tdate))
{
sql = sql + " and [CreateDate] <= cast('" + tdate + "' as datetime)";
}
sql = sql + " order by [CreateDate] desc,[TransferNO] desc";
DataSet ds = new DataSet();
ds = FGA_DAL.Base.SQLServerHelper_WMS.Query(sql);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
List <InterPlantTransferModel> luw = new List <InterPlantTransferModel>();
foreach (DataRow row in ds.Tables[0].Rows)
{
InterPlantTransferModel ERM = new InterPlantTransferModel(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(string transferNO)
{
string res = string.Empty;
try
{
string sql = "SELECT [TransferNO],[Factory],[Transtatus],[Creator],[CreateDate],[T_Location],[Receiver],[ReceptionDate]" +
"FROM [WMS_BarCode_V10].[dbo].[InterPlantTransfer_H] where 1=1 ";
if (!String.IsNullOrEmpty(transferNO))
{
sql = sql + " and [TransferNO] like '" + transferNO + "'";
}
sql = sql + " order by [CreateDate] desc,[TransferNO] desc";
DataSet ds = new DataSet();
ds = FGA_DAL.Base.SQLServerHelper_WMS.Query(sql);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
List <InterPlantTransferModel> luw = new List <InterPlantTransferModel>();
foreach (DataRow row in ds.Tables[0].Rows)
{
InterPlantTransferModel ERM = new InterPlantTransferModel(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 onActionReceive(string transferNO, string location)
{
string res = "";
int count = 0;
string msg = "";
string plexid = "2786442";
string puser = (HttpContext.Current.Session[SysConst.S_LOGIN_USER] as UsersModel).USERNAME;
string sql = "select plexid from userinfo where username = '******'";
DataSet ds2 = new DataSet();
ds2 = FGA_DAL.Base.SQLServerHelper_FGA.Query(sql);
if (ds2 != null && ds2.Tables.Count > 0 && ds2.Tables[0].Rows.Count > 0)
{
plexid = ds2.Tables[0].Rows[0][0].ToString();
}
try
{
string sqlinfos = "SELECT [SerialNO] FROM [WMS_BarCode_V10].[dbo].[IPTransfer_Detail_t] where [TransferNO] = '" + transferNO + "' and isnull(dr,'0') = 0 ";
DataSet ds = new DataSet();
ds = FGA_DAL.Base.SQLServerHelper_WMS.Query(sqlinfos);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
List <InterPlantTransferModel> luw = new List <InterPlantTransferModel>();
foreach (DataRow row in ds.Tables[0].Rows)
{
InterPlantTransferModel ERM = new InterPlantTransferModel(row);
FGA_NUtility.POL.ExecuteDataSourceResult da_rst = PlexHelper.PlexGetResult_4("27181", "Container_Update_Simple",
"@Serial_No", "@Location", "@Last_Action", "@Update_By", ERM.SerialNO, location, "Inter-Plant Transfer by scanner", plexid);
if (!da_rst.Error)
{
count++;
}
else
{
msg = msg + ERM.SerialNO + '\n';
}
}
}
if (!String.IsNullOrEmpty(msg))
{
res = "Finished: " + count + '\n' + "Follow SerialNO is unsuccessful: " + '\n' + msg;
}
else
{
res = "Finished: " + count;
//更改CycleInventory_H状态
string synsql = "update [InterPlantTransfer_H] set [Transtatus] = 'Completed',[Receiver] ='" + puser + "',[ReceptionDate] = getdate() where [TransferNO] = '" + transferNO + "'";
FGA_DAL.Base.SQLServerHelper_WMS.ExecuteSql(synsql);
}
}
catch (Exception e)
{
}
return(res);
}
