/// <summary> /// 提交给仓库管理员 /// </summary> /// <param name="fInfo"></param> public void UpdateFilingType(FilingReportInfo fInfo) { var parms = new[] { new SqlParameter(PARM_FILING_ID, SqlDbType.UniqueIdentifier), new SqlParameter(PARM_DEMAND, SqlDbType.Int), new SqlParameter(PARM_SUPPLIERS, SqlDbType.VarChar), new SqlParameter(PARM_PURCHASE_PRICE, SqlDbType.VarChar), new SqlParameter(PARM_FILING_TYPE, SqlDbType.Int) }; parms[0].Value = fInfo.FilingId; parms[1].Value = fInfo.Demand; parms[2].Value = fInfo.Suppliers; parms[3].Value = fInfo.PurchasePrice; parms[4].Value = fInfo.FilingType; try { SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, SQL_UPDATE_FILING_REPORT_FILING_TYPE, parms); } catch (Exception ex) { throw new ApplicationException(ex.Message); } }
/// <summary> /// 获取库存 edit by lxm 20110113 /// </summary> /// <param name="ftype"></param> /// <param name="wareHouseId"></param> /// <returns></returns> public IList <FilingReportInfo> GetFilingReportByFilingType(FilingType ftype, Guid wareHouseId) { IList <FilingReportInfo> frlist = new List <FilingReportInfo>(); string SQL_Select_ByftypeAndWhouseId = @"Select f.FilingId ,f.GoodsId ,f.GoodsName ,f.GoodsCode ,f.Specification ,f.NonceFilialeGoodsStock ,f.NonceRequest ,f.Demand ,f.FilialeId ,f.WareHouseId ,f.Suppliers ,f.FilingType ,f.StartTime ,f.endtime ,isnull(g.RecentInPrice,0) ,f.SuppliersId From lmshop_FilingReport f left join lmShop_GoodsStockCurrent g on f.GoodsId = g.RealGoodsId and g.WareHouseId=@WareHouseId Where 1=1 "; if ((int)ftype != -1) { SQL_Select_ByftypeAndWhouseId += " and f.FilingType=@FilingType "; } else { SQL_Select_ByftypeAndWhouseId += " and f.FilingType!=2 "; } SQL_Select_ByftypeAndWhouseId += " Order by Suppliers "; var parms = new[] { new SqlParameter(PARM_FILING_TYPE, SqlDbType.Int), new SqlParameter(PARM_WARE_HOUSE_ID, SqlDbType.UniqueIdentifier) }; parms[0].Value = (int)ftype; parms[1].Value = wareHouseId; using (var rdr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, SQL_Select_ByftypeAndWhouseId, parms)) { while (rdr.Read()) { var frInfo = new FilingReportInfo(rdr.GetGuid(0), rdr.GetGuid(1), rdr.GetString(2), rdr.GetString(3) , rdr.GetString(4), rdr.GetInt32(5), rdr.GetInt32(6), rdr.GetInt32(7), rdr.GetGuid(8), rdr.GetGuid(9), rdr.GetString(10), (FilingType)rdr.GetInt32(11), rdr.GetDateTime(12), rdr.GetDateTime(13), rdr[14] == DBNull.Value ? 0 : (decimal)rdr.GetDouble(14), rdr.GetGuid(15)); frlist.Add(frInfo); } } return(frlist); }
/// <summary> /// 添加报备记录 /// </summary> /// <param name="fInfo"></param> public void Insert(FilingReportInfo fInfo) { SqlParameter[] parms = GetFilingReportParameters(); parms[0].Value = fInfo.FilingId; parms[1].Value = fInfo.GoodsId; parms[2].Value = fInfo.GoodsName; parms[3].Value = fInfo.GoodsCode; parms[4].Value = fInfo.Specification; parms[5].Value = fInfo.NonceFilialeGoodsStock; parms[6].Value = fInfo.NonceRequest; parms[7].Value = fInfo.SalesNumber; parms[8].Value = fInfo.MeanNumber; parms[9].Value = fInfo.ProposalNumber; parms[10].Value = fInfo.Demand; parms[11].Value = fInfo.TotalNumber; parms[12].Value = fInfo.GoodsState; parms[13].Value = fInfo.FilialeId; parms[14].Value = fInfo.WareHouseId; parms[15].Value = fInfo.SaleType ? 1 : 0; parms[16].Value = fInfo.BackupDays; parms[17].Value = (int)fInfo.FilingType; parms[18].Value = fInfo.SuppliersId; parms[19].Value = fInfo.Suppliers; parms[20].Value = fInfo.StartTime; parms[21].Value = fInfo.Endtime; parms[22].Value = fInfo.PurchasePrice; try { SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, SQL_INSERT_FILING_REPORT, parms); } catch (Exception ex) { throw new ApplicationException(ex.Message); } }