public int Editkucunlog(B2b_com_pro_kucunlog m) { using (var helper = new SqlHelper()) { int r = new Internalb2b_com_pro_kucunlog(helper).Editkucunlog(m); return(r); } }
internal int Editkucunlog(B2b_com_pro_kucunlog m) { if (m.id > 0) { string sql = @"UPDATE [b2b_com_pro_kucunlog] SET [orderid] = @orderid ,[proid] = @proid ,[servertype] = @servertype ,[daydate] = @daydate ,[proSpeciId] = @proSpeciId ,[surplusnum] = @surplusnum ,[opertype] = @opertype ,[operor] = @operor ,[opertime] = @opertime ,oper=@oper WHERE id=@id"; var cmd = sqlHelper.PrepareTextSqlCommand(sql); cmd.AddParam("@id", m.id); cmd.AddParam("@orderid", m.orderid); cmd.AddParam("@proid", m.proid); cmd.AddParam("@servertype", m.servertype); cmd.AddParam("@daydate", m.daydate); cmd.AddParam("@proSpeciId", m.proSpeciId); cmd.AddParam("@surplusnum", m.surplusnum); cmd.AddParam("@opertype", m.opertype); cmd.AddParam("@operor", m.operor); cmd.AddParam("@opertime", m.opertime); cmd.AddParam("@oper", m.oper); cmd.ExecuteNonQuery(); return(m.id); } else { string sql = @"INSERT [b2b_com_pro_kucunlog] ([orderid] ,[proid] ,[servertype] ,[daydate] ,[proSpeciId] ,[surplusnum] ,[opertype] ,[operor] ,[opertime] ,oper) VALUES (@orderid ,@proid ,@servertype ,@daydate ,@proSpeciId ,@surplusnum ,@opertype ,@operor ,@opertime ,@oper);select @@identity;"; var cmd = sqlHelper.PrepareTextSqlCommand(sql); cmd.AddParam("@orderid", m.orderid); cmd.AddParam("@proid", m.proid); cmd.AddParam("@servertype", m.servertype); cmd.AddParam("@daydate", m.daydate); cmd.AddParam("@proSpeciId", m.proSpeciId); cmd.AddParam("@surplusnum", m.surplusnum); cmd.AddParam("@opertype", m.opertype); cmd.AddParam("@operor", m.operor); cmd.AddParam("@opertime", m.opertime); cmd.AddParam("@oper", m.oper); object o = cmd.ExecuteScalar(); return(int.Parse(o.ToString())); } }
internal int EditB2b_com_pro_Speci(B2b_com_pro_Speci m) { string sql = "select id from b2b_com_pro_Speci where proid=" + m.proid + " and speci_type_nameid_Array='" + m.speci_type_nameid_Array + "'"; var cmd = sqlHelper.PrepareTextSqlCommand(sql); var id = 0; using (var reader = cmd.ExecuteReader()) { if (reader.Read()) { id = reader.GetValue <int>("id"); } } #region 编辑 if (id > 0) { string sql1 = "update b2b_com_pro_Speci set speci_name='" + m.speci_name + "',speci_face_price='" + m.speci_face_price + "',speci_advise_price='" + m.speci_advise_price + "',speci_agent1_price='" + m.speci_agent1_price + "',speci_agent2_price='" + m.speci_agent2_price + "',speci_agent3_price='" + m.speci_agent3_price + "',speci_agentsettle_price='" + m.speci_agentsettle_price + "',speci_pro_weight='" + m.speci_pro_weight + "',speci_totalnum='" + m.speci_totalnum + "',speci_type_nameid_Array='" + m.speci_type_nameid_Array + "' where id=" + id; var cmd1 = sqlHelper.PrepareTextSqlCommand(sql1); cmd1.ExecuteNonQuery(); #region 步修改导入产品规格的成本价:获得导入产品id 和 导入产品规格的成本价 IList <B2b_com_pro> drprolist = new List <B2b_com_pro>();//导入产品列表 string s1 = "select id,com_id from b2b_com_pro where bindingid=" + m.proid; var c1 = sqlHelper.PrepareTextSqlCommand(s1); using (var reader = c1.ExecuteReader()) { while (reader.Read()) { drprolist.Add(new B2b_com_pro { Id = reader.GetValue <int>("id"), Com_id = reader.GetValue <int>("com_id") }); } } if (drprolist != null) { if (drprolist.Count > 0) { foreach (B2b_com_pro drpro in drprolist) { if (drpro != null) { #region 获得导入产品成本价 int drbinding_Agentid = 0; //导入产品公司的绑定分销 int drbinding_Warrant_type = 0; //导入产品公司的绑定分销的分销类型(验证扣款;出票扣款) int drbinding_Agentlevel = 3; //导入产品公司的绑定分销 在原始公司下的分销级别 var comdata = B2bCompanyData.GetCompany(drpro.Com_id); if (comdata != null) { drbinding_Agentid = comdata.Bindingagent; } var agentmodel = AgentCompanyData.GetAgentWarrant(drbinding_Agentid, m.comid); if (agentmodel != null) { drbinding_Agentlevel = agentmodel.Warrant_level; drbinding_Warrant_type = agentmodel.Warrant_type; } decimal aprice = 0; if (drbinding_Agentlevel == 1) { aprice = m.speci_agent1_price; } else if (drbinding_Agentlevel == 2) { aprice = m.speci_agent2_price; } else if (drbinding_Agentlevel == 3) { aprice = m.speci_agent3_price; } //修改绑定规格的成本价格 string s2 = "update b2b_com_pro_Speci set speci_agentsettle_price='" + aprice + "' where proid=" + drpro.Id + " and binding_id=" + id; var c2 = sqlHelper.PrepareTextSqlCommand(s2); c2.ExecuteNonQuery(); #endregion } } } } #endregion #region 库存变化日志 try { B2b_com_pro_kucunlog kucunlog = new B2b_com_pro_kucunlog { id = 0, orderid = 0, proid = m.proid, servertype = new B2bComProData().GetServertypeByProid(m.proid), daydate = DateTime.Parse("1970-01-01"), proSpeciId = id, surplusnum = m.speci_totalnum, operor = "", opertime = DateTime.Now, opertype = "编辑规格", oper = "多规格" }; new B2b_com_pro_kucunlogData().Editkucunlog(kucunlog); } catch { } #endregion return(id); } #endregion #region 添加 else { string sql2 = "INSERT INTO [b2b_com_pro_Speci] (speci_name,speci_face_price,speci_advise_price,speci_agent1_price,speci_agent2_price,speci_agent3_price,speci_agentsettle_price,speci_pro_weight,speci_totalnum,comid,proid,speci_type_nameid_Array) VALUES ('" + m.speci_name + "','" + m.speci_face_price + "','" + m.speci_advise_price + "','" + m.speci_agent1_price + "','" + m.speci_agent2_price + "','" + m.speci_agent3_price + "','" + m.speci_agentsettle_price + "','" + m.speci_pro_weight + "','" + m.speci_totalnum + "','" + m.comid + "','" + m.proid + "','" + m.speci_type_nameid_Array + "');select @@identity;"; var cmd2 = sqlHelper.PrepareTextSqlCommand(sql2); object o = cmd2.ExecuteScalar(); int newspeciid = int.Parse(o.ToString()); #region 步修改导入产品规格的成本价:获得导入产品id 和 导入产品规格的成本价 IList <B2b_com_pro> drprolist = new List <B2b_com_pro>();//导入产品列表 string s1 = "select id,com_id from b2b_com_pro where bindingid=" + m.proid; var c1 = sqlHelper.PrepareTextSqlCommand(s1); using (var reader = c1.ExecuteReader()) { while (reader.Read()) { drprolist.Add(new B2b_com_pro { Id = reader.GetValue <int>("id"), Com_id = reader.GetValue <int>("com_id") }); } } if (drprolist != null) { if (drprolist.Count > 0) { foreach (B2b_com_pro drpro in drprolist) { if (drpro != null) { #region 获得导入产品成本价 int drbinding_Agentid = 0; //导入产品公司的绑定分销 int drbinding_Warrant_type = 0; //导入产品公司的绑定分销的分销类型(验证扣款;出票扣款) int drbinding_Agentlevel = 3; //导入产品公司的绑定分销 在原始公司下的分销级别 var comdata = B2bCompanyData.GetCompany(drpro.Com_id); if (comdata != null) { drbinding_Agentid = comdata.Bindingagent; } var agentmodel = AgentCompanyData.GetAgentWarrant(drbinding_Agentid, m.comid); if (agentmodel != null) { drbinding_Agentlevel = agentmodel.Warrant_level; drbinding_Warrant_type = agentmodel.Warrant_type; } decimal aprice = 0; if (drbinding_Agentlevel == 1) { aprice = m.speci_agent1_price; } else if (drbinding_Agentlevel == 2) { aprice = m.speci_agent2_price; } else if (drbinding_Agentlevel == 3) { aprice = m.speci_agent3_price; } //修改绑定规格的成本价格 string sqlTxt = @"insert into b2b_com_pro_Speci (comid,speci_name,speci_face_price,speci_advise_price,speci_agentsettle_price,speci_pro_weight,speci_totalnum,proid,speci_type_nameid_array,binding_id) select " + drpro.Com_id + ",speci_name,speci_face_price,speci_advise_price," + aprice + ",speci_pro_weight,speci_totalnum," + drpro.Id + ",speci_type_nameid_array,id from b2b_com_pro_Speci where id=" + newspeciid + ""; var c2 = sqlHelper.PrepareTextSqlCommand(sqlTxt); c2.ExecuteNonQuery(); #endregion } } } } #endregion #region 库存变化日志 try { B2b_com_pro_kucunlog kucunlog = new B2b_com_pro_kucunlog { id = 0, orderid = 0, proid = m.proid, servertype = new B2bComProData().GetServertypeByProid(m.proid), daydate = DateTime.Parse("1970-01-01"), proSpeciId = newspeciid, surplusnum = m.speci_totalnum, operor = "", opertime = DateTime.Now, opertype = "新加规格", oper = "多规格" }; new B2b_com_pro_kucunlogData().Editkucunlog(kucunlog); } catch { } #endregion return(newspeciid); } #endregion }