/// <summary>
/// 发票作废
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItem22_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
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_ac001 = string.Empty;
//if(gridView1.GetRowCellValue(rowHandle, "AC001") != null)
// s_ac001 = gridView1.GetRowCellValue(rowHandle, "AC001").ToString();
string s_fa001 = gridView1.GetRowCellValue(rowHandle, "FA001").ToString();
string s_fa190 = gridView1.GetRowCellValue(rowHandle, "FA190").ToString();
string s_fpinfo = string.Empty;
if (s_fa190 == "3" /* 原财政发票 */)
{
Tools.msg(MessageBoxIcon.Exclamation, "提示", "不能作废以前财政发票收费!");
return;
}
if (XtraMessageBox.Show("确认要作废吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
{
return;
}
//检查与开票所在工作站是否一致!!!
if (BusinessAction.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();
int re = BusinessAction.FinanceRemove(s_fa001, s_reason, Envior.cur_userId);
///作废成功,开始作废发票
if (re > 0)
{
this.RefreshData();
XtraMessageBox.Show("收费作废成功!如果本次收费已开具发票,点击【确定】开始作废已开具发票!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
CriteriaOperator criteria = CriteriaOperator.Parse("FA001='" + s_fa001 + "'");
XPCollection <FP01> xpCollection_fp01 = new XPCollection <FP01>(PersistentCriteriaEvaluationBehavior.BeforeTransaction, unitOfWork1, criteria);
foreach (FP01 fp01 in xpCollection_fp01)
{
s_fpinfo = "发票代码:" + fp01.INVOICECODE + "~t" + "发票号:" + fp01.INVOICENUM;
if (TaxInvoice.Remove(s_fa001, Envior.cur_userName) > 0) //发票作废成功
{
//修改发票作废日志
if (TaxInvoice.TaxRemove_log(s_fa001, Envior.cur_userName, s_reason) < 0)
{
XtraMessageBox.Show("记录发票日志错误,请与管理员联系!\r\n" + s_fpinfo, "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
else
{
XtraMessageBox.Show("未能作废税务发票,请在【税神通】中作废指定票据!\r\n" + s_fpinfo, "错误", 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;
}
//检查与开票所在工作站是否一致!!!
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);
}
}