public ActionResult Edit(string id)
{
fw_memberinfo form = null;
List <ComboItem> gender = null, ispassed = null, isenabled = null;
using (var db = new SysContext())
{
gender = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='Gender'")).ToList();
ispassed = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='RZZT'")).ToList();
isenabled = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='YN'")).ToList();
}
using (var db = new LUOLAI1401Context())
{
form = db.fw_memberinfo.Find(id);
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new fw_memberinfo
{
Fid = id
};
}
return(View(new { form = form, dataSource = new { gender, ispassed, isenabled } }));
}
public string AddRule(Panasia.Gemini.FL.Models.ProcessModel model)
{
string Template_Info = model.Template_Info;
string col_name = model.col_name;
string condition = model.value;
//decimal value = model.value;
int approveform_id = model.approveform_id;
string Message = "OK";
try
{
fl_ApproveRules entity_fl_ApproveRules = new fl_ApproveRules();
entity_fl_ApproveRules.FormID = int.Parse(Template_Info.Substring(Template_Info.IndexOf("|") + 1));
entity_fl_ApproveRules.Table_Name = Template_Info.Substring(0, Template_Info.IndexOf("|"));
entity_fl_ApproveRules.Col_Name = col_name;
entity_fl_ApproveRules.Condition = condition;
entity_fl_ApproveRules.ApproverID = approveform_id;
entity_fl_ApproveRules.CreatedUser = LoginInfo.UserID;
entity_fl_ApproveRules.ModifiedUser = LoginInfo.UserID;
entity_fl_ApproveRules.ResetCreated();
using (SysContext db = new SysContext())
{
db.fl_ApproveRules.Add(entity_fl_ApproveRules);
db.SaveChanges();
}
}
catch
{
Message = "Error";
}
return(Message);
}
public object Types()
{
using (var db = new SysContext())
{
return(db.sys_codeType.AsNoTracking().OrderBy(c => c.Seq).ToList());
}
}
public ActionResult Edit(string id)
{
PersonInfo form = null;
List <ComboItem> sex = null, idtype = null, EmployeeStatus = null, position = null, marital = null, lasteducation = null, HighestDegree = null, rank = null, wq_unittype_remark = null;
using (var db = new SysContext())
{
sex = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "CodeType='Sex'")).ToList();
idtype = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "CodeType='idtype'")).ToList();
EmployeeStatus = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "CodeType='forstatus'")).ToList();
position = db.Database.SqlQuery <ComboItem>("select OrganizeName Text, OrganizeCode Value from sys_organize where " + string.Format("{0}{1}", "CompCode=", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode)).ToList();
marital = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "CodeType='marital'")).ToList();
lasteducation = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "CodeType='lasteducation'")).ToList();
HighestDegree = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "CodeType='HighestDegree'")).ToList();
rank = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "CodeType='rank'")).ToList();
}
using (var db = new LUOLAI1401Context())
{
form = db.Database.SqlQuery <PersonInfoViewable>("select a.ID ,a.psncode ,a.name ,a.Mobile ,a.sex ,a.idtype ,a.CertNumber ,a.nationality ,a.nativeplace ,a.age ,a.birthdate ,a.BirthPlace ,a.characterrpr ,a.permanreside ,a.FileNumber ,a.SocialSecurity ,a.WageCard ,a.EmployeeStatus ,a.position ,b.RoleName RoleCode_RefText ,a.RoleCode ,a.effectdate ,a.stuffdate ,a.workaddr ,a.marital ,a.country ,a.polity ,a.health ,a.Height ,a.Weight ,a.Vision ,a.GraduationSchool ,a.lasteducation ,a.HighestDegree ,a.major ,a.rank ,a.joinworkdate ,a.FreeWorkYears ,a.is_status ,a.kq_status ,a.glbdef1 ,a.Photo ,a.CreatePerson ,a.CreateDate ,a.UpdatePerson ,a.UpdateDate from PersonInfo a LEFT JOIN [Bcp.Sys].dbo.sys_role b ON a.RoleCode = b.RoleCode AND " + string.Format("{0}{1}{2}", "CompCode='", System.Web.HttpContext.Current.Session["CompCode"], "'") + " where a.ID = @key", new System.Data.SqlClient.SqlParameter("@key", id)).FirstOrDefault();
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new PersonInfo
{
ID = id,
kq_status = string.Format("{0}", "1"),
CreateDate = DateTime.Now,
UpdateDate = DateTime.Now
};
}
return(View(new { form = form, dataSource = new { sex, idtype, EmployeeStatus, position, marital, lasteducation, HighestDegree, rank, wq_unittype_remark } }));
}
public ActionResult Edit(int id)
{
base_customField form = null;
List <ComboItem> TypeCode = null;
using (var db = new SysContext())
{
TypeCode = db.Database.SqlQuery <ComboItem>("select Text Text, Text Value from sys_code where " + string.Format("{0}", "CodeType='patrolSignIn'")).ToList();
}
using (var db = new LUOLAI1401Context())
{
form = db.base_customField.Find(id);
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new base_customField
{
id = id,
CompCode = string.Format("{0}", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode)
};
}
return(View(new { form = form, dataSource = new { TypeCode } }));
}
public ActionResult Edit(string id)
{
FA_InvAccepts form = null;
List <ComboItem> Corp = null, invoiceType = null;
using (var db = new SysContext())
{
Corp = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='HtCorp'")).ToList();
}
using (var db = new LUOLAI1401Context())
{
invoiceType = db.HR_NewInvoices.Select(i => new ComboItem {
Text = i.Remarks, Value = "" + i.FID
}).ToList();
form = db.Database.SqlQuery <FA_InvAcceptsViewable>("select a.FID ,a.Corp ,b.Contact CustID_RefText ,a.CustID ,a.PID ,a.Fdate ,a.Amt ,a.invoiceTitle ,a.invoiceType ,a.Remark ,a.CreatePerson ,a.CreateDate ,a.UpdateDate from FA_InvAccepts a LEFT JOIN BD_Customers b ON a.CustID = b.FID where a.FID = @key", new System.Data.SqlClient.SqlParameter("@key", id)).FirstOrDefault();
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new FA_InvAccepts
{
FID = id,
invoiceType = string.Format("{0}", "5")
};
}
return(View(new { form = form, dataSource = new { Corp, invoiceType } }));
}
public object Post(JArray data)
{
using (var db = new SysContext())
{
for (int i = 0; i < data.Count; i++)
{
JObject obj = data[i] as JObject;
RowState rowState = (RowState)(int)obj["_row_state"];
sys_parameter parameter = obj.ToObject <sys_parameter>();
switch (rowState)
{
case RowState.Changed:
db.Entry(parameter).State = System.Data.Entity.EntityState.Modified;
break;
case RowState.New:
db.sys_parameter.Add(parameter);
break;
case RowState.Deleted:
db.Entry(parameter).State = System.Data.Entity.EntityState.Deleted;
break;
}
}
db.SaveChanges();
}
return(true);
}
public object Post(JObject post)
{
var form = post["form"].ToObject <sys_user>();
using (var db = new SysContext())
{
var dbForm = db.sys_user.Find(form.UserCode);
if (dbForm == null)
{
form.CreateDate = DateTime.Now;
form.CreatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
db.sys_user.Add(form);
}
else
{
dbForm.UserSeq = form.UserSeq;
dbForm.UserName = form.UserName;
dbForm.Description = form.Description;
dbForm.Password = form.Password;
dbForm.RoleName = form.RoleName;
dbForm.OrganizeName = form.OrganizeName;
dbForm.ConfigJSON = form.ConfigJSON;
dbForm.IsEnable = form.IsEnable;
dbForm.LoginCount = form.LoginCount;
dbForm.LastLoginDate = form.LastLoginDate;
dbForm.UpdateDate = form.UpdateDate = DateTime.Now;
dbForm.UpdatePerson = form.UpdatePerson = (HttpContext.Current.Session["sys_user"] as sys_user).UserName;
}
db.SaveChanges();
}
return(new { success = true, form = form });
}
public object Organize()
{
using (var db = new SysContext())
{
return(db.sys_organize.AsNoTracking().OrderBy(r => r.OrganizeSeq).ToList());
}
}
public ActionResult Edit(string id)
{
FA_Receipts form = null;
List <ComboItem> Corp = null, SZType = null, payType = null;
using (var db = new SysContext())
{
Corp = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='HtCorp'")).ToList();
SZType = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='SHZHType'")).ToList();
payType = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='PayKind'")).ToList();
}
using (var db = new LUOLAI1401Context())
{
form = db.Database.SqlQuery <FA_ReceiptsViewable>("select a.FID ,a.Corp ,a.SZType ,b.Contact CustID_RefText ,a.CustID ,a.Fdate ,a.Amt ,a.payType ,a.Remark ,a.CreatePerson ,a.CreateDate ,a.UpdateDate from FA_Receipts a LEFT JOIN BD_Customers b ON a.CustID = b.FID where a.FID = @key", new System.Data.SqlClient.SqlParameter("@key", id)).FirstOrDefault();
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new FA_Receipts
{
FID = id
};
}
return(View(new { form = form, dataSource = new { Corp, SZType, payType } }));
}
public ActionResult AutoUpgrade()
{
DbContext currentDb = SysContext.GetCurrentDb();
List <core_menu> list = currentDb.Fetch <core_menu>("", new object[0]);
foreach (core_menu item in list)
{
UpdateCoreMenu(item);
}
string[] files = Directory.GetFiles(Server.MapPath("~/UI/"), "*", SearchOption.AllDirectories);
string[] array = files;
foreach (string text in array)
{
string fileNameWithoutExtension = Path.GetFileNameWithoutExtension(text);
string text2 = text.Replace(Path.GetFileName(text), "");
text2 = text2.Substring(0, text2.Length - 1);
text2 = text2.Substring(text2.ToLower().IndexOf("\\ui\\") + 4);
string text3 = text2.Contains("\\") ? text2.Substring(text2.LastIndexOf("\\") + 1) : text2;
text3 = text3.Replace("\\", "");
Server.MapPath("~/pages/" + text3 + "/");
if (fileNameWithoutExtension.Contains("service_"))
{
fileNameWithoutExtension = fileNameWithoutExtension.Replace("service_", "") + ".service.js";
string str = System.IO.File.ReadAllText(text);
str = "\r\n define([], function ()\r\n {\r\n return " + str + " \r\n }); ";
}
else
{
GenUpdateFile(text3, fileNameWithoutExtension);
}
}
ServiceHelper.Log("更新日志", strLogs);
return(Content(strLogs.Replace("\n", "<br />"), "text/html"));
}
public ActionResult UserStatus()
{
DbContext currentDb = SysContext.GetCurrentDb();
string appName = currentDb.ExecuteScalar <string>("select SettingValue from core_setting where SettingKey = @0", new object[1]
{
"AppName"
});
core_user core_user = currentDb.FirstOrDefault <core_user>("where id = @0", new object[1]
{
SysContext.FastDevUserID
});
if (core_user == null)
{
return(Json(new
{
statusCode = "3"
}));
}
return(Json(new
{
statusCode = "1",
data = new
{
homeStyle = core_user.HomeStyle,
realName = core_user.RealName,
userName = core_user.LoginName,
appName = appName,
id = core_user.ID,
myPic = core_user.MyPic
}
}));
}
private object GetProcess(APIContext context)
{
var data = JsonHelper.DeserializeJsonToObject <GetProcessReq>(context.Data);
var ddService = SysContext.GetService <IDingDingServices>();
return(ddService.GetProcess(data.OriUserId, data.OriDeptId, data.taskUserId, data.OpeUserId, data.pageIndex, data.pageSize).Result);
}
public ActionResult Edit(long id)
{
HR_CertLoans form = null;
List <ComboItem> TRemark = null, DRemark = null;
using (var db = new SysContext())
{
TRemark = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='Tui'")).ToList();
DRemark = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='yes/no'")).ToList();
}
using (var db = new LUOLAI1401Context())
{
form = db.HR_CertLoans.Find(id);
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new HR_CertLoans
{
FID = id
};
}
return(View(new { form = form, dataSource = new { TRemark, DRemark } }));
}
public object Get()
{
using (var db = new SysContext())
{
return(db.sys_parameter.AsNoTracking().OrderBy(p => p.ParamCode).ToList());
}
}
public dynamic GetRoles(string id)
{
using (var db = new SysContext())
{
return(db.Database.SqlQuery <SysOrganizeRoleSelected>("select b.*, convert(bit, (select count(*) from sys_organizeRoleMap m where m.OrganizeCode=@organizeCode and m.RoleCode = b.RoleCode)) Selected from sys_role b order by b.RoleSeq", new SqlParameter("@organizeCode", id)).ToList());
}
}
public ICollection <sys_organize> Get()
{
using (var db = new SysContext())
{
return(db.sys_organize.AsNoTracking().OrderBy(o => o.OrganizeSeq).ToList());
}
}
public dynamic SaveButtons(string id, JArray data)
{
var list = data.ToObject <List <SysButtonSelected> >();
using (var db = new SysContext())
{
foreach (var item in list)
{
if (item.Selected)
{
if (db.sys_menuButtonMap.Count(m => m.MenuCode == id && m.ButtonCode == item.ButtonCode) == 0)
{
db.sys_menuButtonMap.Add(new sys_menuButtonMap {
ButtonCode = item.ButtonCode, MenuCode = id
});
}
}
else
{
db.sys_menuButtonMap.Remove(m => m.MenuCode == id && m.ButtonCode == item.ButtonCode);
}
}
db.SaveChanges();
}
// 当保存简单的数据，不需要从数据库中重新刷新 UI 数据时，可以直接返回 true 表示保存成功
// 否则，返回加载相同的数据集来自动更新客户端。
return(true);
}
public IEnumerable <dynamic> GetButtons(string id)
{
using (var db = new SysContext())
{
return(db.Database.SqlQuery <SysButtonSelected>("select b.*, convert(bit, (select count(*) from sys_menuButtonMap m where m.MenuCode=@menuCode and m.ButtonCode = b.ButtonCode)) Selected from sys_button b", new SqlParameter("@menuCode", id)).ToList());
}
}
public ActionResult Edit(string id)
{
HR_WageSets form = null;
List <ComboItem> HFType = null, CustID = null;
using (var db = new SysContext())
{
HFType = db.Database.SqlQuery <ComboItem>("select Text Text, Value Value from sys_code where " + string.Format("{0}", "/*TABLEALIAS*/CodeType='FType'")).ToList();
}
using (var db = new LUOLAI1401Context())
{
CustID = db.BD_Customers.Select(i => new ComboItem {
Text = i.Contact, Value = "" + i.FID
}).ToList();
form = db.Database.SqlQuery <HR_WageSetsViewable>("select a.FID ,b.empID empID_RefText ,a.empID ,a.HFType ,a.SSBaseAmt ,a.HFBaseAmt ,a.CustID ,a.START_TIME ,a.END_TIME ,a.Remark ,a.CreatePerson ,a.CreateDate ,a.UpdateDate from HR_WageSets a LEFT JOIN HR_PractiseCerts b ON a.empID = b.FID where a.FID = @key", new System.Data.SqlClient.SqlParameter("@key", id)).FirstOrDefault();
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new HR_WageSets
{
FID = id
};
}
return(View(new { form = form, dataSource = new { HFType, CustID } }));
}
public ActionResult Edit(string id)
{
timingSet form = null;
List <ComboItem> timingtype = null;
using (var db = new SysContext())
{
timingtype = db.Database.SqlQuery <ComboItem>("select Text Text, Text Value from sys_code where " + string.Format("{0}", "CodeType='sfkq'")).ToList();
}
using (var db = new LUOLAI1401Context())
{
form = db.Database.SqlQuery <timingSetViewable>("select a.CompCode ,b.RoleName RoleCode_RefText ,a.RoleCode ,c.name psncode_RefText ,a.psncode ,a.timingtype ,a.interval ,a.mobegintime ,a.moendtime ,a.afbegintime ,a.afendtime ,a.id from timingSet a LEFT JOIN [Bcp.Sys].dbo.sys_role b ON a.RoleCode = b.RoleCode LEFT JOIN PersonInfo c ON a.psncode = c.psncode where a.id = @key", new System.Data.SqlClient.SqlParameter("@key", id)).FirstOrDefault();
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new timingSet
{
id = id,
CompCode = string.Format("{0}", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode)
};
}
return(View(new { form = form, dataSource = new { timingtype } }));
}
public dynamic SaveRoles(string id, JArray data)
{
var list = data.ToObject <List <SysOrganizeRoleSelected> >();
using (var db = new SysContext())
{
foreach (var item in list)
{
if (item.Selected)
{
if (db.sys_organizeRoleMap.Count(m => m.OrganizeCode == id && m.RoleCode == item.RoleCode) == 0)
{
db.sys_organizeRoleMap.Add(new sys_organizeRoleMap {
RoleCode = item.RoleCode, OrganizeCode = id
});
}
}
else
{
db.sys_organizeRoleMap.Remove(m => m.OrganizeCode == id && m.RoleCode == item.RoleCode);
}
}
db.SaveChanges();
}
return(true);
}
//获取表单的状态
public string GetFormStatus()
{
//request
string formId = "";
ServiceConfig userServiceConfig = ServiceHelper.GetServiceConfig("user");
var OTDB = SysContext.GetOtherDB(userServiceConfig.model.dbName);
var Status = OTDB.FirstOrDefault <string>("select Status from processinstance where Id=@0", formId);
if (Status == null)
{
return(null);
}
switch (Status)
{
case "TERMINATED":
break;
case "COMPLETED":
break;
case "RUNNING":
break;
}
return("");
}
public ActionResult UpgradePage(string model, string viewname)
{
try
{
strLogs = "";
DbContext currentDb = SysContext.GetCurrentDb();
core_menu core_menu = currentDb.FirstOrDefault <core_menu>("where MenuUrl like '%model=" + model + "%' and MenuUrl like '%viewname=" + viewname + "%'", new object[0]);
if (core_menu == null)
{
core_menu = currentDb.FirstOrDefault <core_menu>("where MenuUrl like '%model=" + model + "%' and MenuUrl like '%viewtype=" + viewname + "%'", new object[0]);
}
if (core_menu != null)
{
UpdateCoreMenu(core_menu);
}
GenUpdateFile(model, viewname);
return(Json(new AjaxResult
{
statusCode = "1"
}));
}
catch (Exception ex)
{
ServiceHelper.Log(ex);
return(Json(new AjaxResult
{
statusCode = ((ex is UserException) ? "2" : "3"),
message = ex.Message
}));
}
}
public string DeleteTemplateDetail()
{
int TFDID = int.Parse(Request.Form["id"]);
string Message = "OK";
try
{
using (SysContext db = new SysContext())
{
fl_FormTemplate templatedetail = db.fl_FormTemplate.Single(d => d.TemplateID == TFDID);
db.fl_FormTemplate.Remove(templatedetail);
//如果该表单下所有的模版都删除了，那么删除该表单
//if (!db.fl_TemplateFormDetail.Any(d => d.TemplateID == templatedetail.TemplateID))
//{
// db.fl_TemplateForm.Remove(db.fl_TemplateForm.Single(t => t.TemplateID == templatedetail.TemplateID));
//}
db.SaveChanges();
}
}
catch
{
Message = "Error";
}
return(Message);
}
public ActionResult Edit(int id)
{
wq_grouppurchase form = null;
List <ComboItem> DealerCode = null, DealerType = null;
using (var db = new SysContext())
{
DealerType = db.Database.SqlQuery <ComboItem>("select Text Text, Text Value from sys_code where " + string.Format("{0}", "CodeType='Kz_zd'")).ToList();
}
using (var db = new LUOLAI1401Context())
{
DealerCode = db.Database.SqlQuery <ComboItem>("select PopName Text, PopCode Value from wq_termPop where " + string.Format("{0}{1}{2}", "CompCode='", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode, "'")).ToList();
form = db.wq_grouppurchase.Find(id);
}
ViewBag.RowState = 2;
if (form == null)
{
ViewBag.RowState = 1;
form = new wq_grouppurchase
{
id = id,
CompCode = string.Format("{0}", (System.Web.HttpContext.Current.Session["sys_user"] as sys_user).CompCode),
DealerType = string.Format("{0}", "团购客户")
};
}
return(View(new { form = form, dataSource = new { DealerCode, DealerType } }));
}
public string DeleteTemplate()
{
int TemplateID = int.Parse(Request["id"]);
string Message = "OK";
try
{
using (SysContext db = new SysContext())
{
// fl_TemplateFormDetail templatedetail = db.fl_TemplateFormDetail.Single(d => d.TFDID == TFDID);
// db.fl_TemplateFormDetail.Remove(templatedetail);
//如果该表单下所有的模版都删除了，那么删除该表单
// if (!db.fl_TemplateFormDetail.Any(d => d.TemplateID == templatF:\Code2014\Panasia.Gemini\Panasia.Gemini.FL\Views\Shared\_Layout.cshtmledetail.TemplateID))
// {
db.fl_Form.Remove(db.fl_Form.Single(t => t.FormID == TemplateID));
// }
db.SaveChanges();
}
}
catch
{
Message = "Error";
}
return(Message);
}
public string EditMapping(MappingModel model)
{
string table_Name = model.Table_Name;
string FormID = model.FormID;
int Approved = model.Approved;
int MappingFormID = model.MappingFormID;
string Message = "OK";
using (SysContext db = new SysContext())
{
try
{
fl_MappingForm entity_fl_MappingForm = db.fl_MappingForm.Single(d => d.MappingFormID == MappingFormID);
if (entity_fl_MappingForm != null)
{
entity_fl_MappingForm.FormNo = FormID;
entity_fl_MappingForm.Table_Name = table_Name;
entity_fl_MappingForm.Approved = Approved;
entity_fl_MappingForm.ModifiedUser = LoginInfo.UserID;
entity_fl_MappingForm.ModifiedTime = DateTime.Now;
entity_fl_MappingForm.ResetUpdated();
db.SaveChanges();
}
}
catch
{
Message = "Error";
}
}
return(Message);
}
public string AddMapping(MappingModel model)
{
string table_Name = model.Table_Name;
string FormID = model.FormID;
int Approved = model.Approved;
string Message = "OK";
using (SysContext db = new SysContext())
{
System.Data.Entity.DbContextTransaction tran = db.Database.BeginTransaction();
try
{
fl_MappingForm entity_fl_MappingForm = new fl_MappingForm();
entity_fl_MappingForm.FormNo = FormID;
entity_fl_MappingForm.Table_Name = table_Name;
entity_fl_MappingForm.Approved = Approved;
entity_fl_MappingForm.ApprovedDate = DateTime.Now;
entity_fl_MappingForm.TemplateUrl = "";
entity_fl_MappingForm.CreatedUser = LoginInfo.UserID;
entity_fl_MappingForm.ModifiedUser = LoginInfo.UserID;
entity_fl_MappingForm.ResetCreated();
db.fl_MappingForm.Add(entity_fl_MappingForm);
db.SaveChanges();
tran.Commit();
}
catch
{
tran.Rollback();
Message = "Error";
}
}
return(Message);
}
public string[] UserRole(String UserCode)
{
using (var db = new SysContext())
{
return(db.Database.SqlQuery <string>("select RoleCode from sys_userRoleMap where UserCode = @UserCode", new System.Data.SqlClient.SqlParameter("@UserCode", UserCode)).ToArray());
}
}
public EmploymentStudentVisitLogService(SysContext ctx, IUnitOfWork db)
{
this.SysContext = ctx;
if(db!=null){
this.Db = db;
}else{
this.Db = DbContextFactory.Create();
}
this.Repository = new EmploymentStudentVisitLogRepository(this.Db);
}
public SchoolContactService(SysContext ctx, IUnitOfWork db)
{
this.SysContext = ctx;
if(db!=null){
this.Db = db;
}else{
this.Db = DbContextFactory.Create();
}
this.Repository = new SchoolContactRepository(this.Db);
}
public SmallInfoSourceService(SysContext ctx, IUnitOfWork db)
{
this.SysContext = ctx;
if(db!=null){
this.Db = db;
}else{
this.Db = DbContextFactory.Create();
}
this.Repository = new SmallInfoSourceRepository(this.Db);
}
public ImportCustomerService(SysContext ctx, IUnitOfWork db)
{
this.SysContext = ctx;
if(db!=null){
this.Db = db;
}else{
this.Db = DbContextFactory.Create();
}
this.Repository = new ImportCustomerRepository(this.Db);
}
public StudentTeleVisitRecordService(SysContext ctx, IUnitOfWork db)
{
this.SysContext = ctx;
if(db!=null){
this.Db = db;
}else{
this.Db = DbContextFactory.Create();
}
this.Repository = new StudentTeleVisitRecordRepository(this.Db);
}
public UserInGroupService(SysContext ctx, IUnitOfWork db)
{
this.SysContext = ctx;
if(db!=null){
this.Db = db;
}else{
this.Db = DbContextFactory.Create();
}
this.Repository = new UserInGroupRepository(this.Db);
}
public UserGroupFunctionPermissionService(SysContext ctx)
{
this.SysContext = ctx;
this.Db = DbContextFactory.Create();
this.Repository = new UserGroupFunctionPermissionRepository(this.Db);
}
public SmallInfoSourceService(SysContext ctx)
{
this.SysContext = ctx;
this.Db = DbContextFactory.Create();
this.Repository = new SmallInfoSourceRepository(this.Db);
}
public ImportCustomerService(SysContext ctx)
{
this.SysContext = ctx;
this.Db = DbContextFactory.Create();
this.Repository = new ImportCustomerRepository(this.Db);
}
public UserInGroupService(SysContext ctx)
{
this.SysContext = ctx;
this.Db = DbContextFactory.Create();
this.Repository = new UserInGroupRepository(this.Db);
}
public EmploymentStudentVisitLogService(SysContext ctx)
{
this.SysContext = ctx;
this.Db = DbContextFactory.Create();
this.Repository = new EmploymentStudentVisitLogRepository(this.Db);
}
public CityService(SysContext ctx)
{
this.SysContext = ctx;
this.Db = DbContextFactory.Create();
this.Repository = new CityRepository(this.Db);
}
public SysContext sys() {
SysContext _localctx = new SysContext(Context, State);
EnterRule(_localctx, 6, RULE_sys);
try {
State = 79;
switch (TokenStream.La(1)) {
case INCLUDE:
EnterOuterAlt(_localctx, 1);
{
State = 76; include();
}
break;
case SECTION:
EnterOuterAlt(_localctx, 2);
{
State = 77; section();
}
break;
case REPT:
EnterOuterAlt(_localctx, 3);
{
State = 78; repblock();
}
break;
default:
throw new NoViableAltException(this);
}
}
catch (RecognitionException re) {
_localctx.exception = re;
ErrorHandler.ReportError(this, re);
ErrorHandler.Recover(this, re);
}
finally {
ExitRule();
}
return _localctx;
}
public StudentTeleVisitRecordService(SysContext ctx)
{
this.SysContext = ctx;
this.Db = DbContextFactory.Create();
this.Repository = new StudentTeleVisitRecordRepository(this.Db);
}
public SchoolService(SysContext ctx)
{
this.SysContext = ctx;
this.Db = DbContextFactory.Create();
this.Repository = new SchoolRepository(this.Db);
}
