public string EditTemplate(TemplateModel model)
{
int TFDID = model.TemplateID;
int TemplateID = model.FormID;
string template_Name = model.FormName;
string table_Name = model.DataFrom;
string template_FileName = model.Template_FileName;
string template_Url = model.Template_Url;
string templatedetail_Name = model.TemplateDetail_Name;
string Message = "OK";
try
{
using (SysContext db = new SysContext())
{
fl_FormTemplate entity_fl_FormTemplate = null;
if (TFDID != 0)
{
entity_fl_FormTemplate = db.fl_FormTemplate.Single(d => d.TemplateID == TFDID);
entity_fl_FormTemplate.Template_Name = templatedetail_Name;
entity_fl_FormTemplate.Template_FileName = template_FileName;
entity_fl_FormTemplate.Template_Url = template_Url;
entity_fl_FormTemplate.ModifiedUser = LoginInfo.UserID;
entity_fl_FormTemplate.ModifiedTime = DateTime.Now;
entity_fl_FormTemplate.ResetUpdated();
}
else
{
entity_fl_FormTemplate = new fl_FormTemplate();
entity_fl_FormTemplate.FormID = TemplateID;
entity_fl_FormTemplate.Template_Name = templatedetail_Name;
entity_fl_FormTemplate.Template_FileName = template_FileName;
entity_fl_FormTemplate.Template_Url = template_Url;
entity_fl_FormTemplate.CreatedUser = LoginInfo.UserID;
entity_fl_FormTemplate.ModifiedUser = LoginInfo.UserID;
entity_fl_FormTemplate.ResetCreated();
db.fl_FormTemplate.Add(entity_fl_FormTemplate);
}
fl_Form entity_fl_Form = db.fl_Form.Single(t => t.FormID == entity_fl_FormTemplate.FormID);
entity_fl_Form.FormName = template_Name;
entity_fl_Form.DataFrom = table_Name;
entity_fl_Form.ModifiedUser = LoginInfo.UserID;
entity_fl_Form.ModifiedTime = DateTime.Now;
entity_fl_Form.ResetUpdated();
db.SaveChanges();
}
}
catch
{
Message = "Error";
}
return(Message);
}
public string AddTemplate(TemplateModel model)
{
string template_Name = model.FormName;
string table_Name = model.DataFrom;
string template_FileName = model.Template_FileName;
string template_Url = model.Template_Url;
string templatedetail_Name = model.TemplateDetail_Name;
string Message = "OK";
using (SysContext db = new SysContext())
{
System.Data.Entity.DbContextTransaction tran = db.Database.BeginTransaction();
try
{
fl_Form entity_fl_Form = db.fl_Form.FirstOrDefault(t => t.FormName == template_Name && t.DataFrom == table_Name);
if (entity_fl_Form == null)
{
entity_fl_Form = new fl_Form();
entity_fl_Form.Companys = "";
entity_fl_Form.FormName = template_Name;
entity_fl_Form.DataFrom = table_Name;
entity_fl_Form.CreatedUser = LoginInfo.UserID;
entity_fl_Form.ModifiedUser = LoginInfo.UserID;
entity_fl_Form.ResetCreated();
db.fl_Form.Add(entity_fl_Form);
db.SaveChanges();
}
fl_FormTemplate entity_fl_FormTemplate = new fl_FormTemplate();
entity_fl_FormTemplate.FormID = entity_fl_Form.FormID;
entity_fl_FormTemplate.Template_Name = templatedetail_Name;
entity_fl_FormTemplate.Template_FileName = template_FileName;
entity_fl_FormTemplate.Template_Url = template_Url;
entity_fl_FormTemplate.CreatedUser = LoginInfo.UserID;
entity_fl_FormTemplate.ModifiedUser = LoginInfo.UserID;
entity_fl_FormTemplate.ResetCreated();
db.fl_FormTemplate.Add(entity_fl_FormTemplate);
db.SaveChanges();
tran.Commit();
Message = "OK," + entity_fl_Form.FormID;
}
catch
{
tran.Rollback();
Message = "Error";
}
}
return(Message);
}
