/// <summary> /// 获得分销公司信息 /// </summary> /// <param name="id"></param> /// <returns></returns> internal B2b_com_agent_message AgentMessageInfo(int id, int comid) { string sql = @"SELECT * FROM b2b_com_agent_message where id=@id and comid=@comid"; var cmd = sqlHelper.PrepareTextSqlCommand(sql); cmd.AddParam("@id", id); cmd.AddParam("@comid", comid); B2b_com_agent_message u = null; using (var reader = cmd.ExecuteReader()) { if (reader.Read()) { u = new B2b_com_agent_message { Id = reader.GetValue <int>("id"), Comid = reader.GetValue <int>("Comid"), Title = reader.GetValue <string>("Title"), Message = reader.GetValue <string>("Message"), State = reader.GetValue <int>("State"), Subtime = reader.GetValue <DateTime>("Subtime"), }; } } return(u); }
public static int AgentMessageUp(B2b_com_agent_message regiinfo) { using (var sql = new SqlHelper()) { try { var internalData = new InternalB2bcomagentmessage(sql); int result = internalData.AgentMessageUp(regiinfo); return(result); } catch { throw; } } }
internal int AgentMessageUp(B2b_com_agent_message model) { string sqlTxt = @"update b2b_com_agent_message set Title =@Title,Message =@Message,State =@State Where id=@Id and comid=@comid;select @@identity;"; if (model.Id == 0) //id为0 做成插入 { sqlTxt = "insert b2b_com_agent_message (comid,title,message,subtime) values (@comid,@Title,@Message,@Subtime) "; } var cmd = sqlHelper.PrepareTextSqlCommand(sqlTxt); //分销商通知编辑 cmd.AddParam("@Id", model.Id); cmd.AddParam("@comid", model.Comid); cmd.AddParam("@Title", model.Title); cmd.AddParam("@Message", model.Message); cmd.AddParam("@State", model.State); cmd.AddParam("@Subtime", DateTime.Now); return(cmd.ExecuteNonQuery()); }