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; }