public static int add(ModelCheckoutRecord model)
{
string strSQL = @"
INSERT INTO checkout_record (
id_contract,
id_goods,
amount
) VALUES (
@id_contract,
@id_goods,
@amount
)";
MySqlParameter[] aryParams = new MySqlParameter[3];
aryParams[0] = new MySqlParameter("@id_contract", model.id_contract);
aryParams[1] = new MySqlParameter("@id_goods", model.id_goods);
aryParams[2] = new MySqlParameter("@amount", model.amount);
if (HelperMySql.ExecuteNonQuery(strSQL, aryParams) > 0)
{
strSQL = "SELECT MAX(id) FROM checkout_record";
object objReturn = HelperMySql.ExecuteScalar(strSQL);
return(objReturn == null ? 0 : Convert.ToInt32(objReturn));
}
else
{
return(0);
}
}
// 根据出库货品表里的id删除该表中一条记录，注意还要将出货数量加回去
public static void deleteById(int intId)
{
ModelCheckoutRecord modelCheckoutRecord = DalCheckoutRecord.getById(intId);
int intGoodsId = modelCheckoutRecord.id_goods;
decimal dcmAmountOut = modelCheckoutRecord.amount;
// 将出货数量加回去
BllSalesGoods.addAmountStock(intGoodsId, dcmAmountOut);
// 删除表里一条记录
DalCheckoutRecord.deleteById(intId);
}
// 添加出库货品记录，并更新货品的库存量
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";
if (context.Request.Params["CheckoutContractId"] == null ||
!HelperUtility.isDecimal(context.Request.Params["CheckoutContractId"].ToString()))
{
context.Response.Write(HelperUtility.setReturnJson("500", "需要指明出库单ID！", ""));
return;
}
if (context.Request.Params["GoodsId"] == null ||
!HelperUtility.isDecimal(context.Request.Params["GoodsId"].ToString()))
{
context.Response.Write(HelperUtility.setReturnJson("500", "需要指明出库单ID！", ""));
return;
}
if (context.Request.Params["Amount"] == null ||
!HelperUtility.isDecimal(context.Request.Params["Amount"].ToString()))
{
context.Response.Write(HelperUtility.setReturnJson("500", "需要指明数量！", ""));
return;
}
int intCheckoutContractId = Convert.ToInt32(context.Request.Params["CheckoutContractId"]);
int intGoodsId = Convert.ToInt32(context.Request.Params["GoodsId"]);
decimal dcmAmount = Convert.ToDecimal(context.Request.Params["Amount"]);
if (!(intCheckoutContractId > 0 && intGoodsId > 0 && dcmAmount > 0))
{
context.Response.Write(HelperUtility.setReturnJson("500", "数字不对！", ""));
return;
}
ModelCheckoutRecord model = new ModelCheckoutRecord();
model.id_contract = intCheckoutContractId;
model.id_goods = intGoodsId;
model.amount = dcmAmount;
int intId = BllCheckoutRecord.add(model);
if (intId > 0)
{
// 出库货品表里添加完了一条记录后，更新此货品的库存量
BllSalesGoods.updateAmountStockByCheckOut(dcmAmount, intGoodsId);
context.Response.Write(HelperUtility.setReturnJson("200", "", intId.ToString()));
return;
}
else
{
context.Response.Write(HelperUtility.setReturnJson("500", "添加失败，请联系管理员！", ""));
return;
}
}
public static int update(ModelCheckoutRecord model)
{
string strSQL = @"
UPDATE checkout_record
SET
id_contract = @id_contract,
id_goods = @id_goods,
amount = @amount
WHERE
id = @id
";
MySqlParameter[] aryParams = new MySqlParameter[4];
aryParams[0] = new MySqlParameter("@id_contract", model.id_contract);
aryParams[1] = new MySqlParameter("@id_goods", model.id_goods);
aryParams[2] = new MySqlParameter("@amount", model.amount);
aryParams[3] = new MySqlParameter("@id", model.id);
return(HelperMySql.ExecuteNonQuery(strSQL, aryParams));
}
public static ModelCheckoutRecord getById(int intId)
{
string strSQL = @"SELECT * FROM checkout_record WHERE id = @id";
MySqlParameter[] aryParams = new MySqlParameter[1];
aryParams[0] = new MySqlParameter("@id", intId);
DataTable objDT = HelperMySql.GetDataTable(strSQL, aryParams);
if (objDT != null && objDT.Rows.Count > 0)
{
ModelCheckoutRecord model = new ModelCheckoutRecord();
model.id = Convert.ToInt32(objDT.Rows[0]["id"]);
model.id_contract = Convert.ToInt32(objDT.Rows[0]["id_contract"]);
model.id_goods = Convert.ToInt32(objDT.Rows[0]["id_goods"]);
model.amount = Convert.ToDecimal(objDT.Rows[0]["amount"]);
return(model);
}
else
{
return(null);
}
}
public static int add(ModelCheckoutRecord model)
{
return(DalCheckoutRecord.add(model));
}
public static int update(ModelCheckoutRecord model)
{
return(DalCheckoutRecord.update(model));
}
