public static List <ViewTransfer> QueryTransfer(QueryTransferParas model)
{
string LocID = model.LocID != null ? model.LocID : "";
string TransferDateFrom = model.TransferDateFrom != null ? model.TransferDateFrom : "";
string TransferDateTo = model.TransferDateTo != null ? model.TransferDateTo : "";
string ProductMoFrom = model.ProductMoFrom != null ? model.ProductMoFrom : "";
string ProductMoTo = model.ProductMoTo != null ? model.ProductMoTo : "";
string GoodsIDFrom = model.GoodsIDFrom != null ? model.GoodsIDFrom : "";
string GoodsIDTo = model.GoodsIDTo != null ? model.GoodsIDTo : "";
if (LocID == "" && TransferDateFrom == "" && TransferDateTo == "" && ProductMoFrom == "" && ProductMoTo == "" && GoodsIDFrom == "" && GoodsIDTo == "")
{
LocID = "ZZZ";
TransferDateFrom = "1900/01/01";
TransferDateTo = "1900/01/01";
}
string strSql = "p_WmTransferDetails";
SqlParameter[] parameters = { new SqlParameter("@LocID", LocID)
, new SqlParameter("@DateFrom", TransferDateFrom)
, new SqlParameter("@DateTo", TransferDateTo)
, new SqlParameter("@ProductMoFrom", ProductMoFrom)
, new SqlParameter("@ProductMoTo", ProductMoTo)
, new SqlParameter("@GoodsIDFrom", GoodsIDFrom)
, new SqlParameter("@GoodsIDTo", GoodsIDTo) };
DataTable dt = SQLHelper.ExecuteProcedureRetrunDataTable(strSql, parameters);
List <ViewTransfer> lsDetails = new List <ViewTransfer>();
for (int i = 0; i < dt.Rows.Count; i++)
{
ViewTransfer mdj = new ViewTransfer();
DataRow dr = dt.Rows[i];
mdj.ID = dr["ID"].ToString();
mdj.LocID = dr["LocID"].ToString();
mdj.ProductMo = dr["ProductMo"].ToString();
mdj.GoodsID = dr["GoodsID"].ToString();
mdj.LotNo = dr["LotNo"].ToString();
mdj.TransferQty = Convert.ToInt32(dr["TransferQty"]);
//mdj.QtyUnit = dr["QtyUnit"].ToString();
mdj.TransferWeg = Convert.ToDecimal(dr["TransferWeg"]);
//mdj.WegUnit = dr["WegUnit"].ToString();
mdj.GoodsName = dr["GoodsName"].ToString();//"file:///" + Server.MapPath("~") +"~/Images/login.jpg";//
mdj.NextLocID = dr["NextLocID"].ToString();
mdj.TransferDate = dr["TransferDate"].ToString();
mdj.FlagID = dr["FlagID"].ToString();
mdj.FlagName = dr["FlagName"].ToString();
mdj.TransferFlag = dr["TransferFlag"].ToString();
mdj.LocIDFrom = dr["LocIDFrom"].ToString();
mdj.UseItem = dr["UseItem"].ToString();
mdj.UseItemName = dr["UseItemName"].ToString();
mdj.WmQty = dr["WmQty"].ToString() != "" ? Convert.ToInt32(dr["WmQty"]) : 0;
mdj.WmWeg = dr["WmWeg"].ToString() != "" ? Convert.ToDecimal(dr["WmWeg"]) : 0;
lsDetails.Add(mdj);
}
return(lsDetails);
}
public void OpenSend(string nameGame)
{
Close();
LShop lshop = (LShop)UILayerController.Instance.GetLayer(UILayerKey.LShop);
ViewTransfer transfer = (ViewTransfer)lshop.listViewTypeShop[(int)IndexViewShop.TRANSFER];
lshop.listToggleMenu[(int)IndexViewShop.TRANSFER].isOn = true;
transfer.inputFieldNameDisplay.text = nameGame;
transfer.inputFieldNameDisplayAgain.text = nameGame;
}
