public ActionResult OrgProjectEdit(Mirroracc organization, string button) { //if (ModelState.IsValid) //{ int YearCode = 2020; DateTime InsDate = DateTime.Now; int mdcodes = 0; double data01 = 0; string data02 = null; switch (button) { case "tab7save": { int project_id = Convert.ToInt32(Session["ProjectIDs"].ToString()); int org_id = Convert.ToInt32(Session["OrganizationIDs"].ToString()); string project_name = organization.tab7[2].Data02; string project_num = organization.tab7[3].Data02; string project_start_date = organization.tab7[7].Data02; string project_end_date = organization.tab7[8].Data02; int project_percent = Convert.ToInt32(organization.tab7[9].Data01); string project_budget = organization.tab7[10].Data01.ToString(); string project_fund = organization.tab7[1].Data02; int project_law_num = organization.AUD_LAWS_NUM; int is_active = 1; for (int i = 0; i < organization.tab7.Count(); i++) { mdcodes = Convert.ToInt32(organization.tab7[i].MD_CODE); data01 = Convert.ToDouble(organization.tab7[i].Data01); data02 = organization.tab7[i].Data02; var result = AppStatic.SystemController.OrgProjectInsert(YearCode, org_id, project_name, project_num, project_start_date, project_end_date, project_percent, project_budget, project_fund, mdcodes, data01, data02, Convert.ToInt32(User.Identity.GetUserId()), InsDate, project_law_num, project_id, is_active); } } break; } var result1 = true; //return RedirectToAction("Index", "Shilendans"); //return Json(new { error = false, message = AppStatic.SystemController.Message }); try { if (result1 == true) { return(ViewBag.Results = AppStatic.SystemController.Message); } else { ViewBag.No = "Хадгалахад алдаа гарлаа !!!"; } } catch (Exception ex) { Globals.WriteErrorLog(ex); } //} //else //{ // ViewBag.No = "Энэ мэдээлэл мэдээллийн санд байхгүй байна."; //} return(PartialView(organization)); }
public ActionResult AddShilenDans(Mirroracc organization) { return(PartialView(organization)); }
public ActionResult AddShilenDans(Mirroracc organization, string button) { //if (TryValidateModel(organization.tab1[0].Data01)) //{ if (organization.OPEN_ID != 0) { int YearCode = 2021; DateTime InsDate = DateTime.Now; int mdcodes = 0; double data01 = 0; string data02 = null; int is_finish = 0; switch (button) { case "tab1save": { for (int i = 0; i < organization.tab1.Count(); i++) { mdcodes = Convert.ToInt32(organization.tab1[i].MD_CODE); data01 = Convert.ToDouble(organization.tab1[i].Data01); data02 = " "; is_finish = 0; var result = AppStatic.SystemController.MirrorAccInsert(YearCode, Convert.ToInt32(organization.OPEN_ID), mdcodes, data01, data02, is_finish, Convert.ToInt32(User.Identity.GetUserId()), InsDate); } ViewBag.Tabid = "#maygt1-1"; } break; case "tab2save": { for (int i = 0; i < organization.tab2.Count(); i++) { mdcodes = Convert.ToInt32(organization.tab2[i].MD_CODE); data01 = Convert.ToDouble(organization.tab2[i].Data01); data02 = " "; is_finish = 0; var result = AppStatic.SystemController.MirrorAccInsert(YearCode, Convert.ToInt32(organization.OPEN_ID), mdcodes, data01, data02, is_finish, Convert.ToInt32(User.Identity.GetUserId()), InsDate); } ViewBag.Tabid = "#maygt1-2"; } break; case "tab3save": { for (int i = 0; i < organization.tab3.Count(); i++) { mdcodes = Convert.ToInt32(organization.tab3[i].MD_CODE); data01 = Convert.ToDouble(organization.tab3[i].Data01); data02 = " "; is_finish = 0; var result = AppStatic.SystemController.MirrorAccInsert(YearCode, Convert.ToInt32(organization.OPEN_ID), mdcodes, data01, data02, is_finish, Convert.ToInt32(User.Identity.GetUserId()), InsDate); } ViewBag.Tabid = "#maygt1-3"; } break; case "tab4save": { for (int i = 0; i < organization.tab4.Count(); i++) { mdcodes = Convert.ToInt32(organization.tab4[i].MD_CODE); data01 = Convert.ToDouble(organization.tab4[i].Data01); data02 = organization.tab4[i].Data02; is_finish = 1; var result = AppStatic.SystemController.MirrorAccInsert(YearCode, Convert.ToInt32(organization.OPEN_ID), mdcodes, data01, data02, is_finish, Convert.ToInt32(User.Identity.GetUserId()), InsDate); } ViewBag.Tabid = "#maygt1-4"; } break; case "tab5save": { for (int i = 0; i < organization.tab5.Count(); i++) { mdcodes = Convert.ToInt32(organization.tab5[i].MD_CODE); data01 = Convert.ToDouble(organization.tab5[i].Data01); data02 = " "; is_finish = 0; var result = AppStatic.SystemController.MirrorAccInsert(YearCode, Convert.ToInt32(organization.OPEN_ID), mdcodes, data01, data02, is_finish, Convert.ToInt32(User.Identity.GetUserId()), InsDate); } ViewBag.Tabid = "#maygt2"; } break; case "tab6save": { for (int i = 0; i < organization.tab6.Count(); i++) { mdcodes = Convert.ToInt32(organization.tab6[i].MD_CODE); data01 = Convert.ToDouble(organization.tab6[i].Data01); data02 = organization.tab6[i].Data02; is_finish = 1; var result = AppStatic.SystemController.MirrorAccInsert(YearCode, Convert.ToInt32(organization.OPEN_ID), mdcodes, data01, data02, is_finish, Convert.ToInt32(User.Identity.GetUserId()), InsDate); } ViewBag.Tabid = "#maygt2-2"; } break; case "tab7save": { Random rand = new Random(); string project_name = organization.tab7[2].Data02; string project_num = organization.tab7[3].Data02; string project_start_date = organization.tab7[7].Data02; string project_end_date = organization.tab7[8].Data02; int project_percent = Convert.ToInt32(organization.tab7[9].Data01); string project_budget = organization.tab7[10].Data01.ToString(); string project_fund = organization.tab7[1].Data02; int project_law_num = organization.AUD_LAWS_NUM; int project_id = rand.Next(100000, 999999); int project_is_active = 1; for (int i = 0; i < organization.tab7.Count(); i++) { mdcodes = Convert.ToInt32(organization.tab7[i].MD_CODE); data01 = Convert.ToDouble(organization.tab7[i].Data01); data02 = organization.tab7[i].Data02; var result = AppStatic.SystemController.OrgProjectInsert(YearCode, Convert.ToInt32(organization.OPEN_ID), project_name, project_num, project_start_date, project_end_date, project_percent, project_budget, project_fund, mdcodes, data01, data02, Convert.ToInt32(User.Identity.GetUserId()), InsDate, project_law_num, project_id, project_is_active); } ViewBag.ModalID = "#InsertProjectModal"; } break; } var result1 = true; //return ViewBag.Tabid = "maygt1-2"; try { if (result1 == true) { //return Json(new { error = false, message = AppStatic.SystemController.Message }); ViewBag.Results = AppStatic.SystemController.Message; return(ViewBag); } else { ViewBag.Results = "Хадгалахад алдаа гарлаа !!!"; } } catch (Exception ex) { Globals.WriteErrorLog(ex, organization.OPEN_ID + "_!_" + button); } } //} //else //{ // return View(organization); //} return(PartialView(organization)); }
public ActionResult OrgDetail(int openid) { try { XElement res = AppStatic.SystemController.MirrorOrgDetail(openid); if (res != null && res.Elements("MirrorOrgDetail") != null) { organization = new Mirroracc().FromXml(res.Element("MirrorOrgDetail")); if (organization.OPEN_ENT_NAME != null) { Session["print_open_ent_name"] = organization.OPEN_ENT_NAME; } else { Session["print_open_ent_name"] = ""; } if (organization.OPEN_HEAD_NAME != null) { Session["print_open_head_name"] = organization.OPEN_HEAD_NAME; } else { Session["print_open_head_name"] = ""; } if (organization.OPEN_ACC_NAME != null) { Session["print_open_acc_name"] = organization.OPEN_ACC_NAME; } else { Session["print_open_acc_name"] = ""; } } XElement tb1res = AppStatic.SystemController.Table1List(openid); XElement tblprojectlist = AppStatic.SystemController.TableProjectList(Convert.ToInt32(organization.OPEN_ID)); DataSet ds = new DataSet(); DataSet ds1 = new DataSet(); StringReader sr = new StringReader(tb1res.ToString()); StringReader sr2 = new StringReader(tblprojectlist.ToString()); ds.ReadXml(sr, XmlReadMode.InferSchema); ds1.ReadXml(sr2, XmlReadMode.InferSchema); DataRow[] table1 = ds.Tables[0].Select(); DataRow[] table2 = ds.Tables[0].Select("TAB_ID = " + 2); DataRow[] table3 = ds.Tables[0].Select("TAB_ID = " + 3); DataRow[] table4 = ds.Tables[0].Select("TAB_ID = " + 4); DataRow[] table5 = ds.Tables[0].Select(); DataRow[] table6 = ds.Tables[0].Select("TAB_ID = " + 6); //DataRow[] table7 = ds.Tables[0].Select("TAB_ID = " + 7); if (ds1.Tables.Count > 0) { DataRow[] table8 = ds1.Tables[0].Select(); organization.tab8 = new List <Tab8>(); for (int i = 0; i < table8.Length; i++) { organization.tab8.Add( new Tab8 { PROJECT_NAME = table8[i].Field <string>("PROJECT_NAME"), PROJECT_NUMBER = table8[i].Field <string>("PROJECT_NUMBER"), PROJECT_START_DATE = table8[i].Field <string>("PROJECT_START_DATE"), PROJECT_END_DATE = table8[i].Field <string>("PROJECT_END_DATE"), PROJECT_PERCENT = table8[i].Field <string>("PROJECT_PERCENT"), PROJECT_TOTAL_BUDGET = table8[i].Field <string>("PROJECT_TOTAL_BUDGET"), PROJECT_ORG_FUND = table8[i].Field <string>("PROJECT_ORG_FUND"), PROJECT_ID = table8[i].Field <string>("PROJECT_ID"), ORG_ID = openid } ); } } organization.tab1 = new List <Tab1>(); organization.tab2 = new List <Tab2>(); organization.tab3 = new List <Tab3>(); organization.tab4 = new List <Tab4>(); organization.tab5 = new List <Tab5>(); organization.tab6 = new List <Tab6>(); //organization.tab7 = new List<Tab7>(); XElement MirrOrgDataLists = AppStatic.SystemController.MirrDataList(openid); DataSet DsTables = new DataSet(); StringReader sr1 = new StringReader(MirrOrgDataLists.ToString()); DsTables.ReadXml(sr1, XmlReadMode.InferSchema); if (DsTables != null && DsTables.Tables.Count > 0) { for (int i = 0; i < table1.Length; i++) { var md = Convert.ToInt32(table1[i].Field <string>("MD_CODE")); organization.tab1.Add( new Tab1 { MD_CODE = table1[i].Field <string>("MD_CODE"), MD_LAWS_NUM = table1[i].Field <string>("MD_LAWS_NUM"), MD_NAME = table1[i].Field <string>("MD_NAME"), MD_TIME = table1[i].Field <string>("MD_TIME"), Data01 = Convert.ToDouble(DsTables.Tables["MirrDataList"].Rows[md - 1].Field <string>("DATA01")) } ); } for (int i = 0; i < table2.Length; i++) { var md = Convert.ToInt32(table2[i].Field <string>("MD_CODE")); organization.tab2.Add( new Tab2 { MD_CODE = table2[i].Field <string>("MD_CODE"), MD_LAWS_NUM = table2[i].Field <string>("MD_LAWS_NUM"), MD_NAME = table2[i].Field <string>("MD_NAME"), MD_TIME = table2[i].Field <string>("MD_TIME"), Data01 = DsTables.Tables["MirrDataList"].Rows[md - 1].Field <string>("DATA01") } ); } for (int i = 0; i < table3.Length; i++) { var md = Convert.ToInt32(table3[i].Field <string>("MD_CODE")); organization.tab3.Add( new Tab3 { MD_CODE = table3[i].Field <string>("MD_CODE"), MD_LAWS_NUM = table3[i].Field <string>("MD_LAWS_NUM"), MD_NAME = table3[i].Field <string>("MD_NAME"), MD_TIME = table3[i].Field <string>("MD_TIME"), Data01 = DsTables.Tables["MirrDataList"].Rows[md - 1].Field <string>("DATA01") } ); } for (int i = 0; i < table4.Length; i++) { if (DsTables.Tables["MirrDataList"].Rows[111].Field <string>("DATA02") != null) { Session["Print1Val1"] = DsTables.Tables["MirrDataList"].Rows[111].Field <string>("DATA02"); } else { Session["Print1Val1"] = ""; } if (DsTables.Tables["MirrDataList"].Rows[112].Field <string>("DATA02") != null) { Session["Print1Val2"] = DsTables.Tables["MirrDataList"].Rows[112].Field <string>("DATA02"); } else { Session["Print1Val2"] = ""; } var md = Convert.ToInt32(table4[i].Field <string>("MD_CODE")); organization.tab4.Add( new Tab4 { MD_CODE = table4[i].Field <string>("MD_CODE"), MD_LAWS_NUM = table4[i].Field <string>("MD_LAWS_NUM"), MD_NAME = table4[i].Field <string>("MD_NAME"), MD_TIME = table4[i].Field <string>("MD_TIME"), Data01 = Convert.ToDouble(DsTables.Tables["MirrDataList"].Rows[md - 1].Field <string>("DATA01")), Data02 = DsTables.Tables["MirrDataList"].Rows[md - 1].Field <string>("DATA02"), Data2020 = DsTables.Tables["MirrDataList"].Rows[md - 1].Field <string>("DATA2020") } ); } for (int i = 0; i < table5.Length; i++) { var md = Convert.ToInt32(table5[i].Field <string>("MD_CODE")); organization.tab5.Add( new Tab5 { MD_CODE = table5[i].Field <string>("MD_CODE"), MD_LAWS_NUM = table5[i].Field <string>("MD_LAWS_NUM"), MD_NAME = table5[i].Field <string>("MD_NAME"), MD_TIME = table5[i].Field <string>("MD_TIME"), Data01 = DsTables.Tables["MirrDataList"].Rows[md - 1].Field <string>("DATA01") } ); } for (int i = 0; i < table6.Length; i++) { if (DsTables.Tables["MirrDataList"].Rows[169].Field <string>("DATA02") != null) { Session["Print2Val1"] = DsTables.Tables["MirrDataList"].Rows[169].Field <string>("DATA02"); } else { Session["Print2Val1"] = ""; } if (DsTables.Tables["MirrDataList"].Rows[170].Field <string>("DATA02") != null) { Session["Print2Val2"] = DsTables.Tables["MirrDataList"].Rows[170].Field <string>("DATA02"); } else { Session["Print2Val2"] = ""; } var md = Convert.ToInt32(table6[i].Field <string>("MD_CODE")); organization.tab6.Add( new Tab6 { MD_CODE = table6[i].Field <string>("MD_CODE"), MD_LAWS_NUM = table6[i].Field <string>("MD_LAWS_NUM"), MD_NAME = table6[i].Field <string>("MD_NAME"), MD_TIME = table6[i].Field <string>("MD_TIME"), Data01 = Convert.ToDouble(DsTables.Tables["MirrDataList"].Rows[md - 1].Field <string>("DATA01")), Data02 = DsTables.Tables["MirrDataList"].Rows[md - 1].Field <string>("DATA02"), Data2020 = DsTables.Tables["MirrDataList"].Rows[md - 1].Field <string>("DATA2020") } ); } //for (int i = 0; i < table7.Length; i++) //{ // var md = Convert.ToInt32(table7[i].Field<string>("MD_CODE")); // organization.tab7.Add( // new Tab7 // { // MD_CODE = table7[i].Field<string>("MD_CODE"), // MD_LAWS_NUM = table7[i].Field<string>("MD_LAWS_NUM"), // MD_NAME = table7[i].Field<string>("MD_NAME"), // MD_TIME = table7[i].Field<string>("MD_TIME"), // Data01 = DsTables.Tables["MirrDataList"].Rows[md - 1].Field<string>("DATA01"), // Data02 = DsTables.Tables["MirrDataList"].Rows[md - 1].Field<string>("DATA02") // } // ); //} } else { for (int i = 0; i < table1.Length; i++) { organization.tab1.Add(new Tab1 { MD_CODE = table1[i].Field <string>("MD_CODE"), MD_LAWS_NUM = table1[i].Field <string>("MD_LAWS_NUM"), MD_NAME = table1[i].Field <string>("MD_NAME"), MD_TIME = table1[i].Field <string>("MD_TIME"), Data01 = 0 }); } for (int i = 0; i < table2.Length; i++) { organization.tab2.Add(new Tab2 { MD_CODE = table2[i].Field <string>("MD_CODE"), MD_LAWS_NUM = table2[i].Field <string>("MD_LAWS_NUM"), MD_NAME = table2[i].Field <string>("MD_NAME"), MD_TIME = table2[i].Field <string>("MD_TIME"), Data01 = null }); } for (int i = 0; i < table3.Length; i++) { organization.tab3.Add(new Tab3 { MD_CODE = table3[i].Field <string>("MD_CODE"), MD_LAWS_NUM = table3[i].Field <string>("MD_LAWS_NUM"), MD_NAME = table3[i].Field <string>("MD_NAME"), MD_TIME = table3[i].Field <string>("MD_TIME"), Data01 = null }); } for (int i = 0; i < table4.Length; i++) { organization.tab4.Add(new Tab4 { MD_CODE = table4[i].Field <string>("MD_CODE"), MD_NAME = table4[i].Field <string>("MD_NAME"), Data01 = 0.00, Data02 = null, Data2020 = table4[i].Field <string>("DATA2020") }); } for (int i = 0; i < table5.Length; i++) { organization.tab5.Add(new Tab5 { MD_CODE = table5[i].Field <string>("MD_CODE"), MD_LAWS_NUM = table5[i].Field <string>("MD_LAWS_NUM"), MD_NAME = table5[i].Field <string>("MD_NAME"), MD_TIME = table5[i].Field <string>("MD_TIME"), Data01 = null }); } for (int i = 0; i < table6.Length; i++) { organization.tab6.Add(new Tab6 { MD_CODE = table6[i].Field <string>("MD_CODE"), MD_NAME = table6[i].Field <string>("MD_NAME"), Data01 = 0.00, Data02 = null, Data2020 = table4[i].Field <string>("DATA2020") }); } //for (int i = 0; i < table7.Length; i++) //{ // organization.tab7.Add(new Tab7 // { // MD_CODE = table7[i].Field<string>("MD_CODE"), // MD_LAWS_NUM = table7[i].Field<string>("MD_LAWS_NUM"), // MD_NAME = table7[i].Field<string>("MD_NAME"), // MD_TIME = table7[i].Field<string>("MD_TIME"), // Data01 = null, // Data02 = null, // Data03 = DateTime.Now // }); //} } return(PartialView("AddShilenDans", organization)); } catch (Exception ex) { Globals.WriteErrorLog(ex, openid); } return(PartialView("AddShilenDans", organization)); }