/// <summary> /// 得到一个对象实体 /// </summary> public MobileSoft.Model.SQMSys.Tb_Sys_Message GetModel(Guid MessageCode, long CutID) { SqlParameter[] parameters = { new SqlParameter("@MessageCode", SqlDbType.UniqueIdentifier), new SqlParameter("@CutID", SqlDbType.BigInt) }; parameters[0].Value = MessageCode; parameters[1].Value = CutID; MobileSoft.Model.SQMSys.Tb_Sys_Message model = new MobileSoft.Model.SQMSys.Tb_Sys_Message(); DataSet ds = DbHelperSQL.RunProcedure("Proc_Tb_Sys_Message_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["MessageCode"].ToString() != "") { model.MessageCode = new Guid(ds.Tables[0].Rows[0]["MessageCode"].ToString()); } if (ds.Tables[0].Rows[0]["CutID"].ToString() != "") { model.CutID = long.Parse(ds.Tables[0].Rows[0]["CutID"].ToString()); } model.UserCode = ds.Tables[0].Rows[0]["UserCode"].ToString(); model.MsgTitle = ds.Tables[0].Rows[0]["MsgTitle"].ToString(); model.Content = ds.Tables[0].Rows[0]["Content"].ToString(); if (ds.Tables[0].Rows[0]["SendTime"].ToString() != "") { model.SendTime = DateTime.Parse(ds.Tables[0].Rows[0]["SendTime"].ToString()); } if (ds.Tables[0].Rows[0]["MsgType"].ToString() != "") { model.MsgType = int.Parse(ds.Tables[0].Rows[0]["MsgType"].ToString()); } model.SendMan = ds.Tables[0].Rows[0]["SendMan"].ToString(); if (ds.Tables[0].Rows[0]["MsgState"].ToString() != "") { model.MsgState = int.Parse(ds.Tables[0].Rows[0]["MsgState"].ToString()); } if (ds.Tables[0].Rows[0]["IsDeleteSend"].ToString() != "") { model.IsDeleteSend = int.Parse(ds.Tables[0].Rows[0]["IsDeleteSend"].ToString()); } if (ds.Tables[0].Rows[0]["IsDeleteRead"].ToString() != "") { model.IsDeleteRead = int.Parse(ds.Tables[0].Rows[0]["IsDeleteRead"].ToString()); } model.URL = ds.Tables[0].Rows[0]["URL"].ToString(); model.HaveSendUsers = ds.Tables[0].Rows[0]["HaveSendUsers"].ToString(); if (ds.Tables[0].Rows[0]["IsRemind"].ToString() != "") { model.IsRemind = int.Parse(ds.Tables[0].Rows[0]["IsRemind"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(MobileSoft.Model.SQMSys.Tb_Sys_Message model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@MessageCode", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@CutID", SqlDbType.BigInt, 8), new SqlParameter("@UserCode", SqlDbType.NVarChar, 20), new SqlParameter("@MsgTitle", SqlDbType.NVarChar, 4000), new SqlParameter("@Content", SqlDbType.NText), new SqlParameter("@SendTime", SqlDbType.DateTime), new SqlParameter("@MsgType", SqlDbType.SmallInt, 2), new SqlParameter("@SendMan", SqlDbType.NVarChar, 20), new SqlParameter("@MsgState", SqlDbType.SmallInt, 2), new SqlParameter("@IsDeleteSend", SqlDbType.SmallInt, 2), new SqlParameter("@IsDeleteRead", SqlDbType.SmallInt, 2), new SqlParameter("@URL", SqlDbType.NText), new SqlParameter("@HaveSendUsers", SqlDbType.NText), new SqlParameter("@IsRemind", SqlDbType.Int, 4) }; parameters[0].Value = model.MessageCode; parameters[1].Direction = ParameterDirection.Output; parameters[2].Value = model.UserCode; parameters[3].Value = model.MsgTitle; parameters[4].Value = model.Content; parameters[5].Value = model.SendTime; parameters[6].Value = model.MsgType; parameters[7].Value = model.SendMan; parameters[8].Value = model.MsgState; parameters[9].Value = model.IsDeleteSend; parameters[10].Value = model.IsDeleteRead; parameters[11].Value = model.URL; parameters[12].Value = model.HaveSendUsers; parameters[13].Value = model.IsRemind; DbHelperSQL.RunProcedure("Proc_Tb_Sys_Message_ADD", parameters, out rowsAffected); return((int)parameters[1].Value); }