public void update(int pkey, MaterielTable materiel) { string update = "UPDATE [dbo].[BASE_MATERIEL_LIST] SET "; //update += "[SUPPLIER_TYPE] = " + materiel.materielType + ","; update += "[NAME] = '" + materiel.name + "',"; update += "[NUM] = '" + materiel.num + "',"; update += "[NAME_SHORT] = '" + materiel.nameShort + "',"; update += "[MODEL] = '" + materiel.model + "',"; update += "[MNEMONIC_CODE] = '" + materiel.mnemonicCode + "',"; update += "[MAX] = " + materiel.max + ","; update += "[MIN] = " + materiel.min + ","; update += "[WARRANTY] = " + materiel.warramty + ","; update += "[STORAGE] = " + materiel.storage + ","; update += "[MATERIEL_ATTRIBUTE] = " + materiel.materielAttribute + ","; update += "[UNIT] = " + materiel.unit + ","; update += "[UNIT_PURCHASE] = " + materiel.unitPurchase + ","; update += "[UNIT_SALE] = " + materiel.unitSale + ","; update += "[UNIT_STORAGE] = " + materiel.unitStorage + ","; update += "[VALUATION] = " + materiel.valuation + ","; update += "[BRAND] = '" + materiel.brand + "',"; update += "[NOTE] = '" + materiel.note + "'"; update += " WHERE PKEY = " + Convert.ToString(pkey); try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, update); MessageBoxExtend.messageOK("数据修改成功"); load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } }
public void registerInLedger(string billNumber, bool isRedBill) { /*函数处理逻辑如下: * 1、更新单据是否入账标示,把标示修改为1(已入账) * 1、如果采购方式为赊购并且发生了运输费用或其他费用,询问用户是否把运输费用或者其他费用计入应付账款 * 2、根据采购单详细信息,更新库存表,如果发生了运输费用或其他费用,需要把运输费用和其他费用计入物料单价 * 3、如果单据是根据采购订单生成,更新对应采购订单中的实际入库数量 */ m_isRedBill = isRedBill; // 更新应付账款 updateAccountPayableData(billNumber); // 更新库存表 updateMaterielData(billNumber); // 如果本张采购入库单是根据某采购订单生成,需要更新采购订单的实际入库数量字段 updataActualValue(billNumber); // 更新是否入账标示 string update = "UPDATE [dbo].[PURCHASE_IN_ORDER] SET "; update += "[ORDERR_IN_LEDGER] = " + DbPublic.getInctance().getCurrentLoginUserID() + ","; update += "IN_LEDGER_DATE = '" + DateTime.Now.ToString("yyyyMMdd") + "', IS_IN_LEDGER = 1"; update += " WHERE BILL_NUMBER = '" + billNumber + "'"; try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, update); MessageBoxExtend.messageOK("单据[" + billNumber + "]入账成功"); load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } writeOperatorLog(102, OperatorLogType.Register, billNumber); }
public void insert(MaterielProOccupiedOrderTable record, bool isDisplayMessageBox = true) { MaterielProOccupiedOrderTable oldRecord = new MaterielProOccupiedOrderTable(); string insert = "INSERT INTO [dbo].[WAREHOUSE_MANAGEMENT_PRO_OCCUPIED]([TRADING_DATE],[BILL_NUMBER],[EXCHANGES_UNIT],[SUM_VALUE],[SUM_MONEY],"; insert += "[MAKE_ORDER_STAFF],[APPLY_STAFF]) VALUES("; // 根据单据编号,判断库中是否已经存在该单据 如果存在单据首先删除单据,然后再执行插入操作 if (checkBillIsExist(record.billNumber)) { delete(record.billNumber); } insert += "'" + record.tradingDate + "',"; insert += "'" + record.billNumber + "',"; insert += "'" + record.exchangesUnit + "',"; insert += "'" + record.sumValue + "',"; insert += "'" + record.sumMoney + "',"; insert += record.makeOrderStaff + ","; insert += record.applyStaffId + ")"; try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, insert); if (isDisplayMessageBox) { MessageBoxExtend.messageOK("数据保存成功"); } load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } writeOperatorLog(306, OperatorLogType.Add, record.billNumber); }
public void insert(SupplierTable supplier) { string insert = "INSERT INTO [dbo].[BASE_SUPPLIER_LIST] ([SUPPLIER_TYPE],[NAME],[NAME_SHORT],[MNEMONIC_CODE],[AREA],"; insert += "[CREDIT],[VAT_RATE],[CONTACT],[TEL],[FAX],[MOBILE_PHONE],[E-MAIL],[HOME_PAGE],[COMPANY_ADDRESS],[ZIP_CODE],"; insert += "[BANK_NAME],[BANK_ACCOUNT],[TAX_ACCOUNT],[NOTE],[IS_FORBID]) VALUES("; insert += supplier.supplierType + ","; insert += "'" + supplier.name + "',"; insert += "'" + supplier.nameShort + "',"; insert += "'" + supplier.mnemonicCode + "',"; insert += "'" + supplier.area + "',"; insert += supplier.credit + ","; insert += supplier.varRate + ","; insert += "'" + supplier.contact + "',"; insert += "'" + supplier.tel + "',"; insert += "'" + supplier.fax + "',"; insert += "'" + supplier.mobilePhone + "',"; insert += "'" + supplier.email + "',"; insert += "'" + supplier.homePage + "',"; insert += "'" + supplier.address + "',"; insert += "'" + supplier.zipCode + "',"; insert += "'" + supplier.bankName + "',"; insert += "'" + supplier.bankAccount + "',"; insert += "'" + supplier.taxAccount + "',"; insert += "'" + supplier.note + "', 0"; insert += ")"; try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, insert); MessageBoxExtend.messageOK("数据保存成功"); load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } }
private void save_Click(object sender, EventArgs e) { m_isSaveSuccessFul = false; if ((sender.ToString() == "保存" || sender.ToString() == "审核") && FormProjectInfoChange.getInctance().checkBillIsReview(this.labelBillNumber.Text.ToString())) { MessageBoxExtend.messageWarning("单据已被审核,所有数据无法进行更改,无法重复保存或审核\r\n请重新登录或手动刷新后查看单据详情"); return; } this.ActiveControl = this.toolStrip1; // 得到详细的采购信息 ArrayList dataList = getOrderDetailsValue(); if (dataList.Count > 0) { // 采购订单表头和表尾信息 geTableHadeAndEndValue(); if (purchaseOrderIsFull(m_currentOrderInfo) && purchaseOrderDetailsIsFull(dataList)) { FormProjectInfoChange.getInctance().insert(m_currentOrderInfo, false); ProjectManagerDetails.getInctance().insert(dataList); BillNumber.getInctance().inserBillNumber(BillTypeNumber, this.labelMakeDate.Text, this.labelBillNumber.Text.ToString()); if (m_billNumber.Length == 0) { MessageBoxExtend.messageOK("数据保存成功"); } m_isSaveSuccessFul = true; this.Close(); } } else { MessageBoxExtend.messageWarning("此单据不包含任何交易信息,单据保存失败."); } }
public void insert(CustomerTypeTable customerType) { string insert = "INSERT INTO [dbo].[BASE_CUSTOMER_TYPE] ([TYPE_NAME],[DESC]) VALUES ("; insert += "'" + customerType.name + "',"; insert += "'" + customerType.desc + "'"; insert += ")"; try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, insert); MessageBoxExtend.messageOK("数据保存成功"); load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } }
private void buttonEnter_Click(object sender, EventArgs e) { if (AccessAuthorization.getInctance().passwordIsValidate(this.comboBoxUserName.Text.ToString(), this.textBoxPassword.Text.ToString(), out m_currentLoginUser)) { m_loginSuccessful = true; DbPublic.getInctance().setCurrentLoginUserName(m_currentLoginUser.staffName); DbPublic.getInctance().setCurrentLoginUserID(m_currentLoginUser.pkey); // 更新BASE_SYSTEM_CURRENT_LOGIN_USER表 CurrentLoginUser.getInctance().insert(); this.Close(); } else { MessageBoxExtend.messageWarning("密码错误,请重新输入!"); this.textBoxPassword.Text = ""; this.textBoxPassword.Focus(); } }
public void update(string billNumber, int reviewStaffID, double balance) { string update = "UPDATE [dbo].[CASH_CASHSUB_LEDGER] SET "; update += "[ORDERR_EVIEW] = " + reviewStaffID; update += ", [BALANCE] = " + balance; update += ", [IS_REVIEW] = 1"; update += " WHERE BILL_NUMBER = '" + billNumber + "'"; try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, update); load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } }
public void updateInStorageValue(string billNumber, string rowNumber, string actualValue) { string update = "UPDATE [dbo].[PURCHASE_IN_ORDER_DETAILS] SET "; update += "IS_IN_STORAGE = 1, "; update += "ACTUAL_VALUE = " + Convert.ToInt32(actualValue.ToString()); update += " WHERE BILL_NUMBER = '" + billNumber + "' AND ROW_NUMBER = '" + rowNumber + "'"; try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, update); load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } }
public void insert(SupplierOrgStructTable supplierOrgStruct) { string insert = "INSERT INTO [dbo].[BASE_SUPPLIER_ORG_STRUCT] ([VALUE],[PARENT_PKEY]) VALUES ("; insert += "'" + supplierOrgStruct.value + "',"; insert += Convert.ToString(supplierOrgStruct.parentPkey); insert += ")"; try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, insert); MessageBoxExtend.messageOK("数据保存成功"); load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } }
private void save_Click(object sender, EventArgs e) { m_isSaveSuccess = false; if ((sender.ToString() == "保存" || sender.ToString() == "审核") && SaleOrder.getInctance().checkBillIsReview(this.labelBillNumber.Text.ToString())) { MessageBoxExtend.messageWarning("单据已被审核,所有数据无法进行更改,无法重复保存或审核\r\n请重新登录或手动刷新后查看单据详情"); return; } this.ActiveControl = this.toolStrip1; // 得到详细的销售信息 ArrayList dataList = getSaleOrderDetailsValue(); if (dataList.Count > 0) { // 销售订单表头和表尾信息 SaleOrderTable record = getSaleOrderValue(); if (purchaseOrderIsFull(record) && purchaseOrderDetailsIsFull(dataList)) { SaleOrder.getInctance().insert(record, false); SaleOrderDetails.getInctance().insert(dataList); BillNumber.getInctance().inserBillNumber(BillTypeNumber, this.labelTradingDate.Text, this.labelBillNumber.Text.ToString()); m_isSaveSuccess = true; if (m_billNumber.Length == 0) { MessageBoxExtend.messageOK("数据保存成功"); } this.Close(); } } else { MessageBoxExtend.messageWarning("此单据不包含任何交易信息,单据保存失败."); } }
public void insert(MaterielTable materiel) { string insert = "INSERT INTO [dbo].[BASE_MATERIEL_LIST] ([SUPPLIER_TYPE],[NAME],[NUM],[NAME_SHORT],[MODEL],[MNEMONIC_CODE],[BRAND],"; insert += "[MAX],[MIN],[WARRANTY],[MATERIEL_ATTRIBUTE],[UNIT],[UNIT_PURCHASE],[UNIT_SALE],[UNIT_STORAGE],"; insert += "[VALUATION],[NOTE],[STORAGE],[IS_FORBID]) VALUES("; insert += materiel.materielType + ","; insert += "'" + materiel.name + "',"; insert += "'" + materiel.num + "',"; insert += "'" + materiel.nameShort + "',"; insert += "'" + materiel.model + "',"; insert += "'" + materiel.mnemonicCode + "',"; insert += "'" + materiel.brand + "',"; insert += materiel.max + ","; insert += materiel.min + ","; insert += materiel.warramty + ","; insert += materiel.materielAttribute + ","; insert += materiel.unit + ","; insert += materiel.unitPurchase + ","; insert += materiel.unitSale + ","; insert += materiel.unit + ","; insert += materiel.valuation + ","; insert += "'" + materiel.note + "',"; insert += materiel.storage + ", 0"; insert += ")"; try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, insert); MessageBoxExtend.messageOK("数据保存成功"); load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } }
private void toolStripButtonReview_Click(object sender, EventArgs e) { try { if (m_billNumber.Length > 0) { save_Click(sender, e); if (m_isSaveSuccessFul) { FormProjectInfoChange.getInctance().billReview(this.labelBillNumber.Text); MessageBoxExtend.messageOK("单据审核成功"); } } } catch (Exception exp) { MessageBoxExtend.messageError(exp.ToString()); } }
protected bool deleteRecord(string tableName, int pkey, bool isShowMessage = true) { string delete = "DELETE FROM [dbo].[" + tableName + "] WHERE PKEY = " + Convert.ToString(pkey); try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, delete); if (isShowMessage) { MessageBoxExtend.messageOK("数据删除成功"); } return(true); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return(false); } }
public bool modifyMaterielType(int m_materielGroupPkey, int pkey) { string update = "UPDATE [dbo].[BASE_MATERIEL_LIST] SET [SUPPLIER_TYPE] = "; update += Convert.ToString(m_materielGroupPkey); update += " WHERE PKEY = " + Convert.ToString(pkey); try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, update); load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return(false); } return(true); }
private void FormMain_FormClosing(object sender, FormClosingEventArgs e) { if (m_isExitQuestion) { if (MessageBoxExtend.messageQuestion("确定退出系统?")) { // 更新BASE_SYSTEM_CURRENT_LOGIN_USER表 CurrentLoginUser.getInctance().delete(); e.Cancel = false; } else { e.Cancel = true; } } else { // 更新BASE_SYSTEM_CURRENT_LOGIN_USER表 CurrentLoginUser.getInctance().delete(); } }
public void insert(UserOrgStructTable userOrgStruct) { string insert = "INSERT INTO [dbo].[BASE_USER_ORG_STRUCT] ([DEPARTMENT_OR_STAFF],[VALUE],[PARENT_PKEY]) VALUES ("; insert += Convert.ToString(userOrgStruct.departmentOrStaff) + ","; insert += Convert.ToString(userOrgStruct.value) + ","; insert += Convert.ToString(userOrgStruct.parentPkey); insert += ")"; try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, insert); MessageBoxExtend.messageOK("数据保存成功"); load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } }
private void FormMain_Load(object sender, EventArgs e) { //检测系统是否已经注册为正版 if (!DbPublic.getInctance().isGenuineSoftware()) { this.Text = this.Text + "(试用版)"; } else { // 如果已注册为正版,检测当初注册时硬盘序列号和本次启动机器硬盘序列号是否相同,如果相同则视为正常,否则视同一序列号多人使用 if (DbPublic.getInctance().getRegisterSoftwareKey() != SettlmentWay.getInctance().getSoftwareKey()) { MessageBoxExtend.messageWarning("同一软件序列号涉嫌多单位使用,程序将立即退出。\n如需继续使用该系统,请联系软件供应商。"); CurrentLoginUser.getInctance().delete(); Process.GetCurrentProcess().Kill(); } } // 当系统未被初始化时,单据菜单、序时簿菜单不能显示 this.menuBill.Visible = InitSubSystemSign.getInctance().isFinancialSystemInit() && InitSubSystemSign.getInctance().isBusinessSystemInit(); this.menuSquence.Visible = InitSubSystemSign.getInctance().isFinancialSystemInit() && InitSubSystemSign.getInctance().isBusinessSystemInit(); // 左侧功能按钮初始化 LoadFunctionZone(); this.WindowState = FormWindowState.Maximized; // 更新状态栏信息 string statusBarText = DbPublic.getInctance().getCurrentDateStage(); statusBarText += " "; statusBarText += "用户:" + DbPublic.getInctance().getCurrentLoginUserName(); this.toolStripStatusLabel.Text = statusBarText; // 2017-5-10 开启一个新的线程,完成数据库备份 Thread databaseBackTread = new Thread(new ThreadStart(ThreadFuction)); databaseBackTread.Start(); }
private void buttonSend_Click(object sender, EventArgs e) { if (this.textBoxName.Text.Length == 0) { MessageBoxExtend.messageWarning("企业名称不能为空."); return; } if (this.textBoxPeople.Text.Length == 0) { MessageBoxExtend.messageWarning("联系人不能为空."); return; } if (this.textBoxPhone.Text.Length == 0) { MessageBoxExtend.messageWarning("联系电话不能为空."); return; } if (this.textBoxContent.Text.Length == 0) { MessageBoxExtend.messageWarning("问题描述不能为空."); return; } string emailTitle = this.textBoxName.Text + "#" + this.textBoxPeople.Text + "#" + this.textBoxPhone.Text; string emailContent = this.textBoxContent.Text; try { SMTP.sendEmail(emailTitle, emailContent); MessageBoxExtend.messageOK("信息反馈成功"); this.Close(); } catch (Exception exp) { MessageBoxExtend.messageError("信息发送失败!\n\n请确认电脑是否已连接到Internet,然后重新.\n如果依然无法发送请联系软件供应商.\n" + exp.ToString()); } }
private void buttonEnter_Click(object sender, EventArgs e) { m_startDate = this.dateTimePickerStartDate.Value.ToString("yyyyMMdd"); m_endDate = this.dateTimePickerEndDate.Value.ToString("yyyyMMdd"); m_allReview = Convert.ToString(this.comboBoxReview.SelectedIndex); if (radioButtonMateriel.Checked) { if (this.textBoxName.Text.Length <= 0) { m_materielPkey = -1; MessageBoxExtend.messageWarning("输出的物料名称为空, 查询不到对应的物料信息, 请重新输出或点击物料选择按钮"); this.textBoxName.Text = ""; return; } } else if (radioButtonInterregional.Checked) { m_materielPkey = -1; if (this.textBoxStartID.Text.Length <= 0) { MessageBoxExtend.messageWarning("输出的物料开始ID为空, 请重新输出"); this.textBoxStartID.Text = ""; return; } if (this.textBoxEndID.Text.Length <= 0) { MessageBoxExtend.messageWarning("输出的物料结束ID为空, 请重新输出"); this.textBoxEndID.Text = ""; return; } } this.Close(); }
private void checkAccountBillDetaile() { if (m_billNumber.Length > 0) { if (m_orderType == OrderType.PurchaseApplyOrder) { FormPurchaseApply fpa = new FormPurchaseApply(m_billNumber); fpa.ShowDialog(); updateDataGridView(); } else if (m_orderType == OrderType.PurchaseOrder) { FormPurchaseOrder fpo = new FormPurchaseOrder(m_billNumber); fpo.ShowDialog(); updateDataGridView(); } else if (m_orderType == OrderType.PurchaseIn) { FormPurchaseInOrder fpo = new FormPurchaseInOrder(m_billNumber); fpo.ShowDialog(); updateDataGridView(); } else if (m_orderType == OrderType.StorageMaterielOut) { FormMaterielOutOrder fmoo = new FormMaterielOutOrder(m_billNumber); fmoo.ShowDialog(); updateDataGridView(); } else if (m_orderType == OrderType.ChangeApply) { FormProjectMaterielChangeOrder fmoo = new FormProjectMaterielChangeOrder(m_billNumber); fmoo.ShowDialog(); updateDataGridView(); } else { MessageBoxExtend.messageWarning("暂时不支持的序时薄类型"); } } }
public void updataReceivedInfo(string billNumber, double paymentOK) { SaleOutOrderTable record = getSaleInfoFromBillNumber(billNumber); double paymentNoOK = Convert.ToDouble(record.totalMoney.ToString()) - paymentOK; string update = "UPDATE [dbo].[SALE_OUT_ORDER] SET "; update += "RECEIVED_OK = " + paymentOK + ", "; update += "RECEIVED_NO_OK = " + paymentNoOK; update += " WHERE BILL_NUMBER = '" + billNumber + "'"; try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, update); load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } }
private void dataGridViewDataList_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e) { if (e.ColumnIndex == (int)DataGridColumnName.MatetielNumber) { //验证DataGridView是否又空的行 int nullRowNumber = m_dateGridVeiwListDataList.getExistNullRow(e.RowIndex); if (nullRowNumber != -1) { MessageBoxExtend.messageWarning("行号[" + Convert.ToString(nullRowNumber + 1) + "]数据为空,请现在空行中输入"); dataGridViewDataList.CurrentCell = this.dataGridViewDataList.Rows[nullRowNumber].Cells[(int)DataGridColumnName.MatetielNumber]; m_rowIndex = nullRowNumber; m_columnIndex = e.ColumnIndex; return; } } m_rowIndex = e.RowIndex; m_columnIndex = e.ColumnIndex; }
private bool orderInfoIsFull(MaterielOutOrderTable record) { if (record.departmentID == -1) { MessageBoxExtend.messageWarning("客户信息不完整,单据保存失败"); return(false); } if (record.tradingDate.Length == 0) { MessageBoxExtend.messageWarning("日期不完整,单据保存失败"); return(false); } if (record.materielOutStaffId == -1) { MessageBoxExtend.messageWarning("领料人信息不完整,单据保存失败"); return(false); } return(true); }
private bool orderInfoIsFull(MaterielProOccupiedOrderTable record) { if (record.tradingDate.Length == 0) { MessageBoxExtend.messageWarning("日期不能为空,单据保存失败"); return(false); } if (record.exchangesUnit.Length == 0) { MessageBoxExtend.messageWarning("用途信息不能为空,单据保存失败"); return(false); } if (record.applyStaffId == -1) { MessageBoxExtend.messageWarning("申请人信息不完整,单据保存失败"); return(false); } return(true); }
public void update(int pkey, SupplierOrgStructTable supplierOrgStruct) { string update = "UPDATE [dbo].[BASE_SUPPLIER_ORG_STRUCT] SET "; update += "[VALUE] = '" + supplierOrgStruct.value + "',"; update += "[PARENT_PKEY] = " + Convert.ToString(supplierOrgStruct.parentPkey) + " "; update += "WHERE PKEY = " + Convert.ToString(pkey); try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, update); MessageBoxExtend.messageOK("数据修改成功"); load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } }
private bool openExcelFile(string fileName) { bool isRet = false; try { m_excelApp = new Microsoft.Office.Interop.Excel.Application(); m_excelWorkbook = m_excelApp.Workbooks.Open(fileName); m_excelSheet = (Excel.Worksheet)m_excelWorkbook.Sheets["单据模板"]; m_excelApp.Visible = false; isRet = true; } catch (Exception error) { MessageBoxExtend.messageWarning("输出导出出错:" + error.Message); release(); } return(isRet); }
private void ToolStripMenuItemCheckDetailed_Click(object sender, EventArgs e) { if (dataGridViewDataList.Rows[m_rowIndex].Cells[1].Value.ToString().Length > 0) { int materielID = Convert.ToInt32(dataGridViewDataList.Rows[m_rowIndex].Cells[1].Value.ToString()); if (this.labelProject.Text.Length <= 0) { if (!MessageBoxExtend.messageQuestion("材料表编号为空, 可能无法显示出材料表中的相关数据, 是否继续查看?")) { return; } } FormMaterielDetailed fmd = new FormMaterielDetailed(materielID, this.labelProject.Text); fmd.ShowDialog(); } else { MessageBoxExtend.messageWarning("选择行的物料ID为空, 请重新选择"); } }
public void update(int pkey, CustomerTypeTable customerType) { string update = "UPDATE [dbo].[BASE_CUSTOMER_TYPE] SET "; update += "[TYPE_NAME] = '" + customerType.name + "',"; update += "[DESC] = '" + customerType.desc + "' "; update += "WHERE PKEY = " + Convert.ToString(pkey); try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, update); MessageBoxExtend.messageOK("数据修改成功"); load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } }
public void update(int pkey, CustomerTable customer) { string update = "UPDATE [dbo].[BASE_CUSTOMER_LIST] SET "; update += "[SUPPLIER_TYPE] = " + customer.customerType + ","; update += "[NAME] = '" + customer.name + "',"; update += "[NAME_SHORT] = '" + customer.nameShort + "',"; update += "[MNEMONIC_CODE] = '" + customer.mnemonicCode + "',"; update += "[AREA] = '" + customer.area + "',"; update += "[CREDIT] = " + customer.credit + ","; update += "[VAT_RATE] = " + customer.varRate + ","; update += "[CONTACT] = '" + customer.contact + "',"; update += "[TEL] = '" + customer.tel + "',"; update += "[FAX] = '" + customer.fax + "',"; update += "[MOBILE_PHONE] = '" + customer.mobilePhone + "',"; update += "[E-MAIL] = '" + customer.email + "',"; update += "[HOME_PAGE] = '" + customer.homePage + "',"; update += "[COMPANY_ADDRESS] = '" + customer.address + "',"; update += "[ZIP_CODE] = '" + customer.zipCode + "',"; update += "[BANK_NAME] = '" + customer.bankName + "',"; update += "[BANK_ACCOUNT] = '" + customer.bankAccount + "',"; update += "[TAX_ACCOUNT] = '" + customer.taxAccount + "',"; update += "[NOTE] = '" + customer.note + "'"; update += "WHERE PKEY = " + Convert.ToString(pkey); try { DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, update); MessageBoxExtend.messageOK("数据修改成功"); load(); } catch (Exception error) { MessageBoxExtend.messageWarning(error.Message); return; } }