private List <RoadFlow.Data.Model.WorkCalendar> DataReaderToList(OracleDataReader dataReader) { List <RoadFlow.Data.Model.WorkCalendar> list = new List <RoadFlow.Data.Model.WorkCalendar>(); RoadFlow.Data.Model.WorkCalendar workCalendar = null; while (((DbDataReader)dataReader).Read()) { workCalendar = new RoadFlow.Data.Model.WorkCalendar(); workCalendar.WorkDate = ((DbDataReader)dataReader).GetDateTime(0); list.Add(workCalendar); } return(list); }
public int Update(RoadFlow.Data.Model.WorkCalendar model) { string sql = "UPDATE WorkCalendar SET \r\n\t\t\t\t\r\n\t\t\t\tWHERE WorkDate=@WorkDate"; SqlParameter[] parameter = new SqlParameter[1] { new SqlParameter("@WorkDate", SqlDbType.Date, -1) { Value = model.WorkDate } }; return(dbHelper.Execute(sql, parameter)); }
public int Add(RoadFlow.Data.Model.WorkCalendar model) { string sql = "INSERT INTO WorkCalendar\r\n\t\t\t\t(WorkDate) \r\n\t\t\t\tVALUES(@WorkDate)"; SqlParameter[] parameter = new SqlParameter[1] { new SqlParameter("@WorkDate", SqlDbType.Date, -1) { Value = model.WorkDate } }; return(dbHelper.Execute(sql, parameter)); }
public int Update(RoadFlow.Data.Model.WorkCalendar model) { //IL_0015: Unknown result type (might be due to invalid IL or missing references) //IL_001a: Unknown result type (might be due to invalid IL or missing references) //IL_002b: Expected O, but got Unknown //IL_002c: Expected O, but got Unknown string sql = "UPDATE WorkCalendar SET \r\n\t\t\t\tWHERE WorkDate=:WorkDate"; OracleParameter[] obj = new OracleParameter[1]; OracleParameter val = new OracleParameter("@WorkDate", 106); ((DbParameter)val).Value = model.WorkDate; obj[0] = val; OracleParameter[] parameter = (OracleParameter[])obj; return(dbHelper.Execute(sql, parameter)); }
public int Add(RoadFlow.Data.Model.WorkCalendar model) { //IL_0016: Unknown result type (might be due to invalid IL or missing references) //IL_001b: Unknown result type (might be due to invalid IL or missing references) //IL_002c: Expected O, but got Unknown //IL_002d: Expected O, but got Unknown string sql = "INSERT INTO workcalendar\r\n\t\t\t\t(WorkDate) \r\n\t\t\t\tVALUES(@WorkDate)"; MySqlParameter[] obj = new MySqlParameter[1]; MySqlParameter val = new MySqlParameter("@WorkDate", 10, -1); ((DbParameter)val).Value = model.WorkDate; obj[0] = val; MySqlParameter[] parameter = (MySqlParameter[])obj; return(dbHelper.Execute(sql, parameter)); }
public ActionResult Index(FormCollection collection) { RoadFlow.Data.MSSQL.WorkCalendar workCalendar = new RoadFlow.Data.MSSQL.WorkCalendar(); int num = base.Request.Form["DropDownList1"].IsNullOrEmpty() ? DateTimeNew.Now.Year : base.Request.Form["DropDownList1"].ToInt(); if (!base.Request.Form["saveBut"].IsNullOrEmpty()) { string text = base.Request.Form["workdate"] ?? ""; string text2 = base.Request.Form["year1"]; using (TransactionScope transactionScope = new TransactionScope()) { workCalendar.Delete(text2.ToInt()); foreach (string item in text.Split(new char[1] { ',' }, StringSplitOptions.RemoveEmptyEntries).Distinct()) { if (item.IsDateTime()) { RoadFlow.Data.Model.WorkCalendar workCalendar2 = new RoadFlow.Data.Model.WorkCalendar(); workCalendar2.WorkDate = item.ToDateTime(); workCalendar.Add(workCalendar2); } } transactionScope.Complete(); } Opation.Remove("WorkCalendar_" + text2); RoadFlow.Platform.Log.Add("设置了工作日历", text, RoadFlow.Platform.Log.Types.系统管理); base.ViewBag.script = "alert('保存成功!')"; } StringBuilder stringBuilder = new StringBuilder(); for (int i = 2016; i < 2099; i++) { stringBuilder.Append("<option value='" + i + "'" + ((i == num) ? "selected='selected'" : "") + ">" + i + "</option>"); } List <RoadFlow.Data.Model.WorkCalendar> all = workCalendar.GetAll(num); base.ViewBag.options = stringBuilder; base.ViewBag.year = num; return(View(all)); }
public int Update(RoadFlow.Data.Model.WorkCalendar model) { return(dataWorkCalendar.Update(model)); }
public int Add(RoadFlow.Data.Model.WorkCalendar model) { return(dataWorkCalendar.Add(model)); }