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