public ActionResult Add(SupportUnitAdd data)
{
try
{
if (Session["INSTNO"] == null || string.IsNullOrEmpty(Session["INSTNO"].ToString()))
{
//Log.Error(ex + ex.StackTrace);
TempData["SessionExipred"] = "true";
//TempData["error"] = ex + ex.StackTrace;
//tran.Rollback();
return(RedirectToAction("Index", "Login", null));
}
MysqlDBA <UnitAToBSum> mysqlDBA = new MysqlDBA <UnitAToBSum>(FunctionController.CONNSTR);
UnitAToBSum alloc = new UnitAToBSum();
alloc.Year = (DateTime.Now.Year - 1911).ToString();
alloc.INSTNO = Session["INSTNO"].ToString();
//-1代表新增，取新流水號
if (data.TrSeialNo1 == "-1")
{
alloc.TrSeialNo = Utility.Utility.getUnitAToBSumSerNo(mysqlDBA);
alloc.TrSeialNo++;
}
else
{
//不是-1表修改，帶原來流水號
alloc.TrSeialNo = int.Parse(data.TrSeialNo1);
}
alloc.INSTNO = Session["INSTNO"].ToString();
alloc.LCareType = data.ServiceType;
alloc.UnitBNo = data.INSTNO;
alloc.UnitBName = data.INSTName;
alloc.TrCaseNum = data.CaseNo;
//alloc.Modifydate = DateTime.Now.ToString("yyyy-MM-dd");
alloc.CreateDate = DateTime.Now.ToString("yyyy-MM-dd");
mysqlDBA.InsertOrUpdate(alloc);
TempData["success"] = "OK";
TempData["parentreload"] = "OK";
//alloc
}
catch (Exception ex)
{
Log.Error(ex + ex.StackTrace);
TempData["action"] = "Function";
TempData["error"] = ex + ex.StackTrace;
//tran.Rollback();
return(RedirectToAction("Index", "SupportUnitAdd", null));
}
return(RedirectToAction("Index", "SupportUnit", null));
}
// GET: SupportUnit
public ActionResult Index(int page = 1)
{
List <UnitAToBSum> listData = new List <UnitAToBSum>();
SupportUnitAdd model = new SupportUnitAdd();
try
{
if (Session["INSTNO"] == null || string.IsNullOrEmpty(Session["INSTNO"].ToString()))
{
//Log.Error(ex + ex.StackTrace);
TempData["SessionExipred"] = "true";
//TempData["error"] = ex + ex.StackTrace;
//tran.Rollback();
return(RedirectToAction("Index", "Login", null));
}
MysqlDBA <UnitAToBSum> dbaHRAlloc = new MysqlDBA <UnitAToBSum>(FunctionController.CONNSTR);
UnitAToBSum queryCrit = new UnitAToBSum();
queryCrit.Year = (DateTime.Now.Year - 1911).ToString();
if (Session["INSTNO"] == null || string.IsNullOrEmpty(Session["INSTNO"].ToString()))
{
TempData["SessionExipred"] = "true";
return(RedirectToAction("Index", "Login", null));
}
queryCrit.INSTNO = Session["INSTNO"].ToString();
listData = (List <UnitAToBSum>)dbaHRAlloc.getDataList(queryCrit);
model.SupportUnits = listData.OrderBy(p => p.TrSeialNo).ToPagedList(page, defaultPageSize);
List <CodeBase> codeBaseData = new List <CodeBase>();
codeBaseData = (List <CodeBase>) new MysqlDBA <CodeBase>(FunctionController.CONNSTR).getAllDataList(new CodeBase());
//TempData["UnitAToBSumList"] = listData;
TempData["CodeBase"] = codeBaseData;
}
catch (Exception ex)
{
Log.Error(ex + ex.StackTrace);
TempData["action"] = "Function";
TempData["error"] = ex + ex.StackTrace;
//tran.Rollback();
return(RedirectToAction("Index", "SupportUnit", null));
}
return(View(model));
}
