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