/// <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 (_currentSlipTypeTable != null) { bSlipType.Delete(_currentSlipTypeTable.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); Logger.Error("订单类型删除失败", ex); } _currentSlipTypeTable = null; } }
private void txtCode_Leave(object sender, EventArgs e) { //判断编号是否已存在 if (!(txtCode.Focused)) { BaseSlipTypeTable SlipType = new BaseSlipTypeTable(); SlipType = bSlipType.GetModel(txtCode.Text); if (SlipType != null) { txtCode.Text = ""; MessageBox.Show("类型编号和订单编号的组合已存在,请重新输入!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }
private void txtTypeCode_Leave(object sender, EventArgs e) { //判断编号是否已存在 if (!(cboType.Focused) && !(txtCode.Focused)) { BaseSlipTypeTable SlipType = new BaseSlipTypeTable(); SlipType = bSlipType.GetModel(cboType.SelectedValue.ToString(), txtCode.Text); if (SlipType != null) { txtCode.Text = ""; cboType.Focus(); MessageBox.Show("类型和编号的组合已存在,请重新输入!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }
/// <summary> /// 得到一个对象实体 /// </summary> public BaseSlipTypeTable GetModel(string CODE) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from base_slip_type_view "); strSql.Append(" where CODE=@CODE "); strSql.AppendFormat(" and STATUS_FLAG <> {0}", CConstant.DELETE); SqlParameter[] parameters = { new SqlParameter("@CODE", SqlDbType.VarChar,50)}; parameters[0].Value = CODE; BaseSlipTypeTable model = new BaseSlipTypeTable(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.CODE = ds.Tables[0].Rows[0]["CODE"].ToString(); model.NAME = ds.Tables[0].Rows[0]["NAME"].ToString(); model.COMPANY_CODE = ds.Tables[0].Rows[0]["COMPANY_CODE"].ToString(); if (ds.Tables[0].Rows[0]["STATUS_FLAG"].ToString() != "") { model.STATUE_FLAG = int.Parse(ds.Tables[0].Rows[0]["STATUS_FLAG"].ToString()); } model.COMPANY_NAME = ds.Tables[0].Rows[0]["COMPANY_NAME"].ToString(); model.CREATE_USER = ds.Tables[0].Rows[0]["CREATE_USER"].ToString(); model.CREATE_USER_NAME = ds.Tables[0].Rows[0]["CREATE_USER_NAME"].ToString(); if (ds.Tables[0].Rows[0]["CREATE_DATE_TIME"].ToString() != "") { model.CREATE_DATE_TIME = DateTime.Parse(ds.Tables[0].Rows[0]["CREATE_DATE_TIME"].ToString()); } model.LAST_UPDATE_USER = ds.Tables[0].Rows[0]["LAST_UPDATE_USER"].ToString(); model.LAST_UPDATE_USER_NAME = ds.Tables[0].Rows[0]["LAST_UPDATE_USER_NAME"].ToString(); if (ds.Tables[0].Rows[0]["LAST_UPDATE_TIME"].ToString() != "") { model.LAST_UPDATE_TIME = DateTime.Parse(ds.Tables[0].Rows[0]["LAST_UPDATE_TIME"].ToString()); } model.ENGLISHNAME = ds.Tables[0].Rows[0]["ENGLISH_NAME"].ToString(); return model; } else { return null; } }
/// <summary> /// 获得当前选中的数据 /// </summary> private void GetCurrentSelectedTable() { try { string code = dgvData.SelectedRows[0].Cells["CODE"].Value.ToString(); if (code != "") { _currentSlipTypeTable = bSlipType.GetModel(code); } } catch (Exception ex) { Logger.Error("订单类型中获取当前数据失败!", ex); } if (_currentSlipTypeTable == null || _currentSlipTypeTable.CODE == null || "".Equals(_currentSlipTypeTable.CODE)) { _currentSlipTypeTable = null; } }
/// <summary> /// 打开新窗口 /// </summary> private void OpenDialogFrm(int mode) { if (mode == CConstant.MODE_NEW || _currentSlipTypeTable != null) { FrmSlipTypeDialog frm = new FrmSlipTypeDialog(); frm.UserInfo = _userInfo; frm.CurrentSlipTypeTable = _currentSlipTypeTable; 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); } _currentSlipTypeTable = null; }
private void btnSave_Click(object sender, EventArgs e) { if (CheckInput()) { if (_currentSlipTypeTable == null) { _currentSlipTypeTable = new BaseSlipTypeTable(); } _currentSlipTypeTable.TYPE_CODE = cboType.SelectedValue.ToString(); _currentSlipTypeTable.CODE = txtCode.Text; _currentSlipTypeTable.NAME = txtName.Text; _currentSlipTypeTable.COMPANY_CODE = txtCompanyCode.Text; _currentSlipTypeTable.LAST_UPDATE_USER = _userInfo.CODE; _currentSlipTypeTable.INDICATES_ORDER = CConvert.ToInt32(txtIndicatesOrder.Text); try { if (bSlipType.Exists(cboType.SelectedValue.ToString(), txtCode.Text.Trim())) { bSlipType.Update(_currentSlipTypeTable); } else { _currentSlipTypeTable.CREATE_USER = _userInfo.CODE; bSlipType.Add(_currentSlipTypeTable); } } catch (Exception ex) { MessageBox.Show("保存失败,请重新输入!"); Logger.Error("订单类型保存失败!", ex); return; } result = DialogResult.OK; this.Close(); CCacheData.SlipType = null; CCacheData.PurchaseSlipType = null; CCacheData.OrderSlipType = null; } }
private void btnSave_Click(object sender, EventArgs e) { if (CheckInput()) { if (_currentSlipTypeTable == null) { _currentSlipTypeTable = new BaseSlipTypeTable(); } _currentSlipTypeTable.CODE = txtCode.Text.Trim(); _currentSlipTypeTable.NAME = txtName.Text.Trim(); _currentSlipTypeTable.COMPANY_CODE = "01"; _currentSlipTypeTable.LAST_UPDATE_USER = _userInfo.CODE; _currentSlipTypeTable.ENGLISHNAME = txtenglishname.Text.Trim(); _currentSlipTypeTable.ATTRIBUTE1 = ""; _currentSlipTypeTable.ATTRIBUTE2 = ""; _currentSlipTypeTable.ATTRIBUTE3 = ""; try { if (bSlipType.Exists(txtCode.Text.Trim())) { bSlipType.Update(_currentSlipTypeTable); } else { _currentSlipTypeTable.CREATE_USER = _userInfo.CODE; bSlipType.Add(_currentSlipTypeTable); } } catch (Exception ex) { MessageBox.Show("保存失败,请重新输入!"); Logger.Error("订单类型保存失败!", ex); return; } result = DialogResult.OK; this.Close(); CCacheData.SlipType = null; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(BaseSlipTypeTable model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BASE_SLIP_TYPE set "); strSql.Append("NAME=@NAME,"); strSql.Append("COMPANY_CODE=@COMPANY_CODE,"); strSql.Append("STATUS_FLAG=@STATUS_FLAG,"); strSql.Append("LAST_UPDATE_USER=@LAST_UPDATE_USER,"); strSql.Append("LAST_UPDATE_TIME=GETDATE(),"); strSql.Append("ENGLISH_NAME=@ENGLISH_NAME"); strSql.Append(" where CODE=@CODE "); SqlParameter[] parameters = { new SqlParameter("@CODE", SqlDbType.VarChar,20), new SqlParameter("@NAME", SqlDbType.VarChar,100), new SqlParameter("@COMPANY_CODE", SqlDbType.VarChar,20), new SqlParameter("@STATUS_FLAG", SqlDbType.Int,4), new SqlParameter("@LAST_UPDATE_USER", SqlDbType.VarChar,20), new SqlParameter("@ENGLISH_NAME", SqlDbType.VarChar,20)}; parameters[0].Value = model.CODE; parameters[1].Value = model.NAME; parameters[2].Value = model.COMPANY_CODE; parameters[3].Value = model.STATUE_FLAG; parameters[4].Value = model.LAST_UPDATE_USER; parameters[5].Value = model.ENGLISHNAME; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { CCacheData.SlipType = null; return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(BaseSlipTypeTable model) { StringBuilder strSql = null; int rows = 0; if (Exists(model.CODE)) { #region 更新 strSql = new StringBuilder(); strSql.Append("update BASE_SLIP_TYPE set "); strSql.Append("NAME=@NAME,"); strSql.Append("COMPANY_CODE=@COMPANY_CODE,"); 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 CODE=@CODE "); SqlParameter[] parameters = { new SqlParameter("@CODE", SqlDbType.VarChar,20), new SqlParameter("@NAME", SqlDbType.VarChar,100), new SqlParameter("@COMPANY_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.CODE; parameters[1].Value = model.NAME; parameters[2].Value = model.COMPANY_CODE; parameters[3].Value = CConstant.INIT; parameters[4].Value = model.CREATE_USER; parameters[5].Value = model.LAST_UPDATE_USER; rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); #endregion } else { #region 增加 strSql = new StringBuilder(); strSql.Append("insert into BASE_SLIP_TYPE("); strSql.Append("CODE,NAME,COMPANY_CODE,STATUS_FLAG,CREATE_USER,CREATE_DATE_TIME,LAST_UPDATE_USER,LAST_UPDATE_TIME,ENGLISH_NAME,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3)"); strSql.Append(" values ("); strSql.Append("@CODE,@NAME,@COMPANY_CODE,@STATUS_FLAG,@CREATE_USER,GETDATE(),@LAST_UPDATE_USER,GETDATE(),@ENGLISH_NAME,@ATTRIBUTE1,@ATTRIBUTE2,@ATTRIBUTE3)"); SqlParameter[] parameters = { new SqlParameter("@CODE", SqlDbType.VarChar,20), new SqlParameter("@NAME", SqlDbType.VarChar,100), new SqlParameter("@COMPANY_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), new SqlParameter("@ENGLISH_NAME", SqlDbType.VarChar,20), new SqlParameter("@ATTRIBUTE1", SqlDbType.VarChar,20), new SqlParameter("@ATTRIBUTE2", SqlDbType.VarChar,20), new SqlParameter("@ATTRIBUTE3", SqlDbType.VarChar,20)}; parameters[0].Value = model.CODE; parameters[1].Value = model.NAME; parameters[2].Value = model.COMPANY_CODE; parameters[3].Value = CConstant.INIT; parameters[4].Value = model.CREATE_USER; parameters[5].Value = model.LAST_UPDATE_USER; parameters[6].Value = model.ENGLISHNAME; parameters[7].Value = model.ATTRIBUTE1; parameters[8].Value = model.ATTRIBUTE2; parameters[9].Value = model.ATTRIBUTE3; rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); #endregion } if (rows > 0) { return true; CCacheData.SlipType = null; } else { return false; } }
public override string[] doUpdateDB() { BaseSlipTypeTable SlipTypeTable = null; BSlipType bSlipType = new BSlipType(); 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 (!string.IsNullOrEmpty(CConvert.ToString(GetValue(dr, "TYPE_CODE")))) { str.Append(CheckSlipType(CConvert.ToString(GetValue(dr, "TYPE_CODE")), "单据类型")); } else { str.Append("单据类型不能为空!"); } //订单类型编号 if (!string.IsNullOrEmpty(CConvert.ToString(GetValue(dr, "CODE")))) { str.Append(CheckString(GetValue(dr, "CODE"), 20, "单据类型编号")); } else { str.Append("订单类型编号不能为空!"); } //订单类型名称 str.Append(CheckLenght(GetValue(dr, "NAME"), 100, "单据类型名称")); //公司编号 if (!string.IsNullOrEmpty(CConvert.ToString(GetValue(dr, "COMPANY_CODE")))) { str.Append(CheckCompany(CConvert.ToString(GetValue(dr, "COMPANY_CODE")), "公司")); } //表示顺序 str.Append(CheckInt(GetValue(dr, "INDICATES_ORDER", 0), 100000, "表示顺序")); //状态 str.Append(CheckInt(GetValue(dr, "STATUS_FLAG", CConstant.NORMAL_STATUS), 9, "状态")); if (str.ToString().Trim().Length > 0) { strError.Append(GetStringBuilder(dr, str.ToString().Trim())); failureData++; continue; } try { SlipTypeTable = new BaseSlipTypeTable(); SlipTypeTable.TYPE_CODE = CConvert.ToString(GetValue(dr, "TYPE_CODE")); SlipTypeTable.CODE = CConvert.ToString(GetValue(dr, "CODE")); SlipTypeTable.NAME = CConvert.ToString(GetValue(dr, "NAME")); SlipTypeTable.COMPANY_CODE = CConvert.ToString(GetValue(dr, "COMPANY_CODE")); SlipTypeTable.INDICATES_ORDER = CConvert.ToInt32(GetValue(dr, "INDICATES_ORDER", 0)); SlipTypeTable.STATUE = CConvert.ToInt32(GetValue(dr, "STATUS_FLAG", CConstant.NORMAL_STATUS)); SlipTypeTable.CREATE_USER = _userInfo.CODE; SlipTypeTable.LAST_UPDATE_USER = _userInfo.CODE; if (!bSlipType.Exists(SlipTypeTable.TYPE_CODE, SlipTypeTable.CODE)) { bSlipType.Add(SlipTypeTable); } else { bSlipType.Update(SlipTypeTable); } 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 Update(BaseSlipTypeTable model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(BaseSlipTypeTable model) { return(dal.Add(model)); }