/// <summary>
/// 新增或者修改
/// </summary>
/// <param name="input">输入的实体</param>
public void AddOrUpdate(ImpTbInput input)
{
var dbServer = _dbServerRepository.Get(input.DbServerId);
var impType = _impTypeRepository.Get(input.ImpTypeId);
var list = _impTbRepository.GetAllList(a => a.Id != input.Id);
foreach (var item in list)
{
if (item.Code == input.Code)
{
"编码已存在，请重新输入新的编码！".ErrorMsg();
}
if (item.CnTableName.ToLower() == input.CnTableName.ToLower())
{
"表名称已存在，请重新输入新的表名称！".ErrorMsg();
}
}
var data = input.MapTo <ImpTb>();
if (input.Id > 0)
{
var item = _impTbRepository.Get(input.Id);
data = input.MapTo <ImpTbInput, ImpTb>(item);
}
if (data.DefaultField != null)
{
data.DefaultField.Clear();
if (!string.IsNullOrEmpty(input.DefaultFields))
{
foreach (var idStr in input.DefaultFields.Split(','))
{
if (idStr == "")
{
continue;
}
var id = long.Parse(idStr);
var defaultField = _defaultFieldRepository.Get(id);
data.DefaultField.Add(defaultField);
}
}
}
data.DbServer = dbServer;
data.ImpType = impType;
_impTbRepository.InsertOrUpdate(data);
if (input.Id > 0)
{
CreateSqlScript(input.Id);
}
}
public ActionResult EditImpTb(long?id)
{
ViewBag.ImpType = _impTypeAppService.GetDropDownList();
ViewBag.DbServer = _dbServerAppService.GetDropDownList();
ViewBag.DbType = _dbTypeAppService.GetDropDownList();
ViewBag.Rule = new List <SelectListItem>()
{
new SelectListItem()
{
Text = "以日期后缀创建表", Value = "1"
},
new SelectListItem()
{
Text = "以指定表名创建表", Value = "2"
},
new SelectListItem()
{
Text = "以用户后缀创建表", Value = "3"
},
new SelectListItem()
{
Text = "自定义后缀创建表", Value = "4"
}
};
var sql = "";
var data = new ImpTbInput();
if (id != null)
{
data = _impTbAppService.Get(id.Value);
data.DefaultFields = _impTbAppService.GetIds(id.Value);
try
{
var dbServer = _dbServerAppService.GetDbServer(data.DbServerId);
var dbType = _dbTypeAppService.Get(a => a.Name == dbServer.DbTypeName);
data.DbTypeId = dbType.Id;
}
catch { }
sql = data.Sql;
}
ViewBag.Sql = sql;
return(View("Easyman.FwWeb.Views.Import.EditImpTb", data));
}
