/// <summary> /// 更新一条数据 /// </summary> public bool Update(BaseProductUnitTable model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BASE_PRODUCT_UNIT set "); strSql.Append("BASIC_FLAG=@BASIC_FLAG,"); strSql.Append("STATUS_FLAG=@STATUS_FLAG,"); strSql.Append("LAST_UPDATE_USER=@LAST_UPDATE_USER,"); strSql.Append("LAST_UPDATE_TIME=GETDATE()"); strSql.Append(" where PRODUCT_CODE=@PRODUCT_CODE and UNIT_CODE=@UNIT_CODE "); SqlParameter[] parameters = { new SqlParameter("@PRODUCT_CODE", SqlDbType.VarChar, 40), new SqlParameter("@UNIT_CODE", SqlDbType.VarChar, 20), new SqlParameter("@BASIC_FLAG", SqlDbType.Int, 4), new SqlParameter("@STATUS_FLAG", SqlDbType.Int, 4), new SqlParameter("@LAST_UPDATE_USER", SqlDbType.VarChar, 20) }; parameters[0].Value = model.PRODUCT_CODE; parameters[1].Value = model.UNIT_CODE; parameters[2].Value = model.BASIC_FLAG; parameters[3].Value = model.STATUS_FLAG; parameters[4].Value = model.LAST_UPDATE_USER; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void btnSave_Click(object sender, EventArgs e) { if (CheckInput()) { if (_currentProductUnitTable == null) { _currentProductUnitTable = new BaseProductUnitTable(); } _currentProductUnitTable.PRODUCT_CODE = txtProductCode.Text; _currentProductUnitTable.UNIT_CODE = txtUnitCode.Text; //_currentProductUnitTable.BASIC_FLAG = Convert.ToInt32(cb.SelectedItem.ToString()); _currentProductUnitTable.LAST_UPDATE_USER = _userInfo.CODE; if (rBasic1.Checked) { _currentProductUnitTable.BASIC_FLAG = 1; } else { _currentProductUnitTable.BASIC_FLAG = 2; } try { if (bProductUnit.Exists(txtProductCode.Text.Trim(), txtUnitCode.Text.Trim())) { bProductUnit.Update(_currentProductUnitTable); } else { _currentProductUnitTable.CREATE_USER = _userInfo.CODE; bProductUnit.Add(_currentProductUnitTable); } } catch (Exception ex) { //log.error MessageBox.Show(""); return; } result = DialogResult.OK; this.Close(); } }
/// <summary> /// 获得当前选中的数据 /// </summary> private void GetCurrentSelectedTable() { try { string productcode = dgvData.SelectedRows[0].Cells["PRODUCT_CODE"].Value.ToString(); string unitcode = dgvData.SelectedRows[0].Cells["UNIT_CODE"].Value.ToString(); if (productcode != "") { _currentProductUnitTable = bProductUnit.GetModel(productcode, unitcode); } } catch (Exception ex) { } if (_currentProductUnitTable == null || _currentProductUnitTable.PRODUCT_CODE == null || "".Equals(_currentProductUnitTable.PRODUCT_CODE)) { _currentProductUnitTable = null; } }
private void txtUnitCode_Leave(object sender, EventArgs e) { //判断编号是否已存在 if (!string.IsNullOrEmpty(this.txtProductCode.Text.Trim()) && !string.IsNullOrEmpty(this.txtUnitCode.Text.Trim())) { BaseProductUnitTable ProductUnitCode = new BaseProductUnitTable(); ProductUnitCode = bProductUnit.GetModel(txtProductCode.Text, txtUnitCode.Text); if (ProductUnitCode != null) { txtProductCode.Text = ""; txtProductName.Text = ""; txtUnitCode.Text = ""; txtUnitName.Text = ""; txtProductCode.Focus(); MessageBox.Show("商品编号与单位编号组合已存在,请重新输入!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); } } if (!string.IsNullOrEmpty(this.txtUnitCode.Text.Trim())) { BaseUnitTable Unit = new BaseUnitTable(); BUnit bUnit = new BUnit(); Unit = bUnit.GetModel(this.txtUnitCode.Text); if (Unit == null || "".Equals(Unit)) { txtUnitCode.Focus(); txtUnitCode.Text = ""; txtUnitName.Text = ""; MessageBox.Show("单位编号不存在,请重新输入!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { txtUnitCode.Text = Unit.CODE; txtUnitName.Text = Unit.NAME; } } else { txtUnitName.Text = ""; } }
/// <summary> /// 打开新窗口 /// </summary> private void OpenDialogFrm(int mode) { if (mode == CConstant.MODE_NEW || _currentProductUnitTable != null) { FrmProductUnitDialog frm = new FrmProductUnitDialog(); frm.UserInfo = _userInfo; frm.CurrentProductUnitTable = _currentProductUnitTable; 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); } _currentProductUnitTable = null; }
/// <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 (_currentProductUnitTable != null) { bProductUnit.Delete(_currentProductUnitTable.PRODUCT_CODE, _currentProductUnitTable.UNIT_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); } _currentProductUnitTable = null; } }
public override string[] doUpdateDB() { BaseProductUnitTable ProductUnitTable = null; BProductUnit bProductUnit = new BProductUnit(); StringBuilder strError = new StringBuilder(); int successData = 0; int failureData = 0; string errorFilePath = ""; string backupFilePath = ""; //数据导入处理 foreach (DataRow dr in _csvDataTable.Rows) { StringBuilder str = new StringBuilder(); //商品编号 if (CConvert.ToString(GetValue(dr, "PRODUCT_CODE")).Length > 20) { string product = GetValue(dr, "PRODUCT_CODE").ToString().Substring(0, 20); str.Append(CheckProduct(product, "商品编号")); } else { str.Append(CheckProduct(CConvert.ToString(GetValue(dr, "PRODUCT_CODE")), "商品编号")); } //单位 str.Append(CheckUnit(CConvert.ToString(GetValue(dr, "UNIT_CODE")), "单位编号")); //基础单位Flag if (CConvert.ToInt32(GetValue(dr, "BASIC_FLAG", 1)) != 1 && CConvert.ToInt32(GetValue(dr, "BASIC_FLAG", 1)) != 2 && CConvert.ToString(GetValue(dr, "BASIC_FLAG", 1)) != "") { str.Append("基础单位Flag只能为1或2!"); } else { str.Append(CheckInt(GetValue(dr, "BASIC_FLAG", 1), 9, "基础单位Flag")); } //状态 str.Append(CheckInt(GetValue(dr, "STATUS_FLAG", CConstant.NORMAL), 9, "状态")); if (str.ToString().Trim().Length > 0) { strError.Append(GetStringBuilder(dr, str.ToString().Trim())); failureData++; continue; } try { ProductUnitTable = new BaseProductUnitTable(); if (GetValue(dr, "PRODUCT_CODE").ToString().Length > 20) { ProductUnitTable.PRODUCT_CODE = CConvert.ToString(GetValue(dr, "PRODUCT_CODE")).Substring(0, 20); } else { ProductUnitTable.PRODUCT_CODE = CConvert.ToString(GetValue(dr, "PRODUCT_CODE")); } ProductUnitTable.UNIT_CODE = CConvert.ToString(GetValue(dr, "UNIT_CODE", "01")); ProductUnitTable.BASIC_FLAG = CConvert.ToInt32(GetValue(dr, "BASIC_FLAG", 1)); ProductUnitTable.STATUS_FLAG = CConvert.ToInt32(GetValue(dr, "STATUS_FLAG", CConstant.NORMAL)); ProductUnitTable.CREATE_USER = _userInfo.CODE; ProductUnitTable.LAST_UPDATE_USER = _userInfo.CODE; if (!bProductUnit.Exists(ProductUnitTable.PRODUCT_CODE, ProductUnitTable.UNIT_CODE)) { bProductUnit.Add(ProductUnitTable); } else { bProductUnit.Update(ProductUnitTable); } 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> public bool Add(BaseProductUnitTable model) { StringBuilder strSql = null; int rows = 0; if (Exists(model.PRODUCT_CODE, model.UNIT_CODE)) { #region 更新 strSql = new StringBuilder(); strSql.Append("update BASE_PRODUCT_UNIT set "); strSql.Append("BASIC_FLAG=@BASIC_FLAG,"); strSql.Append("STATUS_FLAG=@STATUS_FLAG,"); strSql.Append("CREATE_USER=@CREATE_USER,"); strSql.Append("CREATE_DATE_TIME=GETDATE(),"); strSql.Append("LAST_UPDATE_USER=@LAST_UPDATE_USER,"); strSql.Append("LAST_UPDATE_TIME=GETDATE()"); strSql.Append(" where PRODUCT_CODE=@PRODUCT_CODE and UNIT_CODE=@UNIT_CODE "); SqlParameter[] parameters = { new SqlParameter("@PRODUCT_CODE", SqlDbType.VarChar, 40), new SqlParameter("@UNIT_CODE", SqlDbType.VarChar, 20), new SqlParameter("@BASIC_FLAG", SqlDbType.Int, 4), 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.PRODUCT_CODE; parameters[1].Value = model.UNIT_CODE; parameters[2].Value = model.BASIC_FLAG; parameters[3].Value = CConstant.NORMAL_STATUS; parameters[4].Value = model.CREATE_USER; parameters[5].Value = model.LAST_UPDATE_USER; rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); #endregion } else { strSql = new StringBuilder(); strSql.Append("insert into BASE_PRODUCT_UNIT("); strSql.Append("PRODUCT_CODE,UNIT_CODE,BASIC_FLAG,STATUS_FLAG,CREATE_USER,CREATE_DATE_TIME,LAST_UPDATE_USER,LAST_UPDATE_TIME)"); strSql.Append(" values ("); strSql.Append("@PRODUCT_CODE,@UNIT_CODE,@BASIC_FLAG,@STATUS_FLAG,@CREATE_USER,GETDATE(),@LAST_UPDATE_USER,GETDATE())"); SqlParameter[] parameters = { new SqlParameter("@PRODUCT_CODE", SqlDbType.VarChar, 40), new SqlParameter("@UNIT_CODE", SqlDbType.VarChar, 20), new SqlParameter("@BASIC_FLAG", SqlDbType.Int, 4), 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.PRODUCT_CODE; parameters[1].Value = model.UNIT_CODE; parameters[2].Value = model.BASIC_FLAG; parameters[3].Value = CConstant.NORMAL_STATUS; parameters[4].Value = model.CREATE_USER; parameters[5].Value = model.LAST_UPDATE_USER; rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); } if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(BaseProductUnitTable model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(BaseProductUnitTable model) { return(dal.Add(model)); }