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 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 ActionResult SaveTemplate()
{
var FormID = Convert.ToInt32(Request["FormID"]);
var TemplateDetail_Name = Request["TemplateDetail_Name"];
var TemplateID = Request["TemplateID"];
var Template_Url = Request["Template_Url"];
var Template_FileName = Request["Template_FileName"];
var Temp = TemplateID.Split(',');
var TempName = TemplateDetail_Name.Split(',');
var TempFileName = Template_FileName.Split(',');
var TempUrl = Template_Url.Split(',');
string Message = "OK";
try
{
using (SysContext db = new SysContext())
{
for (var i = 0; i < Temp.Length; i++)
{
if (Temp[i] != "")
{
var tempid = Convert.ToInt32(Temp[i]);
var Template = db.fl_FormTemplate.SingleOrDefault(ft => ft.TemplateID.Equals(tempid));
Template.Template_Name = TempName[i];
Template.ResetUpdated();
db.SaveChanges();
}
else
{
if (TempName[i] != "")
{
fl_FormTemplate FormTemplate = new fl_FormTemplate
{
FormID = FormID,
Template_Name = TempName[i],
Template_FileName = TempFileName[i],
Template_Url = TempUrl[i],
};
FormTemplate.ResetCreated();
db.fl_FormTemplate.Add(FormTemplate);
db.SaveChanges();
}
}
}
return(Json(Message, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
return(Json(Message = e.Message, JsonRequestBehavior.AllowGet));
}
}
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);
}
