/// <summary> /// 获得数据列表 /// </summary> public List <MobileSoft.Model.SQMSys.Tb_Sys_UserCalendar> DataTableToList(DataTable dt) { List <MobileSoft.Model.SQMSys.Tb_Sys_UserCalendar> modelList = new List <MobileSoft.Model.SQMSys.Tb_Sys_UserCalendar>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { MobileSoft.Model.SQMSys.Tb_Sys_UserCalendar model; for (int n = 0; n < rowsCount; n++) { model = new MobileSoft.Model.SQMSys.Tb_Sys_UserCalendar(); if (dt.Rows[n]["UserCalendarCode"].ToString() != "") { model.UserCalendarCode = new Guid(dt.Rows[n]["UserCalendarCode"].ToString()); } model.UserCode = dt.Rows[n]["UserCode"].ToString(); model.Title = dt.Rows[n]["Title"].ToString(); model.Place = dt.Rows[n]["Place"].ToString(); if (dt.Rows[n]["StartTime"].ToString() != "") { model.StartTime = DateTime.Parse(dt.Rows[n]["StartTime"].ToString()); } if (dt.Rows[n]["EndTime"].ToString() != "") { model.EndTime = DateTime.Parse(dt.Rows[n]["EndTime"].ToString()); } model.Scratchpad = dt.Rows[n]["Scratchpad"].ToString(); if (dt.Rows[n]["IsRemind"].ToString() != "") { model.IsRemind = int.Parse(dt.Rows[n]["IsRemind"].ToString()); } if (dt.Rows[n]["RemindHours"].ToString() != "") { model.RemindHours = decimal.Parse(dt.Rows[n]["RemindHours"].ToString()); } if (dt.Rows[n]["RemindState"].ToString() != "") { model.RemindState = int.Parse(dt.Rows[n]["RemindState"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(MobileSoft.Model.SQMSys.Tb_Sys_UserCalendar model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(MobileSoft.Model.SQMSys.Tb_Sys_UserCalendar model) { dal.Add(model); }