internal B2b_com_pro_pricelog GetlastPriceLog(int proid) { string selsql2 = @"SELECT top 1 [id] ,[comid] ,[proid] ,[face_price] ,[advise_price] ,[agentsettle_price] ,[Agent1_price] ,[Agent2_price] ,[Agent3_price] ,[opertime] ,[operor] FROM [EtownDB].[dbo].[b2b_com_pro_pricelog] where proid=@proid order by id desc"; var cmdd = sqlHelper.PrepareTextSqlCommand(selsql2); cmdd.AddParam("@proid", proid); using (var reader = cmdd.ExecuteReader()) { B2b_com_pro_pricelog m = null; if (reader.Read()) { m = new B2b_com_pro_pricelog { id = reader.GetValue <int>("id"), proid = reader.GetValue <int>("proid"), advise_price = reader.GetValue <decimal>("advise_price"), face_price = reader.GetValue <decimal>("face_price"), agentsettle_price = reader.GetValue <decimal>("agentsettle_price"), Agent1_price = reader.GetValue <decimal>("Agent1_price"), Agent2_price = reader.GetValue <decimal>("Agent2_price"), Agent3_price = reader.GetValue <decimal>("Agent3_price"), comid = reader.GetValue <int>("comid"), operor = reader.GetValue <int>("operor"), opertime = reader.GetValue <DateTime>("opertime"), }; } return(m); } }
internal int EditPriceLog(int proid, B2b_com_pro product) { if (product.Id == 0)//新增产品 { return(InsertPriceLog(proid, product)); } else //编辑产品 { string selsql = "select count(1) from b2b_com_pro_pricelog where proid=" + proid; var cmd = sqlHelper.PrepareTextSqlCommand(selsql); object o = cmd.ExecuteScalar(); if (o.ToString() == "0") { return(InsertPriceLog(proid, product)); } else { B2b_com_pro_pricelog log = GetlastPriceLog(proid); if (log == null) { return(0); } else { //判断产品价格是否进行了更改 if (log.face_price != product.Face_price || log.advise_price != product.Advise_price || log.agentsettle_price != product.Agentsettle_price || log.Agent1_price != product.Agent1_price || log.Agent2_price != product.Agent2_price || log.Agent3_price != product.Agent3_price) { return(InsertPriceLog(proid, product)); } else { return(1); } } } } }