/// <summary> /// 更新一条数据 /// </summary> public bool Update(BaseSlipTypeCompositionProductsTable model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BASE_SLIP_TYPE_COMPOSITION_PRODUCTS set "); strSql.Append("SLIP_TYPE_CODE=@SLIP_TYPE_CODE,"); strSql.Append("COMPOSITION_PRODUCTS_CODE=@COMPOSITION_PRODUCTS_CODE,"); strSql.Append("QUANTITY=@QUANTITY"); strSql.Append(" where SLIP_TYPE_CODE=@SLIP_TYPE_CODE and COMPOSITION_PRODUCTS_CODE=@COMPOSITION_PRODUCTS_CODE "); SqlParameter[] parameters = { new SqlParameter("@SLIP_TYPE_CODE", SqlDbType.VarChar, 20), new SqlParameter("@COMPOSITION_PRODUCTS_CODE", SqlDbType.VarChar, 20), new SqlParameter("@QUANTITY", SqlDbType.Int, 9) }; parameters[0].Value = model.SLIP_TYPE_CODE; parameters[1].Value = model.COMPOSITION_PRODUCTS_CODE; parameters[2].Value = model.QUANTITY; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public BaseSlipTypeCompositionProductsTable GetModel(string slipTypeCode, string compositionProductsCode) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from base_slip_type_composition_products_view "); strSql.Append(" where SLIP_TYPE_CODE=@SLIP_TYPE_CODE and COMPOSITION_PRODUCTS_CODE=@COMPOSITION_PRODUCTS_CODE "); SqlParameter[] parameters = { new SqlParameter("@SLIP_TYPE_CODE", SqlDbType.VarChar, 50), new SqlParameter("@COMPOSITION_PRODUCTS_CODE", SqlDbType.VarChar, 50) }; parameters[0].Value = slipTypeCode; parameters[1].Value = compositionProductsCode; BaseSlipTypeCompositionProductsTable model = new BaseSlipTypeCompositionProductsTable(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.SLIP_TYPE_CODE = ds.Tables[0].Rows[0]["SLIP_TYPE_CODE"].ToString(); model.COMPOSITION_PRODUCTS_CODE = ds.Tables[0].Rows[0]["COMPOSITION_PRODUCTS_CODE"].ToString(); model.COMPOSITION_PRODUCTS_NAME = ds.Tables[0].Rows[0]["COMPOSITION_PRODUCTS_NAME"].ToString(); model.SLIP_TYPE_NAME = ds.Tables[0].Rows[0]["SLIP_TYPE_NAME"].ToString(); model.QUANTITY = int.Parse(ds.Tables[0].Rows[0]["QUANTITY"].ToString()); return(model); } else { return(null); } }
public override string[] doUpdateDB() { BaseSlipTypeCompositionProductsTable SlipTypeCompositionProductsTable = null; BSlipTypeCompositionProducts bSlipTypeCompositionProducts = new BSlipTypeCompositionProducts(); StringBuilder strError = new StringBuilder(); int successData = 0; int failureData = 0; string errorFilePath = ""; string backupFilePath = ""; //数据导入处理 foreach (DataRow dr in _csvDataTable.Rows) { StringBuilder str = new StringBuilder(); //订单类型编号 str.Append(CheckSlipType(CConvert.ToString(GetValue(dr, "SLIP_TYPE_CODE")), "产线编号")); //组成品编号 str.Append(CheckCompositionProducts(CConvert.ToString(GetValue(dr, "COMPOSITION_PRODUCTS_CODE")), "组成品编号")); if (str.ToString().Trim().Length > 0) { strError.Append(GetStringBuilder(dr, str.ToString().Trim())); failureData++; continue; } try { SlipTypeCompositionProductsTable = new BaseSlipTypeCompositionProductsTable(); SlipTypeCompositionProductsTable.SLIP_TYPE_CODE = CConvert.ToString(GetValue(dr, "SLIP_TYPE_CODE")); SlipTypeCompositionProductsTable.COMPOSITION_PRODUCTS_CODE = CConvert.ToString(GetValue(dr, "COMPOSITION_PRODUCTS_CODE")); if (!bSlipTypeCompositionProducts.Exists(SlipTypeCompositionProductsTable.SLIP_TYPE_CODE, SlipTypeCompositionProductsTable.COMPOSITION_PRODUCTS_CODE)) { bSlipTypeCompositionProducts.Add(SlipTypeCompositionProductsTable); } else { bSlipTypeCompositionProducts.Update(SlipTypeCompositionProductsTable); } successData++; } catch { strError.Append(GetStringBuilder(dr, " 数据导入失败,请与系统管理员联系!").ToString()); failureData++; } } //错误记录处理 if (strError.Length > 0) { errorFilePath = WriteFile(strError.ToString()); } //备份处理 backupFilePath = BackupFile(); return(new string[] { successData.ToString(), failureData.ToString(), errorFilePath, backupFilePath }); }
/// <summary> /// 获得当前选中的数据 /// </summary> private void GetCurrentSelectedTable() { try { string productcode = dgvData.SelectedRows[0].Cells["SLIP_TYPE_CODE"].Value.ToString(); string unitcode = dgvData.SelectedRows[0].Cells["COMPOSITION_PRODUCTS_CODE"].Value.ToString(); if (productcode != "") { _currentSlipTypeCompositionProductsTable = bSlipTypeCompositionProducts.GetModel(productcode, unitcode); } } catch (Exception ex) { } if (_currentSlipTypeCompositionProductsTable == null || _currentSlipTypeCompositionProductsTable.SLIP_TYPE_CODE == null || "".Equals(_currentSlipTypeCompositionProductsTable.SLIP_TYPE_CODE)) { _currentSlipTypeCompositionProductsTable = null; } }
private void txtProductGroupCode_Leave(object sender, EventArgs e) { string compositionCode = txtCompositionProductsCode.Text.Trim(); if (compositionCode != "") { BaseMaster baseMaster = bCommon.GetBaseMaster("COMPOSITION_PRODUCTS", compositionCode, ""); if (baseMaster != null) { txtCompositionProductsCode.Text = baseMaster.Code; txtCompositionProductsName.Text = baseMaster.Name; } else { MessageBox.Show("组成品不存在.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); txtCompositionProductsCode.Text = ""; txtCompositionProductsName.Text = ""; btnSave.Focus(); } } else { txtCompositionProductsName.Text = ""; } if (!string.IsNullOrEmpty(this.txtSlipTypeCode.Text.Trim()) && !string.IsNullOrEmpty(this.txtCompositionProductsCode.Text.Trim())) { BaseSlipTypeCompositionProductsTable SlipTypeProductGroup = new BaseSlipTypeCompositionProductsTable(); SlipTypeProductGroup = bSlipTypeProductGroup.GetModel(txtSlipTypeCode.Text, txtCompositionProductsCode.Text); if (SlipTypeProductGroup != null) { txtSlipTypeCode.Text = ""; txtSlipTypeName.Text = ""; txtCompositionProductsCode.Text = ""; txtCompositionProductsName.Text = ""; txtSlipTypeCode.Focus(); MessageBox.Show("编号已存在,请重新输入!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); return; } } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(BaseSlipTypeCompositionProductsTable model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BASE_SLIP_TYPE_COMPOSITION_PRODUCTS("); strSql.Append("SLIP_TYPE_CODE,COMPOSITION_PRODUCTS_CODE,QUANTITY)"); strSql.Append(" values ("); strSql.Append("@SLIP_TYPE_CODE,@COMPOSITION_PRODUCTS_CODE,@QUANTITY)"); SqlParameter[] parameters = { new SqlParameter("@SLIP_TYPE_CODE", SqlDbType.VarChar, 20), new SqlParameter("@COMPOSITION_PRODUCTS_CODE", SqlDbType.VarChar, 20), new SqlParameter("@QUANTITY", SqlDbType.Int, 9) }; parameters[0].Value = model.SLIP_TYPE_CODE; parameters[1].Value = model.COMPOSITION_PRODUCTS_CODE; parameters[2].Value = model.QUANTITY; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 打开新窗口 /// </summary> private void OpenDialogFrm(int mode) { if (mode == CConstant.MODE_NEW || _currentSlipTypeCompositionProductsTable != null) { FrmSlipTypeCompositionProductsDialog frm = new FrmSlipTypeCompositionProductsDialog(); frm.UserInfo = _userInfo; frm.CurrentSlipTypeProductGroupTable = _currentSlipTypeCompositionProductsTable; frm.Mode = mode; DialogResult resule = frm.ShowDialog(this); if (resule == DialogResult.OK && isSearch) { Search(this.pgControl.GetCurrentPage()); } frm.Dispose(); } else { //MessageBox.Show("请选择正确的行!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); } _currentSlipTypeCompositionProductsTable = null; }
private void btnSave_Click(object sender, EventArgs e) { if (!CheckCode()) { return; } if (CheckInput()) { if (_currentSlipTypeProductGroupTable == null) { _currentSlipTypeProductGroupTable = new BaseSlipTypeCompositionProductsTable(); } _currentSlipTypeProductGroupTable.SLIP_TYPE_CODE = txtSlipTypeCode.Text.Trim(); _currentSlipTypeProductGroupTable.COMPOSITION_PRODUCTS_CODE = txtCompositionProductsCode.Text.Trim(); _currentSlipTypeProductGroupTable.QUANTITY = int.Parse(txtquantity.Text.Trim()); try { if (bSlipTypeProductGroup.Exists(txtSlipTypeCode.Text.Trim(), txtCompositionProductsCode.Text.Trim())) { bSlipTypeProductGroup.Update(_currentSlipTypeProductGroupTable); } else { bSlipTypeProductGroup.Add(_currentSlipTypeProductGroupTable); } } catch (Exception ex) { //log.error MessageBox.Show(ex.Message); return; } result = DialogResult.OK; this.Close(); } }
/// <summary> /// 删除 /// </summary> private void MasterToolBar_DoDelete_Click(object sender, EventArgs e) { if (MessageBox.Show("确定要删除吗?", this.Text, MessageBoxButtons.OKCancel, MessageBoxIcon.Information, MessageBoxDefaultButton.Button2) == DialogResult.OK) { try { GetCurrentSelectedTable(); if (_currentSlipTypeCompositionProductsTable != null) { bSlipTypeCompositionProducts.Delete(_currentSlipTypeCompositionProductsTable.SLIP_TYPE_CODE, _currentSlipTypeCompositionProductsTable.COMPOSITION_PRODUCTS_CODE); Search(this.pgControl.GetCurrentPage()); } else { MessageBox.Show("请选择正确的行!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { MessageBox.Show("删除失败,请重试或与系统管理员联系。", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); } _currentSlipTypeCompositionProductsTable = null; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(BaseSlipTypeCompositionProductsTable model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(BaseSlipTypeCompositionProductsTable model) { dal.Add(model); }