public int Delete(PSS_InWarehouseMode obj)
{
using (Conn)
{
string query = @"DELETE FROM PSS_InWarehouseMode
WHERE ID = @ID";
return(Conn.Execute(query, obj));
}
}
public int Insert(PSS_InWarehouseMode obj)
{
using (Conn)
{
string query = @"INSERT INTO PSS_InWarehouseMode
VALUES(@Name,@PriceWay,@PriceFormula)";
return(Conn.Execute(query, obj));
}
}
public int Update(PSS_InWarehouseMode obj)
{
using (Conn)
{
string query = @"UPDATE PSS_InWarehouseMode
SET Name=@Name,PriceWay=@PriceWay,PriceFormula=@PriceFormula WHERE ID =@ID";
return(Conn.Execute(query, obj));
}
}
public ActionResult AcceptClick(PSS_InWarehouseMode obj)
{
int isOk = default(int);
//判断ID的值，ID为0表示ID为默认值，插入记录。非0的ID代表数据库已存在记录，则修改
if (obj.ID != 0)
{
isOk = ipss_inwarehousemodebll.Update(obj);
}
else
{
isOk = ipss_inwarehousemodebll.Insert(obj);
}
return(Content(isOk.ToString()));
}
public int Delete(PSS_InWarehouseMode obj)
{
return(dal.Delete(obj));
}
public int Insert(PSS_InWarehouseMode obj)
{
return(dal.Insert(obj));
}
public int Update(PSS_InWarehouseMode obj)
{
return(dal.Update(obj));
}