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