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));
}
