/// <summary>
/// 得到一条消息数据
/// </summary>
/// <param name="Getto">目的地</param>
/// <param name="flag">标记</param>
/// <returns>SYS.Model.XXXXB</returns>
public SYS.Model.XXXXB GetModel(string Getto, string flag)
{
string sql = "select top 1 ID,* from xxxxb where Getto=@Getto and Flag=@Flag";
SqlParameter[] spr =
{
new SqlParameter("@Getto", Getto),
new SqlParameter("@Flag", flag)
};
try
{
DataTable dt = DBHelperSQL.GetDataTable(sql, CommandType.Text, spr);
SYS.Model.XXXXB xxxb = null;
if (dt.Rows.Count > 0)
{
xxxb = new SYS.Model.XXXXB();
xxxb.ID = int.Parse(dt.Rows[0]["ID"].ToString());
xxxb.Title = dt.Rows[0]["Title"].ToString();
xxxb.Content = dt.Rows[0]["Content"].ToString();
xxxb.Comefrom = dt.Rows[0]["Comefrom"].ToString();
xxxb.Other = dt.Rows[0]["Other"].ToString();
xxxb.Message_Type = dt.Rows[0]["Message_Message_Type"].ToString();
xxxb.Flag = dt.Rows[0]["Flag"].ToString();
}
return(xxxb);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 保存一条消息数据
/// </summary>
/// <param name="xxxxb">SYS.Model.XXXXB</param>
/// <returns>bool</returns>
public bool Save(SYS.Model.XXXXB xxxxb)
{
string sqli = "insert into xxxxb(Title,Content,Other,Comefrom,Getto,Message_Message_Type,Flag) values(@Title,@Content,@Other,@Comefrom,@Getto,@Message_Message_Type,@Flag)";
string sqlu = "update xxxxb set Title=@Title,Content=@Content,Other=@Other,Comefrom=@Comefrom,Getto=@Getto,Message_Type=@Message_Type,Flag=@Flag where ID=@ID";
SqlParameter[] spr =
{
new SqlParameter("@Title", xxxxb.Title),
new SqlParameter("@Content", xxxxb.Content),
new SqlParameter("@Other", xxxxb.Other),
new SqlParameter("@Comefrom", xxxxb.Comefrom),
new SqlParameter("@Getto", xxxxb.Getto),
new SqlParameter("@Flag", xxxxb.Flag),
new SqlParameter("@Message_Type", xxxxb.Message_Type),
new SqlParameter("@ID", xxxxb.ID)
};
if (xxxxb.ID != 0)
{
if (Exists(xxxxb.ID))
{
if (DBHelperSQL.Execute(sqlu, spr) > 0)
{
return(true);
}
else
{
return(false);
}
}
else
if (DBHelperSQL.Execute(sqli, spr) > 0)
{
return(true);
}
else
{
return(false);
}
}
else
if (DBHelperSQL.Execute(sqli, spr) > 0)
{
return(true);
}
else
{
return(false);
}
}
