public void OP_Command(object sender, CommandEventArgs e)
{
int intIdGoods = Convert.ToInt32(e.CommandArgument);
int intIdContract = Convert.ToInt32(ViewState["ContractId"]);
string strUrl;
if (e.CommandName == "AddGoods")
{
if (!HelperUtility.hasPurviewOP("InventoryContract_update"))
{
HelperUtility.showAlert("没有操作权限", "list.aspx?page=" + ViewState["page"]);
}
int rowIndex = ((GridViewRow)((Button)sender).NamingContainer).RowIndex;
GridViewRow row = gvShow.Rows[rowIndex];
TextBox tbAmountFill = (TextBox)row.FindControl("tbAmountFill");
if (tbAmountFill is null)
{
return;
}
Label lblAmountReal = (Label)row.FindControl("lblAmountReal");
Label lblAmountStock = (Label)row.FindControl("lblAmountStock");
ModelInventoryRecord model = new ModelInventoryRecord();
model.id_contract = intIdContract;
model.id_goods = intIdGoods;
model.amount_real = Convert.ToDecimal(lblAmountReal.Text);
model.amount_stock = Convert.ToDecimal(lblAmountStock.Text);
model.amount_fill = Convert.ToDecimal(tbAmountFill.Text);
BllInventoryRecord.add(model);
}
LoadData();
}
public static int add(ModelInventoryRecord model)
{
string strSQL = @"
INSERT INTO inventory_record (
id_contract,
id_goods,
amount_real,
amount_stock,
amount_fill
) VALUES (
@id_contract,
@id_goods,
@amount_real,
@amount_stock,
@amount_fill
)";
MySqlParameter[] aryParams = new MySqlParameter[5];
aryParams[0] = new MySqlParameter("@id_contract", model.id_contract);
aryParams[1] = new MySqlParameter("@id_goods", model.id_goods);
aryParams[2] = new MySqlParameter("@amount_real", model.amount_real);
aryParams[3] = new MySqlParameter("@amount_stock", model.amount_stock);
aryParams[4] = new MySqlParameter("@amount_fill", model.amount_fill);
if (HelperMySql.ExecuteNonQuery(strSQL, aryParams) > 0)
{
strSQL = "SELECT MAX(id) FROM inventory_record";
object objReturn = HelperMySql.ExecuteScalar(strSQL);
return(objReturn == null ? 0 : Convert.ToInt32(objReturn));
}
else
{
return(0);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";
if (context.Request.Params["InventoryContractId"] == null ||
!HelperUtility.isDecimal(context.Request.Params["InventoryContractId"].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;
}
ModelInventoryRecord model = new ModelInventoryRecord();
model.id_contract = intCheckoutContractId;
model.id_goods = intGoodsId;
model.amount_real = dcmAmount;
model.amount_stock = dcmAmount;
model.amount_fill = dcmAmount;
int intId = BllInventoryRecord.add(model);
if (intId > 0)
{
context.Response.Write(HelperUtility.setReturnJson("200", "", intId.ToString()));
return;
}
else
{
context.Response.Write(HelperUtility.setReturnJson("500", "添加失败，请联系管理员！", ""));
return;
}
}
/// <summary>
/// 新建某盘点单时，计算某货品的真实库存量，然后将所有真实计算库存量大于0的货品加到盘点货品表里
/// </summary>
/// <param name="intContractId">盘点单id</param>
public static void setInventoryRecord(int intContractId)
{
int intGoodsId;
decimal dcmAmount, dcmAmountStock, dcmAmountStockReal;
ModelInventoryRecord model;
// 查询所有货品
string strSQL = @"
SELECT id, amount, amount_stock
FROM sales_goods
ORDER BY time_add DESC
";
DataTable objDT = HelperMySql.GetDataTable(strSQL);
if (objDT == null || objDT.Rows.Count <= 0)
{
return;
}
// 循环遍历所有货品
for (int i = 0; i < objDT.Rows.Count; i++)
{
intGoodsId = Convert.ToInt32(objDT.Rows[i]["id"]);
dcmAmount = Convert.ToDecimal(objDT.Rows[i]["amount"]);
dcmAmountStock = Convert.ToDecimal(objDT.Rows[i]["amount_stock"]);
// 真实库存量
dcmAmountStockReal = dcmAmount - DalCheckoutRecord.getAmountByGoodsId(intGoodsId);
// 如果记录的库存量或者计算的真实库存量大于0，就将该货品加到盘点表里
// if (dcmAmountStock > 0 || dcmAmountStockReal > 0)
if (dcmAmountStock > 0)
{
model = new ModelInventoryRecord();
model.id_contract = intContractId;
model.id_goods = intGoodsId;
model.amount_real = dcmAmountStockReal;
model.amount_stock = dcmAmountStock;
model.amount_fill = 0;
add(model);
// 将某货品的库存清零
// DalSalesGoods.clearAmountStock(intGoodsId);
}
}
}
public static void update(ModelInventoryRecord model)
{
string strSQL = @"
UPDATE inventory_record
SET
id_contract = @id_contract,
id_goods = @id_goods,
amount_real = @amount_real,
amount_stock = @amount_stock,
amount_fill = @amount_fill
WHERE
id = @id
";
MySqlParameter[] aryParams = new MySqlParameter[6];
aryParams[0] = new MySqlParameter("@id_contract", model.id_contract);
aryParams[1] = new MySqlParameter("@id_goods", model.id_goods);
aryParams[2] = new MySqlParameter("@amount_real", model.amount_real);
aryParams[3] = new MySqlParameter("@amount_stock", model.amount_stock);
aryParams[4] = new MySqlParameter("@amount_fill", model.amount_fill);
aryParams[5] = new MySqlParameter("@id", model.id);
HelperMySql.ExecuteNonQuery(strSQL, aryParams);
}
public static ModelInventoryRecord getById(int intId)
{
string strSQL = @"SELECT * FROM inventory_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)
{
ModelInventoryRecord model = new ModelInventoryRecord();
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_real = Convert.ToDecimal(objDT.Rows[0]["amount_real"]);
model.amount_stock = Convert.ToDecimal(objDT.Rows[0]["amount_stock"]);
model.amount_fill = Convert.ToDecimal(objDT.Rows[0]["amount_fill"]);
return(model);
}
else
{
return(null);
}
}
public static int add(ModelInventoryRecord model)
{
return(DalInventoryRecord.add(model));
}
public static void update(ModelInventoryRecord model)
{
DalInventoryRecord.update(model);
}
