/// <summary> /// 收款作废 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void bBi_remove_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { if (tabPane1.SelectedPageIndex == 0) //按笔数显示 { int rowHandle = gridView1.FocusedRowHandle; if (rowHandle >= 0) { string s_handler = gridView1.GetRowCellValue(rowHandle, "FA100").ToString(); if (!AppAction.CheckRight("收费作废", s_handler)) { return; } string s_reason = string.Empty; string s_rc001 = gridView1.GetRowCellValue(rowHandle, "AC001").ToString(); string s_fa001 = gridView1.GetRowCellValue(rowHandle, "FA001").ToString(); string s_fa190 = gridView1.GetRowCellValue(rowHandle, "FA190").ToString(); if (XtraMessageBox.Show("确认要作废吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No) { return; } //检查与开票所在工作站是否一致!!! if (MiscAction.CheckWorkStationCompare(s_fa001, Envior.WORKSTATIONID) == "0") { XtraMessageBox.Show("此笔收费发票不是在当前工作站开具,不能继续!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } Frm_RemoveFinReason frm_reason = new Frm_RemoveFinReason(); if (frm_reason.ShowDialog() == DialogResult.OK) { s_reason = frm_reason.swapdata["reason"].ToString(); } frm_reason.Dispose(); if (gridView1.GetRowCellValue(rowHandle, "FA002").ToString() == "2") //寄存业务 { decimal count = (decimal)SqlAssist.ExecuteScalar("select count(*) from v_rc04 where rc001='" + s_rc001 + "'", null); if (count <= 1) { if (XtraMessageBox.Show("此记录是唯一一次交费记录,作废此记录将删除寄存登记信息,是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No) { return; } } } int re = MiscAction.FinanceRemove(s_fa001, s_reason, Envior.cur_userId); ///作废成功,开始作废发票 if (re > 0) { this.RefreshData(); XtraMessageBox.Show("收费作废成功!如果本次收费已开具发票,点击【确定】开始作废已开具发票!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); ///作废财政发票 if (s_fa190.Substring(0, 1) == "1") { string s_pjlx = string.Empty; string s_pjh = string.Empty; string s_zch = string.Empty; //using (OracleDataReader reader_fin = SqlAssist.ExecuteReader("select * from fin_log where settleId='" + s_fa001 + "'")) //{ // reader_fin.Read(); // s_pjlx = reader_fin["INVOICEKIND"].ToString(); // s_pjh = reader_fin["INVOICENO"].ToString(); // s_zch = reader_fin["INVOICEZCH"].ToString(); // if (string.IsNullOrEmpty(s_zch)) // { // Frm_Zch_input frm_zch = new Frm_Zch_input(); // if (frm_zch.ShowDialog() == DialogResult.OK) // { // s_zch = frm_zch.swapdata["zch"].ToString(); // } // } // if (!string.IsNullOrEmpty(s_zch) && !string.IsNullOrEmpty(s_pjlx) && !string.IsNullOrEmpty(s_pjh)) // { // if (FinInvoice.Remove(s_zch, s_pjlx, s_pjh) > 0) // { //修改发票作废日志 // MiscAction.FinRemove_log(s_fa001, Envior.cur_userName, s_reason); // } // } //} }///作废税务发票 if (s_fa190.Substring(1, 1) == "1") { if (TaxInvoice.Remove(s_fa001, Envior.cur_userName) > 0) //发票作废成功 { //修改发票作废日志 MiscAction.TaxRemove_log(s_fa001, Envior.cur_userName, s_reason); } else { XtraMessageBox.Show("未能作废税务发票,请在【税神通】中作废指定票据!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } } } else //发票作废 !!!! { int rowHandle = gridView1.FocusedRowHandle; string s_fa001 = gridView3.GetRowCellValue(rowHandle, "FA001").ToString(); string s_billType = gridView3.GetRowCellValue(rowHandle, "BILLTYPE").ToString(); if (s_billType == "F") //财政发票作废 { } else if (s_billType == "T") { } } } catch (Exception ee) { XtraMessageBox.Show(ee.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
/// <summary> /// 收款作废 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void bBi_remove_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { try { if (tabPane1.SelectedPageIndex == 0) //按笔数显示 { int rowHandle = gridView1.FocusedRowHandle; if (rowHandle >= 0) { string s_handler = gridView1.GetRowCellValue(rowHandle, "FA100").ToString(); if (!AppAction.CheckRight("收费作废", s_handler)) { return; } string s_reason = string.Empty; string s_rc001 = gridView1.GetRowCellValue(rowHandle, "AC001").ToString(); string s_fa001 = gridView1.GetRowCellValue(rowHandle, "FA001").ToString(); string s_fa190 = gridView1.GetRowCellValue(rowHandle, "FA190").ToString(); if (XtraMessageBox.Show("确认要作废吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No) { return; } Frm_RemoveFinReason frm_reason = new Frm_RemoveFinReason(); if (frm_reason.ShowDialog() == DialogResult.OK) { s_reason = frm_reason.swapdata["reason"].ToString(); } frm_reason.Dispose(); if (gridView1.GetRowCellValue(rowHandle, "FA002").ToString() == "2") //寄存业务 { decimal count = (decimal)SqlAssist.ExecuteScalar("select count(*) from v_rc04 where rc001='" + s_rc001 + "'", null); if (count <= 1) { if (XtraMessageBox.Show("此记录是唯一一次交费记录,作废此记录将删除寄存登记信息,是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No) { return; } } } int re = MiscAction.FinanceRemove(s_fa001, s_reason, Envior.cur_userId); ///作废成功,开始作废发票 if (re > 0) { this.RefreshData(); XtraMessageBox.Show("收费作废成功!如果本次收费已开具发票,点击【确定】开始作废已开具发票!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); ///作废财政发票 if (s_fa190.Substring(0, 1) == "1") { //如果不在新接口上线前,则可以作废发票 if (!MiscAction.FinRefundBeforeOnline(s_fa001)) { if (FinInvoice.InvoiceRemoved(s_fa001) > 0) { MiscAction.FinRemove_log(s_fa001, Envior.cur_userName, s_reason); } } else { XtraMessageBox.Show("此笔收费为新财政发票接口上线前开具,发票需要在系统外进行作废!详情请与管理员联系!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } ///作废税务发票 if (s_fa190.Substring(1, 1) == "1") { if (TaxInvoice.Remove(s_fa001, Envior.cur_userName) > 0) //发票作废成功 { //修改发票作废日志 MiscAction.TaxRemove_log(s_fa001, Envior.cur_userName, s_reason); } else { XtraMessageBox.Show("未能作废税务发票,请在【税神通】中作废指定票据!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } } } else //发票作废 !!!! { int rowHandle = gridView1.FocusedRowHandle; string s_fa001 = gridView3.GetRowCellValue(rowHandle, "FA001").ToString(); string s_billType = gridView3.GetRowCellValue(rowHandle, "BILLTYPE").ToString(); if (s_billType == "F") //财政发票作废 { } else if (s_billType == "T") { } } } catch (Exception ee) { XtraMessageBox.Show(ee.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }