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