// 科目================================================================
public ActionResult Subject(string Bno)
{
List <Bugdalist2> gamers = new GetBudgetModel().getCrlist2(Bno);
ViewBag.h = gamers;
return(View());
}
public ActionResult Items(string Puid, String Bugda)
{
List <Itemslist> gamers = new GetBudgetModel().getItems(Puid);
ViewBag.h = gamers;
ViewBag.k = Puid;
ViewBag.Bugda = Bugda;
//ViewBag.Guid = Guid.NewGuid();
return(View());
}
public JsonResult AjaxGetTeams(string Puid)
{
List <Member> gamers1 = new GetBudgetModel().getList2(Puid);
return(Json(gamers1, JsonRequestBehavior.AllowGet));
}
public ActionResult Signoff(string Bno, string isPost = "0")
{
//string account = "0001";
//string account = Session["account"].ToString();
// 判斷帳號
List <Mlist02> Check = new GetBudgetModel().CheckAccount(Session["account"].ToString(), Bno);
//var gamers = db.Step_Signoff(Session["account"].ToString(), Bno);
// 取現在關卡
string LEV = "1.00";
string 當關人 = "";
if (Check[1].LEV == 2 && Check[1].sctrl == "Y")
{
LEV = Check[2].LEV.ToString();
當關人 = Check[0].第三關.ToString();
}
else if (Check[0].LEV == 1 && Check[0].sctrl == "Y")
{
LEV = Check[1].LEV.ToString();
當關人 = Check[0].第二關.ToString();
}
else if (Check[2].LEV == 3 && Check[2].sctrl == "Y")
{
LEV = "4.00";
當關人 = "";
}
else
{
當關人 = Check[0].第一關.ToString();
}
string SCTRL = "";
// 判斷account============================
if (當關人.Contains(";"))
{
// 當關有複數的人
int i = 0;
string[] sArray = 當關人.Split(';');
foreach (string AA in sArray)
{
if (!string.IsNullOrEmpty(AA))
{
if (AA == Session["account"].ToString())
{
i++;
}
}
}
if (i == 0)
{
SCTRL = "N";
}
}
else
{
if (當關人 != Session["account"].ToString())
{
SCTRL = "N";
}
}
List <Mlist03> Check1 = new List <Mlist03>();
Check1.Add(new Mlist03()
{
單號 = Bno, LEV = Check[0].LEV.ToString(), 簽核人 = Check[0].第一關.ToString()
});
Check1.Add(new Mlist03()
{
單號 = Bno, LEV = Check[1].LEV.ToString(), 簽核人 = Check[0].第二關.ToString()
});
Check1.Add(new Mlist03()
{
單號 = Bno, LEV = Check[2].LEV.ToString(), 簽核人 = Check[0].第三關.ToString()
});
ViewBag.h = SCTRL;
ViewBag.t = Check1;
ViewBag.LEV = LEV;
ViewBag.單號 = Bno;
ViewBag.isPost = isPost;
return(View());
}
public ActionResult Create(string Dept, string Month)
{
Budget_t BudgetNo = new Budget_t();
Budget_Bugda Budget2 = new Budget_Bugda();
if (String.IsNullOrEmpty(Dept.Trim()))
{
ModelState.AddModelError("Dept", $"Dept is empty.");
return(View());
}
// 判斷部門
else if (new Models.GetBudgetModel().Dept(Dept) == 0)
{
ModelState.AddModelError("Dept", $"The {Dept} is wrong format.");
return(View());
}
// 判斷日期
if (String.IsNullOrEmpty(Month.Trim()))
{
ModelState.AddModelError("Month", $"Month is empty.");
return(View());
}
else if (Month.Length != 4 ||
(Month.Substring(0, 2) != DateTime.Now.ToString("yyyy").Substring(2, 2) &&
Month.Substring(0, 2) != DateTime.Now.AddMonths(1).ToString("yyyy").Substring(2, 2)))
{
ModelState.AddModelError("Month", $"The {Month} is wrong format.");
return(View());
}
// 判斷這部門的這個月是否已建立
if (new Models.GetBudgetModel().Check(Dept, Month) > 0)
{
ModelState.AddModelError("Dept", $"had created in{Month}.");
return(View());
}
string Bno = new GetBudgetModel().Bno();
Guid uid = Guid.NewGuid();
BudgetNo.Bno = Bno;
BudgetNo.Month = Month;
BudgetNo.Dept = Dept;
BudgetNo.Uid = uid;
BudgetNo.Total = 0;
BudgetNo.Sctrl = "N";
BudgetNo.Lev = 1;
List <Bugdalist> gamers = new GetBudgetModel().getCrlist(Dept, Month);
if (ModelState.IsValid)
{
// create 主list
new GetBudgetModel().Create(BudgetNo);
// create 明細list
foreach (var item in gamers)
{
Budget2.Bugda = item.Bugda;
Budget2.Total = item.Total;
Budget2.Puid = uid;
Budget2.Uid = Guid.NewGuid();
new GetBudgetModel().Create(Budget2);
}
// Insert Step
db.Step_Insert(Bno, "預算系統", "部門預算", Session["account"].ToString());
}
return(RedirectToAction("Subject", "Home", new { Bno }));
}
