public ActionResult Create(FormCollection collection)
{
try
{
SysApplicationEntity model = new SysApplicationEntity();
model.AppId = Convert.ToInt32(collection["AppId"]);
if (logic.GetSysApplicationInfo(model.AppId) == null)
{
model.SubSystemId = Convert.ToInt32(collection["SubSystemId"]);
model.AppName = collection["AppName"];
model.AppEName = collection["AppEName"];
model.AppTypeId = Convert.ToInt32(collection["AppTypeId"]);
model.Owner = collection["Owner"];
model.Status = Convert.ToInt32(collection["AppState"]);
model.Remark = collection["Remark"];
logic.AddSysApplication(model);
return(this.RefreshParent());
}
else
{
return(this.Back("重复的应用编号：" + model.AppId));
}
}
catch (Exception ex)
{
return(this.Back("新增应用发生异常。" + ex.Message));
}
}
public int AddSysApplication(SysApplicationEntity model)
{
string sql = "INSERT INTO SysApplication(AppId,SubSystemId,AppName,AppEName,AppTypeId,Owner,Status,Remark) VALUES(@AppId,@SubSystemId,@AppName,@AppEName,@AppTypeId,@Owner,@Status,@Remark)";
using (var conn = new SqlConnection(ConnectionStr.FxDb))
{
conn.Open();
return(conn.Execute(sql, model));
}
}
public int UpdateSysApplication(SysApplicationEntity model)
{
string sql = "UPDATE SysApplication SET SubSystemId=@SubSystemId,AppName=@AppName,AppEName=@AppEName,AppTypeId=@AppTypeId,Owner=@Owner,Status=@Status,Remark=@Remark WHERE AppId=@AppId";
using (var conn = new SqlConnection(ConnectionStr.FxDb))
{
conn.Open();
return(conn.Execute(sql, model));
}
}
public int AddSysApplication(SysApplicationEntity model)
{
return(sysApplicationDal.AddSysApplication(model));
}
public int UpdateSysApplication(SysApplicationEntity model)
{
return(sysApplicationDal.UpdateSysApplication(model));
}
