/// <summary> /// 退费操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void bBi_refund_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { int rowHandle; string s_billType = string.Empty; string s_fa001 = string.Empty; if (tabPane1.SelectedPageIndex == 0) { return; } else if (tabPane1.SelectedPageIndex == 1) { rowHandle = gridView3.FocusedRowHandle; s_billType = gridView3.GetRowCellValue(rowHandle, "BILLTYPE").ToString(); s_fa001 = gridView3.GetRowCellValue(rowHandle, "FA001").ToString(); string s_fa002 = SqlAssist.ExecuteScalar("select fa002 from fa01 where fa001='" + s_fa001 + "'").ToString(); //检查与开票所在工作站是否一致!!! if (MiscAction.CheckWorkStationCompare(s_fa001, Envior.WORKSTATIONID, s_billType) == "0") { XtraMessageBox.Show("此笔收费发票不是在当前工作站开具,不能继续!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } //if(s_fa002 == "2") //{ // XtraMessageBox.Show("此收费记录不能退费!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); // return; //} if (MiscAction.HaveRefund(s_fa001)) { XtraMessageBox.Show("此收费记录已经有退费记录,不能再次退费!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } BaseDialog frm_1 = null; if (s_billType == "F") { frm_1 = new Frm_refund_select(); } else { frm_1 = new Frm_refund_select2(); } frm_1.swapdata["SA010"] = s_fa001; //结算流水号 frm_1.swapdata["SA020"] = s_billType; //票别 if (frm_1.ShowDialog() == DialogResult.OK) { this.RefreshData(); } frm_1.Dispose(); }
/// <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); } }