예제 #1
0
        /// <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);
        }
예제 #2
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public void Update(MobileSoft.Model.SQMSys.Tb_Sys_Message model)
 {
     dal.Update(model);
 }
예제 #3
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int  Add(MobileSoft.Model.SQMSys.Tb_Sys_Message model)
 {
     return(dal.Add(model));
 }