public JsonResult DoEdit(ExportSqlManage model)
{
return(new JsonResult()
{
Data = new { Result = exportSqlManageProvider.Update(model) > 0 ? "success" : "error" }
});
}
public JsonResult Add(ExportSqlManage model)
{
return(new JsonResult()
{
Data = new { Result = exportSqlManageProvider.Insert(model) > 0 ? "success" : "error" }
});
}
/// <summary>
/// 增加一条记录
/// </summary>
public int Insert(ExportSqlManage model)
{
const string insertSql = @"
insert into ExportSqlManage(Name,SqlText,Executetime,ReceiveEmail,IsEnable)
values(@Name,@SqlText,@Executetime,@ReceiveEmail,@IsEnable)
select @@identity
";
IDbParameters dbParameters = DbHelper.CreateDbParameters();
dbParameters.AddWithValue("Name", model.Name);
dbParameters.AddWithValue("SqlText", model.SqlText);
dbParameters.AddWithValue("Executetime", model.Executetime);
dbParameters.AddWithValue("ReceiveEmail", model.ReceiveEmail);
dbParameters.AddWithValue("IsEnable", model.IsEnable);
return(ParseHelper.ToInt(DbHelper.ExecuteScalar(SuperMan_Write, insertSql, dbParameters)));
}
/// <summary>
/// 更新一条记录
/// </summary>
public int Update(ExportSqlManage model)
{
const string updateSql = @"
update ExportSqlManage
set Name=@Name,SqlText=@SqlText,Executetime=@Executetime,ReceiveEmail=@ReceiveEmail,IsEnable=@IsEnable
where id=@ID";
IDbParameters dbParameters = DbHelper.CreateDbParameters();
dbParameters.AddWithValue("Id", model.Id);
dbParameters.AddWithValue("Name", model.Name);
dbParameters.AddWithValue("SqlText", model.SqlText);
dbParameters.AddWithValue("Executetime", model.Executetime);
dbParameters.AddWithValue("ReceiveEmail", model.ReceiveEmail);
dbParameters.AddWithValue("IsEnable", model.IsEnable);
return(ParseHelper.ToInt(DbHelper.ExecuteNonQuery(SuperMan_Write, updateSql, dbParameters)));
}
/// <summary>
/// 根据id查询对象
/// </summary>
public ExportSqlManage GetById(long id)
{
ExportSqlManage model = null;
const string getbyidSql = @"
select Id,Name,SqlText,Executetime,ReceiveEmail,IsEnable
from ExportSqlManage (nolock)
where id=@ID";
IDbParameters dbParameters = DbHelper.CreateDbParameters();
dbParameters.AddWithValue("ID", id);
DataTable dt = DataTableHelper.GetTable(DbHelper.ExecuteDataset(SuperMan_Read, getbyidSql, dbParameters));
if (DataTableHelper.CheckDt(dt))
{
model = DataTableHelper.ConvertDataTableList <ExportSqlManage>(dt)[0];
}
return(model);
}
/// <summary>
/// 修改一条记录
/// </summary>
public int Update(ExportSqlManage model)
{
return(exportSqlManageDao.Update(model));
}
/// <summary>
/// 增加一条记录
/// </summary>
public int Insert(ExportSqlManage model)
{
return(exportSqlManageDao.Insert(model));
}
public ActionResult Edit(long?id = 0)
{
ExportSqlManage model = id == 0 ? new ExportSqlManage() : exportSqlManageProvider.GetById(ParseHelper.ToLong(id));
return(View(model));
}
