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