private void dgvInvoice_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (e.ColumnIndex == dgvInvoice.Columns["ColAudit"].Index) { if (DialogResult.Yes == MessageBox.Show("确认审核通过?", "提示", MessageBoxButtons.YesNo)) { int ret = new T_InvoiceTableAdapter().UpdateBusinessAudit(Classes.PubClass.UserId, "商务已审核等待财务审核", Convert.ToInt64(dgvInvoice.Rows[e.RowIndex].Cells["idDataGridViewTextBoxColumn"].Value)); if (ret > 0) { MessageBox.Show("提交成功"); dgvInvoice.Rows.RemoveAt(e.RowIndex); } else { MessageBox.Show("提交失败"); } } } if (e.ColumnIndex == dgvInvoice.Columns["ColAudit1"].Index) { if (DialogResult.Yes == MessageBox.Show("确认审核不通过?", "提示", MessageBoxButtons.YesNo)) { int ret = new T_InvoiceTableAdapter().UpdateBusinessAudit(Classes.PubClass.UserId, "商务审核不通过", Convert.ToInt64(dgvInvoice.Rows[e.RowIndex].Cells["idDataGridViewTextBoxColumn"].Value)); if (ret > 0) { MessageBox.Show("提交成功"); dgvInvoice.Rows.RemoveAt(e.RowIndex); } else { MessageBox.Show("提交失败"); } } } } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { Decimal Money, MaxMoney; try { if (cmbUserName.SelectedIndex == -1) { toolTip1.Show("请选择销售人员", cmbUserName, 0, cmbUserName.Height, 2000); return; } if (cmbCustomerName.SelectedIndex == -1) { toolTip1.Show("请选择客户名称", cmbCustomerName, 0, cmbCustomerName.Height, 2000); return; } if (Decimal.TryParse(txtMoney.Text, out Money) == false) { toolTip1.Show("金额必须输入数字", txtMoney, 0, txtMoney.Height, 2000); return; } //组InvoiceContent string InvoiceContent = string.Empty; for (int i = 1; i <= mCount; i++) { Control control; //名称 control = groupBox1.Controls.Find("txtName" + i.ToString(), false)[0]; if (control.Text.Trim() == string.Empty) { MessageBox.Show("请输入开票名称" + i.ToString()); return; } InvoiceContent += control.Text.Trim() + "!#!"; //单价 control = groupBox1.Controls.Find("txtPrice" + i.ToString(), false)[0]; if (control.Text.Trim() == string.Empty) { MessageBox.Show("请选择出库单" + i.ToString()); return; } InvoiceContent += control.Text.Trim() + "!#!"; //数量 control = groupBox1.Controls.Find("txtNum" + i.ToString(), false)[0]; if (control.Text.Trim() == string.Empty) { MessageBox.Show("请选择出库单" + i.ToString()); return; } InvoiceContent += control.Text.Trim() + "!#!"; //金额 control = groupBox1.Controls.Find("txtSum" + i.ToString(), false)[0]; if (control.Text.Trim() == string.Empty) { MessageBox.Show("请选择出库单" + i.ToString()); return; } InvoiceContent += control.Text.Trim() + "!#!"; } InvoiceContent = InvoiceContent.TrimEnd("!#!".ToCharArray()); //去除最后的分隔符 //MaxMoney = Decimal.Parse(txtMaxMoney.Text);//最大可开金额 //if (MaxMoney < Money) //{ // toolTip1.Show("金额不能大于最大可开金额", txtMoney, 0, txtMoney.Height, 2000); // return; //} T_InvoiceTableAdapter adapter = new T_InvoiceTableAdapter(); int ret = 0; long InvoiceId = 0; //if (mId == -1) //{ using (var mConn = new SqlConnection(Common.CommonClass.SqlConnStr)) { mConn.Open(); using (var mTrans = mConn.BeginTransaction()) { try { adapter.Connection = mConn; adapter.Transaction = mTrans; InvoiceId = (long)adapter.MyInsert(Convert.ToInt64(cmbUserName.SelectedValue), Convert.ToInt64(cmbCustomerName.SelectedValue), InvoiceContent, dtpInvioceDate.Value.Date, cmbInvoiceType.Text, Money, null, null, null, null, "已提交等待商务审核"); if (InvoiceId > 0) { T_InvoiceOutStockTableAdapter adInvoiceOutStock = new T_InvoiceOutStockTableAdapter(); adInvoiceOutStock.Connection = mConn; adInvoiceOutStock.Transaction = mTrans; decimal canInvoice = 0; T_InvoiceNumTableAdapter inAdapter = new T_InvoiceNumTableAdapter(); inAdapter.Connection = mConn; inAdapter.Transaction = mTrans; for (int i = 1; i <= mCount; i++) //开票条目 { for (int m = 0; m < mInvoiceDatails[i].Rows.Count; m++) // 每个条目下的开票出库详细 { //获取销售销售记录的当前最大可开票数量 canInvoice = 0; canInvoice = Convert.ToDecimal(inAdapter.GetCanInvoiceNum(Convert.ToInt64(mInvoiceDatails[i].Rows[m]["SaleDetailsId"]))); if (canInvoice < Convert.ToDecimal(mInvoiceDatails[i].Rows[m]["Amount"])) { mTrans.Rollback(); MessageBox.Show("开票内容" + i.ToString() + "中的第" + (m + 1).ToString() + "条记录超过可开票数量"); return; } ret = adInvoiceOutStock.Insert(InvoiceId, i, Convert.ToInt64(mInvoiceDatails[i].Rows[m]["SaleDetailsId"]), Convert.ToDecimal(mInvoiceDatails[i].Rows[m]["Price"]), Convert.ToDecimal(mInvoiceDatails[i].Rows[m]["Amount"]), Convert.ToDecimal(mInvoiceDatails[i].Rows[m]["SumMoney"])); if (ret < 1) { mTrans.Rollback(); MessageBox.Show("提交失败"); } } } mTrans.Commit(); MessageBox.Show("提交成功"); btnSave.Enabled = false; } else { mTrans.Rollback(); MessageBox.Show("提交失败"); } } catch (Exception ex) { mTrans.Rollback(); MessageBox.Show(ex.Message); } } } //} } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void dgvInvoice_CellClick(object sender, DataGridViewCellEventArgs e) { try { if (e.ColumnIndex == dgvInvoice.Columns["ColAudit"].Index) { using (var mForm = new 开票审核_输入发票号()) { if (DialogResult.OK == mForm.ShowDialog()) { string InvoiceNo = mForm.txtInvoiceNo.Text.Trim(); int ret = new T_InvoiceTableAdapter().UpdateFinanceAudit("财务已开票", Classes.PubClass.UserId, InvoiceNo, Convert.ToInt64(dgvInvoice.Rows[e.RowIndex].Cells["idDataGridViewTextBoxColumn"].Value)); if (ret > 0) { MessageBox.Show("提交成功"); dgvInvoice.Rows.RemoveAt(e.RowIndex); } else { MessageBox.Show("提交失败"); } } } } if (e.ColumnIndex == dgvInvoice.Columns["ColAudit1"].Index) { if (DialogResult.Yes == MessageBox.Show("确认审核不通过?", "提示", MessageBoxButtons.YesNo)) { int ret = new T_InvoiceTableAdapter().UpdateFinanceAudit("财务审核不通过", Classes.PubClass.UserId, null, Convert.ToInt64(dgvInvoice.Rows[e.RowIndex].Cells["idDataGridViewTextBoxColumn"].Value)); if (ret > 0) { MessageBox.Show("提交成功"); dgvInvoice.Rows.RemoveAt(e.RowIndex); } else { MessageBox.Show("提交失败"); } } } if (e.ColumnIndex == dgvInvoice.Columns["ColModify"].Index) { using (var mForm = new 开票审核_输入发票号()) { if (DialogResult.OK == mForm.ShowDialog()) { int ret = new T_InvoiceTableAdapter().UpdateInvoiceNo(mForm.txtInvoiceNo.Text.Trim(), Convert.ToInt64(dgvInvoice.Rows[e.RowIndex].Cells["idDataGridViewTextBoxColumn"].Value)); if (ret > 0) { MessageBox.Show("提交成功"); } else { MessageBox.Show("提交失败"); } } } } if (e.ColumnIndex == ColCancel.Index) { if (MessageBox.Show("确定作废吗?", "警告", MessageBoxButtons.OKCancel) == DialogResult.OK) { int ret = new T_InvoiceTableAdapter().UpdateFinanceAudit("发票作废", Classes.PubClass.UserId, dgvInvoice.Rows[e.RowIndex].Cells[invoiceNoDataGridViewTextBoxColumn.Index].Value.ToString(), Convert.ToInt64(dgvInvoice.Rows[e.RowIndex].Cells["idDataGridViewTextBoxColumn"].Value)); if (ret > 0) { MessageBox.Show("提交成功"); btnSerch.PerformClick(); //dgvInvoice.Rows.RemoveAt(e.RowIndex); } else { MessageBox.Show("提交失败"); } } } //if (e.ColumnIndex == dgvInvoice.Columns["ColCombine"].Index && Classes.PubClass.UserStatus == "正常") //{ // string mCompanyName = "651984618945316891318"; // int mCount = 0; // foreach (DataGridViewRow mRow in dgvInvoice.Rows) // { // if (Convert.ToBoolean(mRow.Cells["ColPrint"].Value) == true) // { // mCompanyName = mRow.Cells["customerNameDataGridViewTextBoxColumn"].Value.ToString(); // mCount++; // } // } // if (mCount >= 20) // { // MessageBox.Show("选中的个数不能超过20个"); // return; // } // if (mCompanyName != "651984618945316891318" && Convert.ToString(dgvInvoice.Rows[e.RowIndex].Cells["customerNameDataGridViewTextBoxColumn"].Value) != mCompanyName) // { // DataGridViewCheckBoxCell mCell = dgvInvoice[e.ColumnIndex, e.RowIndex] as DataGridViewCheckBoxCell; // mCell.EditingCellFormattedValue = false; // mCell.EditingCellValueChanged = true; // mCell.Value = mCell.FormattedValue; // MessageBox.Show("与已选择的公司名称不一致"); // } // else // { // DataGridViewCheckBoxCell mCell = dgvInvoice[e.ColumnIndex, e.RowIndex] as DataGridViewCheckBoxCell; // mCell.EditingCellFormattedValue = bool.Parse(mCell.EditedFormattedValue.ToString()); // mCell.EditingCellValueChanged = true; // mCell.Value = mCell.FormattedValue; // } //} } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }