/// <summary> /// 更新门店库存副本 /// </summary> /// <param name="storehouseStorage"></param> /// <returns></returns> public int UpdateStorehouseStorageInfo_calculate(StorehouseStoreInfo storehouseStorage) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tbStoreStorehouseInfo_calculate set "); strSql.Append("pRelityStorage=@inypRelityStorage,"); strSql.Append("pMoney=@pMoney"); strSql.Append(" where productStorageID=@chvproductStorageID"); SqlParameter[] parameters = { new SqlParameter("@inypRelityStorage", SqlDbType.Int), new SqlParameter("@pMoney", SqlDbType.Money), new SqlParameter("@chvproductStorageID", SqlDbType.Int), }; parameters[0].Value = storehouseStorage.PNum; parameters[1].Value = storehouseStorage.PMoney; parameters[2].Value = storehouseStorage.ProductStorageID; int state = DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (state > 0) { return(state); } else { return(-1); } }
/// <summary> /// 导入门店库存书库副本 /// </summary> /// <param name="storehouseStorage"></param> /// <returns></returns> public int AddStorehouseStorageInfo_calculate(StorehouseStoreInfo storehouseStorage) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tbStoreStorehouseInfo_calculate("); strSql.Append("sCode,sName,StoresID,stCode,stName,ProductsID,pCode,pBarcode,pName,pBrand,pStandard,pRelityStorage,pAppendTime,pUpdateTime,pMoney)"); strSql.Append(" values ("); strSql.Append("@chvSCode,@chvSName,@inyStoresID,@chvStCode,@chvStName,@inyProductsID,@chvproCode,@inypBarcode,@chvPName,@chvPBrand,@chvPStandard,@inyStorage,@dtmDateTime,GETDATE(),@meyPMoney)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@chvSCode", SqlDbType.VarChar, 50), new SqlParameter("@chvSName", SqlDbType.VarChar, 128), new SqlParameter("@inyStoresID", SqlDbType.Int), new SqlParameter("@chvStCode", SqlDbType.VarChar, 50), new SqlParameter("@chvStName", SqlDbType.VarChar, 128), new SqlParameter("@inyProductsID", SqlDbType.Int), new SqlParameter("@chvproCode", SqlDbType.VarChar, 50), new SqlParameter("@inypBarcode", SqlDbType.VarChar, 50), new SqlParameter("@chvPName", SqlDbType.VarChar, 128), new SqlParameter("@chvPBrand", SqlDbType.VarChar, 128), new SqlParameter("@chvPStandard", SqlDbType.VarChar, 50), new SqlParameter("@inyStorage", SqlDbType.Int), new SqlParameter("@dtmDateTime", SqlDbType.DateTime), new SqlParameter("@meyPMoney", SqlDbType.Money), }; parameters[0].Value = storehouseStorage.SCode; parameters[1].Value = storehouseStorage.SName; parameters[2].Value = storehouseStorage.StoresID; parameters[3].Value = storehouseStorage.StCode; parameters[4].Value = storehouseStorage.StName; parameters[5].Value = storehouseStorage.ProductsID; parameters[6].Value = storehouseStorage.ProCode; parameters[7].Value = storehouseStorage.PBarcode; parameters[8].Value = storehouseStorage.PName; parameters[9].Value = storehouseStorage.PBrand; parameters[10].Value = storehouseStorage.PStandard; parameters[11].Value = storehouseStorage.PNum; parameters[12].Value = storehouseStorage.PAppendTime; parameters[13].Value = storehouseStorage.PMoney; object obj = DbHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters); if (obj == null) { return(-1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新门店库存数据副本 /// </summary> /// <param name="storehouseStorage"></param> /// <returns></returns> public static int UpdateStorehouseStorageInfo_calculate(StorehouseStoreInfo storehouseStorage) { return(DatabaseProvider.GetInstance().UpdateStorehouseStorageInfo_calculate(storehouseStorage)); }
public static int UpdateStorehouseStorageInfo(StorehouseStoreInfo s) { return(DatabaseProvider.GetInstance().UpdateStorehouseStorageInfo(s)); }
public static int AddStorehouseStorageInfo(StorehouseStoreInfo str) { return(DatabaseProvider.GetInstance().AddStorehouseStorageInfo(str)); }
protected virtual void Page_Load(object sender, EventArgs e) { if (this.userid > 0) { if (CheckUserPopedoms("X") || CheckUserPopedoms("3-4-6-1")) { if (Act == "Del") { try { sid = Utils.ChkSQL(HTTPRequest.GetString("sid")); storehouseStorage.DeleteStoragesInfo(sid); AddMsgLine("删除成功!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } catch (Exception ex) { AddErrLine("创建失败!<br/>" + ex.Message); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } } if (Act == "Edit") { productStorageID = Utils.StrToInt(HTTPRequest.GetString("sid"), 0); si = storehouseStorage.GetStorehouseProductsInfoModel(productStorageID); } if (ispost) { sName = Utils.ChkSQL(HTTPRequest.GetString("SName")); // 门店名称 stName = Utils.ChkSQL(HTTPRequest.GetString("stName")); //仓库名称 pName = Utils.ChkSQL(HTTPRequest.GetString("pName")); //产品名称 pBrand = Utils.ChkSQL(HTTPRequest.GetString("pBrand")); //品牌 proCode = Utils.ChkSQL(HTTPRequest.GetString("proCode")); //产品自编号 pStandred = Utils.ChkSQL(HTTPRequest.GetString("pStandred")); //产品规格 pRelityStorage = Utils.StrToInt(Utils.ChkSQL(HTTPRequest.GetString("pNum")), 0); //数量 pBarcode = Utils.ChkSQL(HTTPRequest.GetString("pBarcode")); //条码 pMoney = Utils.ChkSQL(HTTPRequest.GetString("pMoney")); //单价 sDateTime = Utils.IsDateString(Utils.ChkSQL(HTTPRequest.GetString("sDateTime"))) ? DateTime.Parse(Utils.ChkSQL(HTTPRequest.GetString("sDateTime"))) : DateTime.Now; //获取日期 StoresID = Utils.StrToInt(Utils.ChkSQL(HTTPRequest.GetString("StoresID")), 0); //直接获取门店编号 ProductID = Utils.StrToInt(Utils.ChkSQL(HTTPRequest.GetString("ProductID")), 0); //直接获取产品编号 pCode = Utils.StrToInt(storehouseStorage.SelectPcodeByName(pName), 0); //通过产品名称找到产品系统编号 int pbrCode = Utils.StrToInt(storehouseStorage.SelectpBarcodeByName(pBarcode), 0); //通过产品条码获得产品编号 si.SName = sName; si.StCode = "默认值"; si.StName = "默认值"; si.PAppendTime = sDateTime; si.StoresID = StoresID; si.ProductsID = ProductID; si.ProCode = proCode; si.PBarcode = pBarcode; si.PName = pName; si.PBrand = pBrand; si.PStandard = pStandred; si.PNum = pRelityStorage; si.PMoney = pMoney; if (Act == "Add") { if (StoresID > 0) { if (sDateTime > DateTime.Now) { AddMsgLine("创建时间不能大于当前时间,请重新选择!"); } else { if (ProductID > 0) { bool state = storehouseStorage.GetDateTimeDataStorehouseInfoList(sDateTime, StoresID, stCode, pCode); if (state) { AddErrLine("该产品[" + pName + "]数据库已经存在!"); } else { if (storehouseStorage.AddStorehouseStorageInfo(si) > 0) { storehouseStorage.AddStorehouseStorageInfo_calculate(si); AddMsgLine("创建成功!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } else { AddErrLine("创建失败!"); AddScript("window.setTimeout('history.back(1);',1000);"); } } } else { AddMsgLine("该产品[" + pName + "]编号不存在!"); } } } else { AddMsgLine("该门店[" + sName + "]编号不存在!请确认后再次输入或先添加该门店!"); } } if (Act == "Edit") { productStorageID = Utils.StrToInt(HTTPRequest.GetString("sid"), 0); si.ProductStorageID = productStorageID; try { int state = storehouseStorage.UpdateStorehouseStorageInfo(si); if (state > 0) { AddMsgLine("修改成功!"); AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } else { AddErrLine("修改失败!<br/>"); } } catch (Exception ex) { AddErrLine("错误信息!<br/>" + ex.Message); } } } } else { AddErrLine("权限不足!"); AddScript("window.parent.HidBox();"); } } else { AddErrLine("请先登录!"); SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer())); SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer())); } }
protected virtual void Page_Load(object sender, EventArgs e) { if (ispost) { if (this.userid > 0) { if (CheckUserPopedoms("X") || CheckUserPopedoms("3-4-6-1")) { //获取前台的门店名称与仓库名称 sName = HTTPRequest.GetString("SName").Trim(); stName = HTTPRequest.GetString("stName").Trim(); //获取前台选择的时间 DateTime sDateTime = Utils.IsDateString(Utils.ChkSQL(HTTPRequest.GetString("dtime"))) ? DateTime.Parse(Utils.ChkSQL(HTTPRequest.GetString("dtime"))) : DateTime.Now; //根据门店名称取出门店编号 sNum = storehouseStorage.GetScodeBySname(sName); //判断输入的门店名称的名称编号是否存在 StoresID = Utils.StrToInt(HTTPRequest.GetString("StoresID"), 0); if (sNum.Rows.Count > 0) { //判断选择时间是否大于当前时间 if (sDateTime > DateTime.Now) { AddErrLine("日期选择错误,不能大于当前日期,请重新选择!"); } else { //获取上传文件路径 string PathStr = Utils.GetMapPath(config.DataPath.ToString()); string fileExtension = ""; string fileName = ""; string thispath = DateTime.Now.Year + "-" + DateTime.Now.Month; ArrayList filearr = new ArrayList(); int importdata_count = 0; if (!Directory.Exists(PathStr + thispath)) { Directory.CreateDirectory(PathStr + thispath); } //上传文件 HttpFileCollection files = HttpContext.Current.Request.Files; try { if (files.Count > 0) { for (int i = 0; i < files.Count; i++) { HttpPostedFile postedFile = files[i]; fileName = System.IO.Path.GetFileName(postedFile.FileName); if (Utils.ChkSQL(fileName) != "") { fileExtension = System.IO.Path.GetExtension(fileName).ToLower(); if (fileExtension == ".xls") { postedFile.SaveAs(PathStr + thispath + "/" + fileName); filearr.Add(PathStr + thispath + "/" + fileName); } else { AddErrLine("<b>文件格式错误,请将 Xls 文件用 Excel 另存后再导入!</b>:<br>"); } } } } if (filearr.Count > 0) { StorehouseStoreInfo pi = new StorehouseStoreInfo(); for (int j = 0; j < filearr.Count; j++) { DataSet ds = Excels.ExcelToDataTable(filearr[j].ToString()); DataTable dt = new DataTable(); try { dt = ds.Tables[0]; foreach (DataRow dr in dt.Rows) { string pName = dr[1].ToString().Trim(); //产品名称 string pNum = dr[3].ToString().Trim(); //获得产品数量 pMoney = dr[4].ToString().Trim(); //获得产品单价 if (pName != "" && Utils.IsNumeric(pNum) && Utils.IsNumeric(pMoney)) { int proCode = Utils.StrToInt(storehouseStorage.SelectPcodeByName(pName), 0); //通过产品名称获得产品编号 string pBarcode = Utils.ChkSQL(dr[0].ToString().Trim()); //产品条码 string sCode = storehouseStorage.GetScode(sName); //门店编号 string stCode = "默认值"; //仓库编号 暂取默认值 pi.SName = sName; pi.StoresID = StoresID;//匹配添加未成功记录状态=0 门店系统编号唯一 pi.StCode = stCode; pi.StName = stName; pi.ProductsID = proCode; pi.ProCode = dr[2].ToString().Trim(); pi.PName = pName; pi.PBrand = dr[5].ToString().Trim(); pi.PStandard = dr[6].ToString().Trim(); pi.PNum = Utils.StrToInt(pNum, 0); pi.PMoney = pMoney; pi.PBarcode = pBarcode; pi.PAppendTime = sDateTime; if (pBarcode == "") { pBarcode = "null"; pi.PBarcode = pBarcode; if (proCode > 0) { bool state = storehouseStorage.GetDateTimeDataStorehouse(StoresID, "默认值", proCode, pName, pBarcode, pNum, sDateTime); if (state) { AddErrLine("数据重复:产品条码[" + pBarcode + "];产品名称[" + pName + "]"); } else { if (storehouseStorage.AddStorehouseStorageInfo(pi) > 0) { storehouseStorage.AddStorehouseStorageInfo_calculate(pi); importdata_count++; } } } else { AddMsgLine("该产品[" + pName + "];产品条码[" + pBarcode + "]库中不存在!"); } } else { int pbrCode = Utils.StrToInt(storehouseStorage.SelectpBarcodeByName(pBarcode).ToString(), 0);//通过产品条码获得产品编号 if (pbrCode > 0 || proCode > 0) { bool state = storehouseStorage.GetDateTimeDataStorehouse(StoresID, "默认值", proCode, pName, pBarcode, pNum, sDateTime); if (state) { AddErrLine("数据重复:产品条码[" + pBarcode + "];产品名称[" + pName + "]"); } else { if (storehouseStorage.AddStorehouseStorageInfo(pi) > 0) { storehouseStorage.AddStorehouseStorageInfo_calculate(pi); importdata_count++; } } } else { AddMsgLine("该产品[" + pName + "];产品条码[" + pBarcode + "]库中不存在!"); } } } } } finally { ds.Clear(); ds.Dispose(); } } if (importdata_count > 0) { AddMsgLine("数据导入成功!共导入数据[" + importdata_count.ToString() + "]条."); //AddScript("window.setTimeout('window.parent.HidBox();',1000);"); } else { AddErrLine("系统忙!导入失败!"); } } } catch (Exception ex) { AddErrLine("错误信息" + ex.Message); } } } else { AddMsgLine("该门店[" + sName + "]编号不存在!请确认后再次输入或先添加该门店!"); } } else { AddErrLine("权限不足!"); AddScript("window.parent.HidBox();"); } } else { AddErrLine("请先登录!"); SetBackLink("login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer())); SetMetaRefresh(1, "login.aspx?referer=" + Utils.UrlEncode(Utils.GetUrlReferrer())); } } }
/// <summary> /// 实体副本 /// </summary> /// <param name="ProductID"></param> /// <returns></returns> public StorehouseStoreInfo GetStorehouseProductsInfoModel_calculate(int ProductID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 StoresID,sCode,sName,StCode,stName,ProductsID,pCode,pBarcode,pName,pBrand,pStandard,pRelityStorage,pAppendTime,pMoney from tbStoreStorehouseInfo_calculate "); strSql.Append(" where productStorageID=@productStorageID "); SqlParameter[] parameters = { new SqlParameter("@productStorageID", SqlDbType.Int, 4) }; parameters[0].Value = ProductID; StorehouseStoreInfo model = new StorehouseStoreInfo(); DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["StoresID"].ToString() != "") { model.StoresID = int.Parse(ds.Tables[0].Rows[0]["StoresID"].ToString()); } if (ds.Tables[0].Rows[0]["sCode"].ToString() != "") { model.SCode = ds.Tables[0].Rows[0]["sCode"].ToString(); } if (ds.Tables[0].Rows[0]["sName"].ToString() != "") { model.SName = ds.Tables[0].Rows[0]["sName"].ToString(); } if (ds.Tables[0].Rows[0]["StCode"].ToString() != "") { model.StCode = ds.Tables[0].Rows[0]["StCode"].ToString(); } if (ds.Tables[0].Rows[0]["stName"].ToString() != "") { model.StName = ds.Tables[0].Rows[0]["stName"].ToString(); } if (ds.Tables[0].Rows[0]["ProductsID"].ToString() != "") { model.ProductsID = Int32.Parse(ds.Tables[0].Rows[0]["ProductsID"].ToString()); } if (ds.Tables[0].Rows[0]["pCode"].ToString() != "") { model.ProCode = ds.Tables[0].Rows[0]["pCode"].ToString(); } if (ds.Tables[0].Rows[0]["pBarcode"].ToString() != "") { model.PBarcode = ds.Tables[0].Rows[0]["pBarcode"].ToString(); } if (ds.Tables[0].Rows[0]["pName"].ToString() != "") { model.PName = ds.Tables[0].Rows[0]["pName"].ToString(); } if (ds.Tables[0].Rows[0]["pBrand"].ToString() != "") { model.PBrand = ds.Tables[0].Rows[0]["pBrand"].ToString(); } if (ds.Tables[0].Rows[0]["pStandard"].ToString() != "") { model.PStandard = ds.Tables[0].Rows[0]["pStandard"].ToString(); } if (ds.Tables[0].Rows[0]["pRelityStorage"].ToString() != "") { model.PNum = Int32.Parse(ds.Tables[0].Rows[0]["pRelityStorage"].ToString()); } if (ds.Tables[0].Rows[0]["pAppendTime"].ToString() != "") { model.PAppendTime = DateTime.Parse(ds.Tables[0].Rows[0]["pAppendTime"].ToString()); } if (ds.Tables[0].Rows[0]["pMoney"].ToString() != "") { model.PMoney = ds.Tables[0].Rows[0]["pMoney"].ToString(); } return(model); } else { return(null); } }