/// <summary>
///添加一条数据
/// </summary>
public int Add(BllAlloationTable model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BLL_ALLOATION(");
strSql.Append("ORDER_SLIP_NUMBER,ORDER_LINE_NUMBER,WAREHOUSE_CODE,PRODUCT_CODE,QUANTITY,UNIT_CODE,STATUS_FLAG,CREATE_USER,CREATE_DATE_TIME,LAST_UPDATE_USER,LAST_UPDATE_TIME)");
strSql.Append(" values (");
strSql.Append("@ORDER_SLIP_NUMBER,@ORDER_LINE_NUMBER,@WAREHOUSE_CODE,@PRODUCT_CODE,@QUANTITY,@UNIT_CODE,@STATUS_FLAG,@CREATE_USER,GETDATE(),@LAST_UPDATE_USER,GETDATE())");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ORDER_SLIP_NUMBER", SqlDbType.VarChar, 20),
new SqlParameter("@ORDER_LINE_NUMBER", SqlDbType.Int, 4),
new SqlParameter("@WAREHOUSE_CODE", SqlDbType.VarChar, 20),
new SqlParameter("@PRODUCT_CODE", SqlDbType.VarChar, 20),
new SqlParameter("@QUANTITY", SqlDbType.Decimal, 9),
new SqlParameter("@UNIT_CODE", SqlDbType.VarChar, 20),
new SqlParameter("@STATUS_FLAG", SqlDbType.Int, 4),
new SqlParameter("@CREATE_USER", SqlDbType.VarChar, 20),
new SqlParameter("@LAST_UPDATE_USER", SqlDbType.VarChar, 20)
};
parameters[0].Value = model.ORDER_SLIP_NUMBER;
parameters[1].Value = model.ORDER_LINE_NUMBER;
parameters[2].Value = model.WAREHOUSE_CODE;
parameters[3].Value = model.PRODUCT_CODE;
parameters[4].Value = model.QUANTITY;
parameters[5].Value = model.UNIT_CODE;
parameters[6].Value = model.STATUS_FLAG;
parameters[7].Value = model.CREATE_USER;
parameters[8].Value = model.LAST_UPDATE_USER;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BllAlloationTable model)
{
return(dal.Add(model));
}
/// <summary>
/// 引当确认
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAlloation_Click(object sender, EventArgs e)
{
List <BllAlloationTable> dataList = new List <BllAlloationTable>();
BllAlloationTable alloationTable = null;
int alloationStatus = CConstant.ALLOATION_COMPLETE;
foreach (DataGridViewRow dgvr in dgvData.Rows)
{
alloationTable = new BllAlloationTable();
decimal alloationQuantity = CConvert.ToDecimal(dgvr.Cells["ALLOATION_QUANTITY"].Value);
decimal quantity = CConvert.ToDecimal(dgvr.Cells["QUANTITY"].Value);
if (alloationQuantity > 0 && "OK".Equals(dgvr.Cells["IS_ALLOATION"].Value))
{
alloationTable.ORDER_SLIP_NUMBER = _slipNumber;
alloationTable.ORDER_LINE_NUMBER = CConvert.ToInt32(dgvr.Cells["NO"].Value);
alloationTable.PRODUCT_CODE = CConvert.ToString(dgvr.Cells["PRODUCT_CODE"].Value);
alloationTable.QUANTITY = alloationQuantity;
alloationTable.UNIT_CODE = CConvert.ToString(dgvr.Cells["UNIT_CODE"].Value);
alloationTable.WAREHOUSE_CODE = CConvert.ToString(dgvr.Cells["DEPARTUAL_WAREHOUSE"].Value);
if ("".Equals(alloationTable.WAREHOUSE_CODE))
{
alloationTable.WAREHOUSE_CODE = CConvert.ToString(dgvr.Cells["DEFAULT_WAREHOUSE_CODE"].Value);
}
if (alloationQuantity == quantity)
{
alloationTable.STATUS_FLAG = CConstant.ALLOATION_COMPLETE;
}
else
{
alloationTable.STATUS_FLAG = CConstant.ALLOATION_PART;
alloationStatus = CConstant.ALLOATION_PART;
}
alloationTable.CREATE_USER = UserTable.CODE;
alloationTable.LAST_UPDATE_USER = UserTable.CODE;
dataList.Add(alloationTable);
}
}
//未引当
if (dataList.Count == 0)
{
alloationStatus = CConstant.ALLOATION_UN;
}
else if (dataList.Count < dgvData.Rows.Count)
{
alloationStatus = CConstant.ALLOATION_PART;
}
if (dataList.Count > 0 && bAlloation.Add(dataList, alloationStatus) > 0)
{
MessageBox.Show("引当完成。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
_dialogResult = DialogResult.OK;
this.Close();
}
}
