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)); }