/// <summary>
/// 保存商品详细信息
/// </summary>
/// <param name="Name"></param>
/// <param name="Suppliers"></param>
/// <returns></returns>
public string SaveHoustory(string Name, string Suppliers)
{
int count = 0;
decimal money = 0;
var serialize = new JavaScriptSerializer();
SqlParameter[] par;
List <JsonMerchandise> model = serialize.Deserialize <List <JsonMerchandise> >(Name);
string RandSum = RandNumber();
par = new SqlParameter[] {
new SqlParameter("SuppliersId", Suppliers), new SqlParameter("Deleted", "0"),
new SqlParameter("OrderCreatetime", DateTime.Now), new SqlParameter("Money", money),
new SqlParameter("number", RandSum),
};
string InsertOrderhistory = @"INSERT INTO [Orderhistory]([Count],[TotalMoney],[OrderCreatetime],[Number],[Suppliersid],[Deleted])
VALUES(null,@Money,@OrderCreatetime,@number,@SuppliersId,@Deleted);SELECT @@IDENTITY";//取得最后一次自增ID
int Orderhistoryid = int.Parse(com.ExecuteScalar(InsertOrderhistory, par).ToString());
for (int i = 0; i < model.Count; i++)
{
par = new SqlParameter[] {
new SqlParameter("Mid", model[i].history_id), new SqlParameter("note", model[i].history_note),
new SqlParameter("taotalproce", model[i].history_money), new SqlParameter("Suppliers", Suppliers),
new SqlParameter("sum", model[i].history_sum), new SqlParameter("Number", RandSum),
new SqlParameter("PropertyDelete", "0"), new SqlParameter("CreateTime", DateTime.Now),
new SqlParameter("Orderhistoryid", Orderhistoryid)
};
//历史详情表
string InsertPurchaseProperty = @"INSERT INTO [PurchaseProperty]([MId],[PropertySum],[PropertyToal],[PropertyDelete],[CreateTime],[PropertyNote] ,[Pid] )
VALUES(@Mid,@sum,@taotalproce,@PropertyDelete,@CreateTime,@note,@Orderhistoryid)";
count = com.ExecutionSqlPar(InsertPurchaseProperty, par);
//将进货的商品添加至库存
string insertDetail = @"INSERT INTO [DB_MgooERP].[dbo].[InventoryDetail]
([Supplierid]
,[Mid]
,[InventoryId],Number,Sum,CreateTime)VALUES(@Suppliers,@Mid,null,@Number,@sum,@CreateTime)";
count = com.ExecutionSqlPar(insertDetail, par);
// string UpdateSum = @"Update InventoryDetail set Sum=Sum+@sum where Mid=@Mid";
string UpdateStore = @"UPDATE [dbo].[Inventory] set [InvertorySum] = InvertorySum+@sum WHERE Mid=@Mid";
count = com.ExecutionSqlPar(UpdateStore, par);
}
if (count > 0)
{
return(Utils.GetResult(200, "保存成功", "true"));
}
else
{
return(Utils.GetResult(400, "保存失败"));
}
}
public string SaveOutPut(string list, string accountid)
{
//往出库单表中增加一条数据
int count = 0;
var serialize = new JavaScriptSerializer();
string rand = RandNumber();
SqlParameter[] par;
List <JsonOutPut> model = serialize.Deserialize <List <JsonOutPut> >(list);//反序列化类中字段必须与传入的字段名称对应
par = new SqlParameter[] {
new SqlParameter("RandNumber", rand), new SqlParameter("CreateTime", DateTime.Now),
new SqlParameter("AccountId", accountid), new SqlParameter("Delete", '0'),
};
string OutPut = @"INSERT INTO [OutPut] ([Out_Number],[Out_Create],[Out_Accountid],[Out_Delete])
VALUES(@RandNumber,@CreateTime,@AccountId,@Delete);SELECT @@IDENTITY";//取得最后一次增长的ID
int Out_id = int.Parse(com.ExecuteScalar(OutPut, par).ToString());
for (int i = 0; i < model.Count; i++)
{
//将商品的进行退货，出库详情表单增加两条数据，库存表相应减少
par = new SqlParameter[] {
new SqlParameter("Mid", model[i].out_mid), new SqlParameter("sum", model[i].out_sum), new SqlParameter("TotalMoney", model[i].out_totalmoney),
new SqlParameter("Rand", rand), new SqlParameter("Create", DateTime.Now), new SqlParameter("RealPrice", '0'),
new SqlParameter("Oid", Out_id), new SqlParameter("DetailDelete", '0'), new SqlParameter("OutNote", model[i].out_sum)
};
//取得出库表的ID，将数据添加至出库详情表中
string OutPutDetail = @"INSERT INTO [dbo].[OutPutDetail]([OutDate],[OutNumber],[Mid],[OutSum],[OutTotalMoney],[RealPrice],Out_id,DetailDelete,OutNote)
VALUES(@Create,@Rand,@Mid,@sum,@TotalMoney,@RealPrice,@Oid,@DetailDelete,@OutNote)";
count = com.ExecutionSqlPar(OutPutDetail, par);
//库存数量相应减少
string UpdateStore = @"UPDATE [dbo].[Inventory] set [InvertorySum] = InvertorySum-@sum WHERE Mid=@Mid";
count = com.ExecutionSqlPar(UpdateStore, par);
}
if (count > 0)
{
return(Utils.GetResult(200, "保存成功", "true"));
}
else
{
return(Utils.GetResult(400, "保存失败"));
}
}