protected void cmdUpdate_Click(object sender, EventArgs e) { Message msg = new Message(g_user_id, g_lang); IMClass.Calendar cal = new IMClass.Calendar(g_user_id, g_lang); ComLibrary com = new ComLibrary(); // Calendarマスタを更新 // 画面から項目を編集 //First Year's Firstday DateTime mDatetime = new DateTime(Convert.ToInt16(ddlYear.Text), 1, 1); //yea int firstweekfirstday = Convert.ToInt32(mDatetime.DayOfWeek); //First Year's Firstday int days = (int)(7 - firstweekfirstday) + 1; cal.calendar_id = "00";//默认00 cal.lang = g_lang; for (int i = 0; i < 15; i++) { cal.calendar_date = Convert.ToInt32(ddlYear.Text + ddlMonth.Text + (Convert.ToInt16(dgvCalendarF.Rows[i].Cells[0].Text)).ToString("0#")); //cal.calendar_cym = Convert.ToInt32(ddlYear.Text + ddlMonth.Text); DateTime datecal = new DateTime(Convert.ToInt32(ddlYear.Text), Convert.ToInt16(ddlMonth.Text), Convert.ToInt16(dgvCalendarF.Rows[i].Cells[0].Text)); //if (datecal.DayOfYear <= days)//first week //{ // cal.week_no = Convert.ToInt32(ddlYear.Text + "01"); //} //else //{ // cal.week_no = Convert.ToInt32(ddlYear.Text + (((datecal.DayOfYear - days - 1) / 7) + 2).ToString("0#")); //} //switch (datecal.DayOfWeek.ToString())//Convert.ToInt32(mDatetime.DayOfWeek) to int //{ // case "Monday": cal.day_of_week = 1; break; // case "Tuesday": cal.day_of_week = 2; break; // case "Wednesday": cal.day_of_week = 3; break; // case "Thursday": cal.day_of_week = 4; break; // case "Friday": cal.day_of_week = 5; break; // case "Saturday": cal.day_of_week = 6; break; // case "Sunday": cal.day_of_week = 7; break; //} //cal.day_of_week = Convert.ToInt16(datecal.DayOfWeek()); if (((CheckBox)dgvCalendarF.Rows[i].FindControl("ckbh1")).Checked) { cal.holiday_flag = 1; } else { cal.holiday_flag = 0; } if (((CheckBox)dgvCalendarF.Rows[i].FindControl("ckbp1")).Checked) { cal.po_rls_flag = 1; } else { cal.po_rls_flag = 0; } if (((TextBox)dgvCalendarF.Rows[i].FindControl("txtWHour1")).Text == "")//|| cal.holiday_flag == 1) { cal.std_working_hour = 0; } else { cal.std_working_hour = com.StringToDouble(((TextBox)dgvCalendarF.Rows[i].FindControl("txtWHour1")).Text.ToString()); } //cal.user_group = ""; //cal.chg_pgm = "MstCalendarMnt"; cal.chg_user_id = g_user_id; int rtn = 0; rtn = cal.Update(); if (rtn == ComConst.FAILED) { lblMsg.Text = cal.strErr; lblMsg.ForeColor = Color.Red; return; } } for (int i = 0; i < DateTime.DaysInMonth(Convert.ToInt16(ddlYear.Text), Convert.ToInt16(ddlMonth.Text)) - 15; i++) { cal.calendar_date = Convert.ToInt32(ddlYear.Text + ddlMonth.Text + Convert.ToInt32(dgvCalendarA.Rows[i].Cells[0].Text).ToString("0#")); //cal.calendar_cym = Convert.ToInt32(ddlYear.Text + ddlMonth.Text); //DateTime datecal = new DateTime(Convert.ToInt32(ddlYear.Text), Convert.ToInt16(ddlMonth.Text), Convert.ToInt16(dgvCalendarA.Rows[i].Cells[0].Text)); //cal.week_no = Convert.ToInt32(ddlYear.Text + (((datecal.DayOfYear - days - 1) / 7) + 2).ToString("0#")); //switch (datecal.DayOfWeek.ToString()) //{ // case "Monday": cal.day_of_week = 1; break; // case "Tuesday": cal.day_of_week = 2; break; // case "Wednesday": cal.day_of_week = 3; break; // case "Thursday": cal.day_of_week = 4; break; // case "Friday": cal.day_of_week = 5; break; // case "Saturday": cal.day_of_week = 6; break; // case "Sunday": cal.day_of_week = 7; break; //} if (((CheckBox)dgvCalendarA.Rows[i].FindControl("ckbh2")).Checked) { cal.holiday_flag = 1; } else { cal.holiday_flag = 0; } if (((CheckBox)dgvCalendarA.Rows[i].FindControl("ckbp2")).Checked) { cal.po_rls_flag = 1; } else { cal.po_rls_flag = 0; } if (((TextBox)dgvCalendarA.Rows[i].FindControl("txtWHour2")).Text == "")//|| cal.holiday_flag == 1) { cal.std_working_hour = 0; } else { cal.std_working_hour = com.StringToDouble(((TextBox)dgvCalendarA.Rows[i].FindControl("txtWHour2")).Text.ToString()); } //cal.user_group = ""; //cal.chg_pgm = "MstCalendarMnt"; cal.chg_user_id = g_user_id; int rtn = 0; rtn = cal.Update(); if (rtn == ComConst.FAILED) { lblMsg.Text = cal.strErr; lblMsg.ForeColor = Color.Red; return; } } cal.calendar_id = "00"; cal.lang = g_lang; cal.calendar_date = com.StringToInt(ddlYear.Text + ddlMonth.Text + "01"); int rtn2 = 0; rtn2 = cal.Work_Days_Update(); if (rtn2 == ComConst.FAILED) { lblMsg.Text = cal.strErr; lblMsg.ForeColor = Color.Red; return; } lblMsg.Text = msg.GetMessage("NORMAL_UPDATE"); lblMsg.ForeColor = Color.Blue; }
// // 初期画面編集 // protected void Init_Proc() { //Auth_Proc();//ADD BY UBIQ-LIU 2010/8/4 //dt用于扩充gridview行列 DataTable dt = new DataTable(); Message msg = new Message(g_user_id, g_lang); for (int i = 0; i < 16; i++) { if (dt.Columns.Count == 0) { dt.Columns.Add("co1"); dt.Columns.Add("co2"); dt.Columns.Add("co3"); dt.Columns.Add("co4"); dt.Columns.Add("co5"); } if (dt.Rows.Count < 16) { dt.Rows.Add(); } } dgvCalendarF.DataSource = dt; dgvCalendarF.DataBind(); dgvCalendarA.DataSource = dt; dgvCalendarA.DataBind(); ComLibrary com = new ComLibrary(); // Calendarマスタを検索 IMClass.Calendar cal = new IMClass.Calendar(g_user_id, g_lang); cal.calendar_id = "00"; cal.calendar_cym = Convert.ToInt32(ddlYear.Text + ddlMonth.Text); DataSet ds = cal.GetCalendarMonthlyDetail(); if (ds == null) { lblMsg.Text = cal.strErr; lblMsg.ForeColor = Color.Red; return; } if (ds.Tables[0].Rows.Count != 0) { //前半月 for (int i = 0; i < dgvCalendarF.Rows.Count; i++) { dgvCalendarF.Rows[i].Cells[0].Text = ds.Tables[0].Rows[i]["Calendar_date"].ToString().Substring(6, 2); switch (ds.Tables[0].Rows[i]["Day_of_week"].ToString()) { case "1": dgvCalendarF.Rows[i].Cells[1].Text = ViewState["weekday1"].ToString(); break; case "2": dgvCalendarF.Rows[i].Cells[1].Text = ViewState["weekday2"].ToString(); break; case "3": dgvCalendarF.Rows[i].Cells[1].Text = ViewState["weekday3"].ToString(); break; case "4": dgvCalendarF.Rows[i].Cells[1].Text = ViewState["weekday4"].ToString(); break; case "5": dgvCalendarF.Rows[i].Cells[1].Text = ViewState["weekday5"].ToString(); break; case "6": dgvCalendarF.Rows[i].Cells[1].Text = ViewState["weekday6"].ToString(); break; case "7": dgvCalendarF.Rows[i].Cells[1].Text = ViewState["weekday7"].ToString(); break; } ((CheckBox)dgvCalendarF.Rows[i].FindControl("ckbh1")).Checked = com.IntToBool(com.StringToInt(ds.Tables[0].Rows[i]["HOLIDAY_FLAG"].ToString())); //((CheckBox)dgvCalendarF.Rows[i].FindControl("ckbp1")).Checked = com.IntToBool(com.StringToInt(ds.Tables[0].Rows[i]["PO_RLS_FLAG"].ToString())); ((CheckBox)dgvCalendarF.Rows[i].FindControl("ckbp1")).Checked = com.IntToBool(com.StringToInt(ds.Tables[0].Rows[i]["PROCESS_FLAG"].ToString())); //if (com.StringToDouble(ds.Tables[0].Rows[i]["STD_WORKING_HOUR"].ToString()) != 0) //{ // ((TextBox)dgvCalendarF.Rows[i].FindControl("txtWHour1")).Text = ds.Tables[0].Rows[i]["STD_WORKING_HOUR"].ToString(); //} if (com.StringToDouble(ds.Tables[0].Rows[i]["STD_WORKING"].ToString()) != 0) { ((TextBox)dgvCalendarF.Rows[i].FindControl("txtWHour1")).Text = ds.Tables[0].Rows[i]["STD_WORKING"].ToString(); } //else //{ // ((TextBox)dgvCalendarF.Rows[i].FindControl("txtWHour1")).Text = ""; //} } dgvCalendarF.Rows[15].Visible = false; //后半月 for (int i = 0; i < dgvCalendarA.Rows.Count; i++) { if (i < DateTime.DaysInMonth(Convert.ToInt16(ddlYear.Text), Convert.ToInt16(ddlMonth.Text)) - 15) { dgvCalendarA.Rows[i].Cells[0].Text = ds.Tables[0].Rows[i + 15]["Calendar_date"].ToString().Substring(6, 2); switch (ds.Tables[0].Rows[i + 15]["Day_of_week"].ToString()) { case "1": dgvCalendarA.Rows[i].Cells[1].Text = ViewState["weekday1"].ToString(); break; case "2": dgvCalendarA.Rows[i].Cells[1].Text = ViewState["weekday2"].ToString(); break; case "3": dgvCalendarA.Rows[i].Cells[1].Text = ViewState["weekday3"].ToString(); break; case "4": dgvCalendarA.Rows[i].Cells[1].Text = ViewState["weekday4"].ToString(); break; case "5": dgvCalendarA.Rows[i].Cells[1].Text = ViewState["weekday5"].ToString(); break; case "6": dgvCalendarA.Rows[i].Cells[1].Text = ViewState["weekday6"].ToString(); break; case "7": dgvCalendarA.Rows[i].Cells[1].Text = ViewState["weekday7"].ToString(); break; } ((CheckBox)dgvCalendarA.Rows[i].FindControl("ckbh2")).Checked = com.IntToBool(com.StringToInt(ds.Tables[0].Rows[i + 15]["HOLIDAY_FLAG"].ToString())); //((CheckBox)dgvCalendarA.Rows[i].FindControl("ckbp2")).Checked = com.IntToBool(com.StringToInt(ds.Tables[0].Rows[i + 15]["PO_RLS_FLAG"].ToString())); ((CheckBox)dgvCalendarA.Rows[i].FindControl("ckbp2")).Checked = com.IntToBool(com.StringToInt(ds.Tables[0].Rows[i + 15]["PROCESS_FLAG"].ToString())); //if (com.StringToDouble(ds.Tables[0].Rows[i + 15]["STD_WORKING_HOUR"].ToString()) != 0) //{ // ((TextBox)dgvCalendarA.Rows[i].FindControl("txtWHour2")).Text = ds.Tables[0].Rows[i + 15]["STD_WORKING_HOUR"].ToString(); //} if (com.StringToDouble(ds.Tables[0].Rows[i + 15]["STD_WORKING"].ToString()) != 0) { ((TextBox)dgvCalendarA.Rows[i].FindControl("txtWHour2")).Text = ds.Tables[0].Rows[i + 15]["STD_WORKING"].ToString(); } //else //set text = "" then the text well change to 0.00 //{ // ((TextBox)dgvCalendarA.Rows[i].FindControl("txtWHour2")).Text = ""; //} } else { dgvCalendarA.Rows[i].Visible = false; } } //cmdUpdate.Enabled = true;//DEL BY UBIQ-LIU 2010/8/4 //switch (g_lang) //{ // case 1: // //cmdDisp.ImageUrl = "../../Contents/Image/BackGround/btn-ind1-1.jpg"; // cmdUpdate.ImageUrl = "../../Contents/Image/BackGround/btn-update1-1.jpg"; // break; // case 2: // //cmdDisp.ImageUrl = "../../Contents/Image/BackGround/btn-ind1-2.jpg"; // cmdUpdate.ImageUrl = "../../Contents/Image/BackGround/btn-update1-2.jpg"; // break; // case 3: // //cmdDisp.ImageUrl = "../../Contents/Image/BackGround/btn-ind1-3.jpg"; // cmdUpdate.ImageUrl = "../../Contents/Image/BackGround/btn-update1-3.jpg"; // break; // case 4: // //cmdDisp.ImageUrl = "../../Contents/Image/BackGround/btn-ind1-4.jpg"; // cmdUpdate.ImageUrl = "../../Contents/Image/BackGround/btn-update1-4.jpg"; // break; //} } else { lblMsg.Text = msg.GetMessage("NOT_EXIST_ERR"); lblMsg.ForeColor = Color.Red; return; } }