public ActionResult SaveCustmerFormInstance(string keyValue, FormModuleInstanceEntity entity)
{
var data = fromModuleBLL.SaveCustmerInstance(keyValue, entity);
return(Content(new AjaxResult {
type = ResultType.success, message = "保存成功", resultdata = data
}.ToJson()));
}
/// <summary>
/// 保存表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="entity">实体对象</param>
/// <returns></returns>
public void SaveForm(string keyValue, FormModuleInstanceEntity entity)
{
try
{
service.SaveForm(keyValue, entity);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 保存表单模块实例数据
/// </summary>
/// <param name="keyValue"></param>
/// <param name="entity"></param>
/// <returns></returns>
public string SaveCustmerInstance(string keyValue, FormModuleInstanceEntity entity)
{
try
{
Form_ModuleContentEntity contentEntity = serverContent.GetEntity(entity.F_FrmContentId);
return(serverInstance.SaveEntity(keyValue, entity, contentEntity));
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 保存表单模块实例数据
/// </summary>
/// <param name="entity"></param>
/// <param name="contentEntity"></param>
/// <returns></returns>
public string SaveEntity(FormModuleInstanceEntity entity, Form_ModuleContentEntity contentEntity)
{
FormModuleInstanceEntity formModuleInstanceEntity = GetEntityByProcessId(entity.F_ObjectId, entity.F_FrmContentId);
if (formModuleInstanceEntity != null)
{
if (formModuleInstanceEntity.F_FrmInstanceJson != entity.F_FrmInstanceJson)
{
return(SaveEntity(formModuleInstanceEntity.F_Id, entity, contentEntity));
}
else
{
return(formModuleInstanceEntity.F_Id);
}
}
else
{
return(SaveEntity("", entity, contentEntity));
}
}
/// <summary>
/// 保存表单模块实例数据
/// </summary>
/// <param name="keyValue"></param>
/// <param name="entity"></param>
/// <param name="contentEntity"></param>
/// <returns>主键值</returns>
public string SaveEntity(string keyValue, FormModuleInstanceEntity entity, Form_ModuleContentEntity contentEntity)
{
try
{
string resKeyValue = "";
FormContentModel contentModel = contentEntity.F_FrmContent.ToObject <FormContentModel>();
switch (contentModel.type)
{
case "1":
DataBaseLinkService dbService = new DataBaseLinkService();
string strSql = "";
var parameter = new List <DbParameter>();
List <FormInstanceModel> filedsData = entity.F_FrmInstanceJson.ToObject <List <FormInstanceModel> >();
if (string.IsNullOrEmpty(keyValue))
{
string pkValue = Guid.NewGuid().ToString();
strSql = " INSERT INTO " + contentModel.dbTable + " ( " + contentModel.dbPkey;
string sqlValue = "( @" + contentModel.dbPkey;
parameter.Add(DbParameters.CreateDbParameter("@" + contentModel.dbPkey, pkValue));
foreach (var item in filedsData)
{
if (!string.IsNullOrEmpty(item.value))
{
strSql += "," + item.field;
sqlValue += ",@" + item.field;
parameter.Add(DbParameters.CreateDbParameter("@" + item.field, item.value));
}
}
strSql += " ) VALUES " + sqlValue + ")";
entity.Create();
entity.F_Id = pkValue;
dbService.ExecuteBySql(contentModel.dbId, strSql, parameter.ToArray());
this.BaseRepository().Insert(entity);
resKeyValue = entity.F_Id;
}
else
{
strSql = " UPDATE " + contentModel.dbTable + " SET ";
bool isFirst = true;
foreach (var item in filedsData)
{
if (!string.IsNullOrEmpty(item.value))
{
if (!isFirst)
{
strSql += ",";
}
strSql += item.field + "=@" + item.field;
parameter.Add(DbParameters.CreateDbParameter("@" + item.field, item.value));
isFirst = false;
}
}
strSql += " WHERE " + contentModel.dbPkey + "=@" + contentModel.dbPkey;
parameter.Add(DbParameters.CreateDbParameter("@" + contentModel.dbPkey, keyValue));
entity.Modify(keyValue);
dbService.ExecuteBySql(contentModel.dbId, strSql, parameter.ToArray());
this.BaseRepository().Update(entity);
resKeyValue = entity.F_Id;
}
break;
case "0":
case "2":
if (string.IsNullOrEmpty(keyValue)) //新增
{
entity.Create();
this.BaseRepository().Insert(entity);
}
else //更新
{
entity.Modify(keyValue);
this.BaseRepository().Update(entity);
}
resKeyValue = entity.F_Id;
break;
}
return(resKeyValue);
}
catch (Exception)
{
throw;
}
}
public ActionResult SaveCustmerFormInstance(string keyValue, FormModuleInstanceEntity entity)
{
instancebll.SaveForm(keyValue, entity);
return(Success("操作成功。"));
}
