/// <summary> /// 获得数据列表 /// </summary> public List <MobileSoft.Model.SQMSys.Tb_Sys_Message> DataTableToList(DataTable dt) { List <MobileSoft.Model.SQMSys.Tb_Sys_Message> modelList = new List <MobileSoft.Model.SQMSys.Tb_Sys_Message>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { MobileSoft.Model.SQMSys.Tb_Sys_Message model; for (int n = 0; n < rowsCount; n++) { model = new MobileSoft.Model.SQMSys.Tb_Sys_Message(); if (dt.Rows[n]["MessageCode"].ToString() != "") { model.MessageCode = new Guid(dt.Rows[n]["MessageCode"].ToString()); } //model.CutID=dt.Rows[n]["CutID"].ToString(); model.UserCode = dt.Rows[n]["UserCode"].ToString(); model.MsgTitle = dt.Rows[n]["MsgTitle"].ToString(); model.Content = dt.Rows[n]["Content"].ToString(); if (dt.Rows[n]["SendTime"].ToString() != "") { model.SendTime = DateTime.Parse(dt.Rows[n]["SendTime"].ToString()); } if (dt.Rows[n]["MsgType"].ToString() != "") { model.MsgType = int.Parse(dt.Rows[n]["MsgType"].ToString()); } model.SendMan = dt.Rows[n]["SendMan"].ToString(); if (dt.Rows[n]["MsgState"].ToString() != "") { model.MsgState = int.Parse(dt.Rows[n]["MsgState"].ToString()); } if (dt.Rows[n]["IsDeleteSend"].ToString() != "") { model.IsDeleteSend = int.Parse(dt.Rows[n]["IsDeleteSend"].ToString()); } if (dt.Rows[n]["IsDeleteRead"].ToString() != "") { model.IsDeleteRead = int.Parse(dt.Rows[n]["IsDeleteRead"].ToString()); } model.URL = dt.Rows[n]["URL"].ToString(); model.HaveSendUsers = dt.Rows[n]["HaveSendUsers"].ToString(); if (dt.Rows[n]["IsRemind"].ToString() != "") { model.IsRemind = int.Parse(dt.Rows[n]["IsRemind"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(MobileSoft.Model.SQMSys.Tb_Sys_Message model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(MobileSoft.Model.SQMSys.Tb_Sys_Message model) { return(dal.Add(model)); }