/// <summary>
/// 打印财政发票
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int rowHandle = gridView1.FocusedRowHandle;
if (rowHandle >= 0)
{
if (gridView1.GetRowCellValue(rowHandle, "FA190").ToString().Substring(0, 1) == "1")
{
string s_fa001 = gridView1.GetRowCellValue(rowHandle, "FA001").ToString();
//如果是新接口上线前开具的发票,不能打印
if (MiscAction.FinRefundBeforeOnline(s_fa001))
{
XtraMessageBox.Show("此笔收费财政发票为新接口上线前开具,不能通过新接口打印!", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation);
return;
}
OracleDataReader reader = SqlAssist.ExecuteReader("select INVOICENO,INVOICEZCH from fin_log where settleId ='" + s_fa001 + "'");
if (reader.HasRows && reader.Read())
{
string s_batch_code = reader["INVOICEZCH"].ToString();
string s_billno = reader["INVOICENO"].ToString();
reader.Dispose();
if (XtraMessageBox.Show("打印财政发票?\r\n" + "注册号:" + s_batch_code + "\r\n" + "发票号:" + s_billno, "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
FinInvoice.PrintInvoice(s_batch_code, s_billno);
}
}
}
else
{
XtraMessageBox.Show("当前收费记录未开财政发票!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
}
private void simpleButton19_Click(object sender, EventArgs e)
{
if (FinInvoice.GetCurrentPh() > 0)
{
XtraMessageBox.Show(Envior.FIN_NEXT_BATCH_CODE, "注册号");
XtraMessageBox.Show(Envior.FIN_NEXT_BILL_NO, "票号");
}
}
private void simpleButton22_Click(object sender, EventArgs e)
{
int result = FinInvoice.InvoiceRemoved("3910", "00356003");
if (result > 0)
{
XtraMessageBox.Show("作废发票成功!");
}
}
/// <summary>
/// 补开财政退费发票
/// </summary>
/// <param name="fa001"></param>
private void ReInvoiceFinRefund(string fa001)
{
if (FinInvoice.GetCurrentPh() > 0)
{
if (XtraMessageBox.Show("下一张财政发票号码:" + Envior.FIN_NEXT_BILL_NO + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
FinInvoice.Refund(fa001);
}
}
}
private void simpleButton23_Click(object sender, EventArgs e)
{
string s_state = FinInvoice.GetInvoiceState("3910", "00356006");
if (!string.IsNullOrEmpty(s_state))
{
XtraMessageBox.Show(s_state, "状态");
}
else
{
XtraMessageBox.Show("未获取到状态");
}
}
private void barButtonItem26_ItemClick(object sender, ItemClickEventArgs e)
{
////税务发票测试
//TaxInvoice.WrapData();.
//TaxDemo frm_1 = new TaxDemo();
//frm_1.ShowDialog();
//frm_1.Dispose();
if (FinInvoice.InvoiceRemoved("0001563011") > 0)
{
XtraMessageBox.Show("作废成功!");
}
}
/// <summary>
/// 补开财政退费发票
/// </summary>
/// <param name="fa001"></param>
private void ReInvoiceFinRefund(string fa001)
{
//如果是新版接口上线前开具的原发票
if (MiscAction.FinRefundBeforeOnline(fa001))
{
XtraMessageBox.Show("原发票在财政新接口上线前开具,不能开具对应退费发票,请在财政发票系统内完成发票开具.\r\n 开具成功后请更新发票号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else if (FinInvoice.GetCurrentPh() > 0)
{
if (XtraMessageBox.Show("下一张财政发票号码:" + Envior.FIN_NEXT_BILL_NO + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
FinInvoice.Refund(fa001);
}
}
}
private void b_ok_Click(object sender, EventArgs e)
{
decimal nums;
if (!decimal.TryParse(comboBox1.Text, out nums))
{
XtraMessageBox.Show("请输入正确的缴费年限!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (!(bitprice > 0))
{
XtraMessageBox.Show("参数传递错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string cuname = txtEdit_rc003.Text;
string fa001 = Tools.GetEntityPK("FA01");
int re = RegisterAction.RegisterPay(rc001, fa001, bitprice, nums, Envior.cur_userId);
if (re > 0)
{
dt_rc04.Rows.Clear();
rc04Adapter.Fill(dt_rc04);
if (XtraMessageBox.Show("缴费成功!现在打印【发票】吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
if (FinInvoice.GetCurrentPh() > 0)
{
if (XtraMessageBox.Show("下一张财政发票号码:" + Envior.FIN_NEXT_BILL_NO + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
FinInvoice.Invoice(fa001);
}
}
}
if (XtraMessageBox.Show("现在打印缴费记录吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
//打印缴费记录
PrtServAction.PrtRegisterPayRecord(fa001, this.Handle.ToInt32());
}
DialogResult = DialogResult.OK;
this.Close();
}
}
/// <summary>
/// 补开发票
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (!AppAction.CheckRight("补开发票"))
{
return;
}
int rowHandle = gridView1.FocusedRowHandle;
if (rowHandle < 0)
{
return;
}
if (gridView1.GetRowCellValue(rowHandle, "FA190").ToString() == gridView1.GetRowCellValue(rowHandle, "FA195").ToString())
{
XtraMessageBox.Show("此笔收费记录已经开具发票!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string s_fa001 = gridView1.GetRowCellValue(rowHandle, "FA001").ToString();
//如果办理过退费,不能再开具发票了
if (MiscAction.HaveRefund(s_fa001))
{
XtraMessageBox.Show("此笔收费记录办理过退费,不能再开具发票!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//如果收费不是本工作站,提示
if (!string.IsNullOrEmpty(gridView1.GetRowCellValue(rowHandle, "WS001").ToString()))
{
if (!Envior.WORKSTATIONID.Equals(gridView1.GetRowCellValue(rowHandle, "WS001").ToString()))
{
if (XtraMessageBox.Show("此收费记录结算并非当前工作站,是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
}
}
//TODO 负数发票补开
if (Convert.ToDecimal(gridView1.GetRowCellValue(rowHandle, "FA004")) < 0)
{
//需要补开财政发票
if (gridView1.GetRowCellValue(rowHandle, "FA190").ToString().Substring(0, 1) == "0" && gridView1.GetRowCellValue(rowHandle, "FA195").ToString().Substring(0, 1) == "1")
{
XtraMessageBox.Show("现在开始补开【财政发票】!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
ReInvoiceFinRefund(s_fa001);
}
//需要补开税务发票
if (gridView1.GetRowCellValue(rowHandle, "FA190").ToString().Substring(1, 1) == "0" && gridView1.GetRowCellValue(rowHandle, "FA195").ToString().Substring(1, 1) == "1")
{
XtraMessageBox.Show("现在开始补开【税务发票】!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
ReInvoiceTaxRefund(s_fa001);
}
return;
}
//需要开具财政发票
if (gridView1.GetRowCellValue(rowHandle, "FA190").ToString().Substring(0, 1) == "0" &&
gridView1.GetRowCellValue(rowHandle, "FA195").ToString().Substring(0, 1) == "1")
{
XtraMessageBox.Show("现在准备开具财政发票!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (FinInvoice.GetCurrentPh() > 0)
{
if (XtraMessageBox.Show("下一张财政发票号码:" + Envior.FIN_NEXT_BILL_NO + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
FinInvoice.Invoice(s_fa001);
}
}
}
///开税票
if (gridView1.GetRowCellValue(rowHandle, "FA190").ToString().Substring(1, 1) == "0" &&
gridView1.GetRowCellValue(rowHandle, "FA195").ToString().Substring(1, 1) == "1")
{
XtraMessageBox.Show("现在准备开具税务发票!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
//获取税务客户信息
Frm_TaxClientInfo frm_taxClient = new Frm_TaxClientInfo();
if (frm_taxClient.ShowDialog() != DialogResult.OK)
{
return;
}
TaxClientInfo clientInfo = frm_taxClient.swapdata["taxclientinfo"] as TaxClientInfo;
if (TaxInvoice.GetNextInvoiceNo() < 0)
{
return; //获取票据号失败,则退出!!!
}
if (XtraMessageBox.Show("下一张税票代码:" + Envior.NEXT_BILL_CODE + "\r\n" + "票号:" + Envior.NEXT_BILL_NUM + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
TaxInvoice.Invoice(s_fa001, clientInfo);
}
}
}
/// <summary>
/// 结算
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItem18_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (!SaveCheck())
{
return;
}
string s_tip = string.Empty;
if (dec_fin > 0 && dec_tax > 0)
{
s_tip = "本次结算共需要一张财政发票和一张税务发票,是否继续?";
}
else if (dec_fin > 0)
{
s_tip = "本次结算共需要一张财政发票,是否继续?";
}
else if (dec_tax > 0)
{
s_tip = "本次结算共需要一张税务发票,是否继续?";
}
else
{
return;
}
if (XtraMessageBox.Show(s_tip, "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
if (dec_tax > 0 && !TaxInvoice.ClientIsOnline())
{
if (XtraMessageBox.Show("【税神通】客户端不在线!是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
}
string s_cuname = be_cuname.EditValue.ToString(); //交款人(或单位)
StringBuilder sb_memo = new StringBuilder(50);
List <string> itemId_List = new List <string>();
List <string> itemType_List = new List <string>();
List <decimal> prict_List = new List <decimal>();
List <decimal> nums_List = new List <decimal>();
for (int i = 0; i < gridView1.RowCount; i++)
{
itemId_List.Add(gridView1.GetRowCellValue(i, "SA004").ToString());
itemType_List.Add(gridView1.GetRowCellValue(i, "SA002").ToString());
prict_List.Add(decimal.Parse(gridView1.GetRowCellValue(i, "PRICE").ToString()));
nums_List.Add(decimal.Parse(gridView1.GetRowCellValue(i, "NUMS").ToString()));
}
string s_fa001 = Tools.GetEntityPK("FA01");
int re = FireAction.TempSalesSettle(
s_cuname, s_fa001, itemId_List.ToArray(), itemType_List.ToArray(), prict_List.ToArray(), nums_List.ToArray(), Envior.cur_userId, sb_memo.ToString());
//如果保存失败,则退出处理
if (re < 0)
{
return;
}
//清理数据
business_ds.Sa01.Rows.Clear();
be_cuname.Text = "";
te_fin_sum.Text = "";
te_tax_sum.Text = "";
XtraMessageBox.Show("结算成功!现在开始开具发票!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
////开财政票!
if (dec_fin > 0)
{
if (FinInvoice.GetCurrentPh() > 0)
{
if (XtraMessageBox.Show("下一张财政发票号码:" + Envior.FIN_NEXT_BILL_NO + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
FinInvoice.Invoice(s_fa001);
}
}
}
//// 开税票
if (dec_tax > 0)
{
//获取税务客户信息
Frm_TaxClientInfo frm_taxClient = null;
if (tu01 == null)
{
frm_taxClient = new Frm_TaxClientInfo(s_cuname);
}
else
{
frm_taxClient = new Frm_TaxClientInfo(tu01);
}
if (frm_taxClient.ShowDialog() != DialogResult.OK)
{
tu01 = null;
return;
}
TaxClientInfo clientInfo = frm_taxClient.swapdata["taxclientinfo"] as TaxClientInfo;
if (TaxInvoice.GetNextInvoiceNo(s_fa001) < 0)
{
tu01 = null;
return; //获取票据号失败,则退出!!!
}
if (XtraMessageBox.Show("下一张税票代码:" + Envior.NEXT_BILL_CODE + "\r\n" + "票号:" + Envior.NEXT_BILL_NUM + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
TaxInvoice.Invoice(s_fa001, clientInfo);
}
//////////// 保存客户信息 ///////////////
Tu01_dao tu01_dao = new Tu01_dao();
if (tu01 != null)
{
tu01.tu003 = clientInfo.InfoClientName;
tu01.tu005 = clientInfo.InfoClientTaxCode;
tu01.tu006 = clientInfo.infoclientaddressphone;
tu01.tu007 = clientInfo.infoclientbankaccount;
tu01_dao.Update(tu01);
}
else if (clientInfo.InfoClientName.Length >= 5)
{
tu01 = new Tu01();
tu01.tu001 = Tools.GetEntityPK("TU01");
tu01.tu003 = clientInfo.InfoClientName;
tu01.tu005 = clientInfo.InfoClientTaxCode;
tu01.tu006 = clientInfo.infoclientaddressphone;
tu01.tu007 = clientInfo.infoclientbankaccount;
tu01_dao.Insert(tu01);
}
tu01 = null;
}
}
/// <summary>
/// 缴费 过程
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void b_ok_Click(object sender, EventArgs e)
{
decimal nums;
decimal dec_tax_sum = decimal.Zero;
if (!decimal.TryParse(comboBox1.Text, out nums))
{
XtraMessageBox.Show("请输入正确的缴费期限!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (!(bitprice > 0))
{
XtraMessageBox.Show("参数传递错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string cuname = txtEdit_rc003.Text;
string fa001 = Tools.GetEntityPK("FA01");
int re = 0;
List <string> itemId_List = new List <string>();
List <decimal> itemPrice_List = new List <decimal>();
List <int> itemNums_List = new List <int>();
if (fpfee > 0)
{
foreach (DataRow r in dt_sa01.Rows)
{
itemId_List.Add(r["SA004"].ToString());
itemPrice_List.Add(Convert.ToDecimal(r["PRICE"]));
itemNums_List.Add(Convert.ToInt32(r["NUMS"]));
//计算税票项目金额
if (MiscAction.GetItemInvoiceType(r["SA004"].ToString()) == "T")
{
dec_tax_sum += Convert.ToDecimal(r["SA007"]);
}
}
}
if (dec_tax_sum > 0 && !TaxInvoice.ClientIsOnline())
{
if (XtraMessageBox.Show("【税神通】客户端不在线!是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
}
if (fpfee > 0)
{
re = RegisterAction.RegisterPay(rc001, fa001, bitprice, nums, new_regfee + old_regfee,
itemId_List.ToArray(), itemPrice_List.ToArray(), itemNums_List.ToArray(), Envior.cur_userId);
}
else
{
re = RegisterAction.RegisterPay(rc001, fa001, bitprice, nums, new_regfee + old_regfee, Envior.cur_userId);
}
//if (!checkEdit1.Checked)
// re = RegisterAction.RegisterPay(rc001, fa001, bitprice, nums, new_regfee + old_regfee,Envior.cur_userId);
//else
// re = RegisterAction.RegisterPay(rc001, fa001, oldprice, bitprice, oldnums, newnums, old_regfee, new_regfee, Envior.cur_userId);
if (re > 0)
{
dt_rc04.Rows.Clear();
rc04Adapter.Fill(dt_rc04);
if (XtraMessageBox.Show("缴费成功!现在打印财政【发票】吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
if (FinInvoice.GetCurrentPh() > 0)
{
if (XtraMessageBox.Show("下一张财政发票号码:" + Envior.FIN_NEXT_BILL_NO + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
FinInvoice.Invoice(fa001);
}
}
}
//// 开税票
if (dec_tax_sum > 0)
{
//获取税务客户信息
Frm_TaxClientInfo frm_taxClient = new Frm_TaxClientInfo(txtEdit_rc003.Text);
if (frm_taxClient.ShowDialog() == DialogResult.OK)
{
TaxClientInfo clientInfo = frm_taxClient.swapdata["taxclientinfo"] as TaxClientInfo;
if (TaxInvoice.GetNextInvoiceNo(fa001) > 0)
{
if (XtraMessageBox.Show("下一张税票代码:" + Envior.NEXT_BILL_CODE + "\r\n" + "票号:" + Envior.NEXT_BILL_NUM + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
TaxInvoice.Invoice(fa001, clientInfo);
}
}
}
}
if (XtraMessageBox.Show("现在打印缴费记录吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
//打印缴费记录
PrtServAction.PrtRegisterPayRecord(fa001, this.Handle.ToInt32());
}
DialogResult = DialogResult.OK;
this.Close();
}
}
private void b_ok_Click(object sender, EventArgs e)
{
decimal dec_fin = new decimal(0);
decimal dec_tax = new decimal(0);
string s_tip = string.Empty;
foreach (DataRow dr in dt_source.Rows)
{
if (dr["SA020"].ToString() == "F")
{
dec_fin += Convert.ToDecimal(dr["SA007"]);
}
else if (dr["SA020"].ToString() == "T")
{
dec_tax += Convert.ToDecimal(dr["SA007"]);
}
}
if (dec_fin > 0 && dec_tax > 0)
{
s_tip = "本次结算共需要一张财政发票和一张税务发票,是否继续?";
}
else if (dec_fin > 0)
{
s_tip = "本次结算共需要一张财政发票,是否继续?";
}
else if (dec_tax > 0)
{
s_tip = "本次结算共需要一张税务发票,是否继续?";
}
else
{
return;
}
if (XtraMessageBox.Show(s_tip, "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
string s_fa001 = Tools.GetEntityPK("FA01");
string s_cuname = FireAction.GetGuyNameById(AC001);
List <string> sa001_list = new List <string>();
foreach (DataRow r in dt_source.Rows)
{
sa001_list.Add(r["SA001"].ToString());
}
int result = FireAction.FireBusinessSettle(s_fa001,
AC001,
s_cuname,
sa001_list.ToArray(),
Envior.cur_userId
);
if (result > 0)
{
b_ok.Enabled = false;
int fire_row = gridView1.LocateByValue("SA002", "06");
//如果有火化,打印火化证明
if (fire_row >= 0)
{ //打印火化证明
if (XtraMessageBox.Show("现在打印火化证明?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
PrtServAction.Print_HHZM(AC001, 0);
}
}
XtraMessageBox.Show("结算成功!现在开始打印发票!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
////开财政票!
if (dec_fin > 0)
{
//string s_pjh = string.Empty;
//string s_zch = string.Empty;
if (FinInvoice.GetCurrentPh() > 0)
{
if (XtraMessageBox.Show("下一张财政发票号码:" + Envior.FIN_NEXT_BILL_NO + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
FinInvoice.Invoice(s_fa001);
}
}
}
//// 开税票
if (dec_tax > 0)
{
//获取税务客户信息
string s_ac003 = SqlAssist.ExecuteScalar("select ac003 from ac01 where ac001='" + AC001 + "'").ToString();
Frm_TaxClientInfo frm_taxClient = new Frm_TaxClientInfo(s_ac003);
if (frm_taxClient.ShowDialog() != DialogResult.OK)
{
return;
}
TaxClientInfo clientInfo = frm_taxClient.swapdata["taxclientinfo"] as TaxClientInfo;
if (TaxInvoice.GetNextInvoiceNo() > 0)
{
if (XtraMessageBox.Show("下一张税票代码:" + Envior.NEXT_BILL_CODE + "\r\n" + "票号:" + Envior.NEXT_BILL_NUM + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
TaxInvoice.Invoice(s_fa001, clientInfo);
}
}
}
this.DialogResult = DialogResult.OK;
this.Close();
}
}
/// <summary>
/// 退费办理
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void simpleButton1_Click(object sender, EventArgs e)
{
if (!gridView1.PostEditor())
{
return;
}
if (!gridView1.UpdateCurrentRow())
{
return;
}
List <string> itemIdList = new List <string>();
List <decimal> numsList = new List <decimal>();
List <decimal> priceList = new List <decimal>();
List <string> itemTypeList = new List <string>();
decimal dec_fin_sum = decimal.Zero;
decimal dec_temp = decimal.Zero;
for (int i = 0; i < gridView1.RowCount; i++)
{
if (decimal.TryParse(gridView1.GetRowCellValue(i, "REFUNDFEE").ToString(), out dec_temp))
{
if (dec_temp <= 0)
{
continue;
}
itemIdList.Add(gridView1.GetRowCellValue(i, "SA004").ToString());
priceList.Add(Convert.ToDecimal(gridView1.GetRowCellValue(i, "REFUNDFEE")));
numsList.Add(-1);
itemTypeList.Add(gridView1.GetRowCellValue(i, "SA002").ToString());
dec_fin_sum += Convert.ToDecimal(gridView1.GetRowCellValue(i, "REFUNDFEE"));
}
}
if (numsList.Count <= 0)
{
XtraMessageBox.Show("还未选择退费的项目!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
string s_fa001 = Tools.GetEntityPK("FA01");
string s_memo = te_memo.Text;
try
{
int re = MiscAction.FinRefundSettle(s_fa001, itemIdList.ToArray(), itemTypeList.ToArray(), priceList.ToArray(), numsList.ToArray(), Envior.cur_userId, s_memo, s_sa010);
if (re > 0)
{
XtraMessageBox.Show("退费结算完成!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
string s_fa190 = SqlAssist.ExecuteScalar("select fa190 from fa01 where fa001='" + s_sa010 + "'").ToString();
if (s_fa190.Substring(0, 1) == "1") //原收费记录 财政发票已开
{
if (FinInvoice.GetCurrentPh() > 0)
{
if (XtraMessageBox.Show("下一张财政发票号码:" + Envior.FIN_NEXT_BILL_NO + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
FinInvoice.Refund(s_fa001);
}
}
}
}
this.DialogResult = DialogResult.OK;
this.Close();
}
catch (Exception ee)
{
XtraMessageBox.Show(ee.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void b_ok_Click(object sender, EventArgs e)
{
if (rc001 == null)
{
XtraMessageBox.Show("数据传递错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (txtEdit_oc003.EditValue == null || txtEdit_oc003.EditValue is System.DBNull)
{
txtEdit_oc003.ErrorImageOptions.Alignment = ErrorIconAlignment.MiddleRight;
txtEdit_oc003.ErrorText = "请输入迁出办理人!";
return;
}
if (mem_oc005.EditValue == null)
{
mem_oc005.ErrorImageOptions.Alignment = ErrorIconAlignment.MiddleRight;
mem_oc005.ErrorText = "请输入迁出原因!";
return;
}
string s_oc003 = txtEdit_oc003.Text; //迁出人
string s_oc005 = mem_oc005.Text; //迁出原因
string s_oc004 = txtEdit_oc004.Text; //迁出人身份证号
int diff = int.Parse(txtEdit_diff.EditValue.ToString());
decimal nums = decimal.Zero;
string fa001 = Tools.GetEntityPK("FA01");
string last_fa001 = RegisterAction.GetREGLastSettleId(rc001); //获取最后一次缴费 结算流水号
//补退情况
if (checkEdit1.Checked && (!string.IsNullOrEmpty(txtEdit_nums.Text)))
{
nums = decimal.Parse(txtEdit_nums.Text);
}
else
{
nums = 0;
}
if (XtraMessageBox.Show("确认要继续办理迁出吗？本业务将不能回退!", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
{
return;
}
//if ((!string.IsNullOrEmpty(txtEdit_fee.Text)) && Convert.ToDecimal(txtEdit_fee.Text) > 0 && Envior.cur_userId != AppInfo.ROOTID && !isrefund )
//{
// XtraMessageBox.Show("当前记录已经欠费,不能迁出!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
// return;
//}
int re = RegisterAction.RegisterOut(rc001,
s_oc003,
s_oc004,
s_oc005,
diff,
fa001,
price,
isrefund ? 0 - nums : nums,
Envior.cur_userId
);
if (re > 0)
{
XtraMessageBox.Show("迁出办理成功!现在打印【迁出通知单】", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
PrtServAction.PrtRegisterOutNotice(rc001, this.Handle.ToInt32());
if (!isrefund && nums > 0)
{
if (XtraMessageBox.Show("现在开具【发票】吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
if (FinInvoice.GetCurrentPh() > 0)
{
if (XtraMessageBox.Show("下一张财政发票号码:" + Envior.FIN_NEXT_BILL_NO + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
FinInvoice.Invoice(fa001);
}
}
}
}
else if (isrefund && Math.Abs(nums) > 0) //退费发票
{
string s_old_pjlx = string.Empty;
string s_old_pjh = string.Empty;
string s_old_zch = string.Empty;
OracleDataReader reader_log = SqlAssist.ExecuteReader("select * from fin_log where settleId ='" + last_fa001 + "'");
reader_log.Read();
if (reader_log.HasRows)
{
s_old_pjlx = reader_log["INVOICEKIND"].ToString(); //票据类型
s_old_pjh = reader_log["INVOICENO"].ToString(); //票据号
s_old_zch = reader_log["INVOICEZCH"].ToString(); //注册号
}
else
{
XtraMessageBox.Show("读取缴费发票信息出错!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
reader_log.Dispose();
Frm_refundInfo frm_refund = new Frm_refundInfo(s_old_pjlx, s_old_pjh, s_old_zch);
if (frm_refund.ShowDialog() == DialogResult.OK)
{
s_old_zch = frm_refund.swapdata["zch"].ToString(); //注册号
//if (!Envior.FIN_READY)
// XtraMessageBox.Show("未连接到博思开票服务器!请稍后补开!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
//else
//{
// string s_newpjh = FinInvoice.GetCurrentPh(Envior.FIN_INVOICE_TYPE);
// if (String.IsNullOrEmpty(s_newpjh))
// XtraMessageBox.Show("未获取到下一张财政发票号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// else
// {
// if (XtraMessageBox.Show("下一张财政发票号码:" + s_newpjh + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
// {
// string s_tkitem = MiscAction.GetItemInvoiceCode("08", "") + " " + Math.Abs(nums * price) + " ";
// FinInvoice.Refund(s_old_pjlx, s_old_pjh, s_old_zch, s_tkitem, "F_Qt1=xxx|F_Qt2=xxx|F_Qt3=xxx",fa001, s_newpjh,nums * price);
// }
// }
//}
}
frm_refund.Dispose();
}
}
DialogResult = DialogResult.OK;
this.Close();
}
private void b_ok_Click(object sender, EventArgs e)
{
if (rc001 == null)
{
XtraMessageBox.Show("数据传递错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (txtEdit_oc003.EditValue == null || txtEdit_oc003.EditValue is System.DBNull)
{
txtEdit_oc003.ErrorImageOptions.Alignment = ErrorIconAlignment.MiddleRight;
txtEdit_oc003.ErrorText = "请输入迁出办理人!";
return;
}
if (mem_oc005.EditValue == null)
{
mem_oc005.ErrorImageOptions.Alignment = ErrorIconAlignment.MiddleRight;
mem_oc005.ErrorText = "请输入迁出原因!";
return;
}
string s_oc003 = txtEdit_oc003.Text; //迁出人
string s_oc005 = mem_oc005.Text; //迁出原因
string s_oc004 = txtEdit_oc004.Text; //迁出人身份证号
int diff = int.Parse(txtEdit_diff.EditValue.ToString());
decimal nums = decimal.Zero;
string fa001 = Tools.GetEntityPK("FA01");
string last_fa001 = RegisterAction.GetREGLastSettleId(rc001); //获取最后一次缴费 结算流水号
//补退情况
if (checkEdit1.Checked)
{
nums = decimal.Parse(txtEdit_nums.Text);
}
else
{
nums = 0;
}
if (XtraMessageBox.Show("确认要继续办理迁出吗？本业务将不能回退!", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.No)
{
return;
}
if (checkEdit1.Checked && Math.Abs(regfee) > 0)
{
if (XtraMessageBox.Show("迁出需要补退费" + regfee.ToString("##,##0.00") + ",是否继续？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
}
if ((!string.IsNullOrEmpty(txtEdit_fee.Text)) && Convert.ToDecimal(txtEdit_fee.Text) > 0 && Envior.cur_userId != AppInfo.ROOTID && !isrefund)
{
XtraMessageBox.Show("当前记录已经欠费,不能迁出!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
int re = RegisterAction.RegisterOut(rc001,
s_oc003,
s_oc004,
s_oc005,
diff,
fa001,
price,
isrefund ? 0 - nums : nums,
isrefund ? 0 - Math.Abs(regfee) : Math.Abs(regfee),
Envior.cur_userId
);
if (re > 0)
{
//保存迁出人信息
if (IDC_FLAG)
{
ic01_dao.Insert(ic01);
///更新身份证照片
if (ic01 != null)
{
FileStream file = new FileStream("zp.bmp", FileMode.Open, FileAccess.Read);
Byte[] imgByte = new Byte[file.Length]; //把图片转成 Byte型 二进制流
file.Read(imgByte, 0, imgByte.Length); //把二进制流读入缓冲区
file.Close();
MiscAction.Update_IDC_Photo(ic01.ic001, imgByte);
}
}
XtraMessageBox.Show("迁出办理成功!现在打印【迁出通知单】", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
PrtServAction.PrtRegisterOutNotice(rc001, this.Handle.ToInt32());
if (!isrefund && nums > 0)
{
if (XtraMessageBox.Show("现在开具【发票】吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
if (FinInvoice.GetCurrentPh() > 0)
{
if (XtraMessageBox.Show("下一张财政发票号码:" + Envior.FIN_NEXT_BILL_NO + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
FinInvoice.Invoice(fa001);
}
}
}
}
else if (isrefund && Math.Abs(nums) > 0) //退费发票
{
//如果是新版接口上线前开具的原发票
if (MiscAction.FinRefundBeforeOnline(fa001))
{
XtraMessageBox.Show("原发票在财政新接口上线前开具,不能开具对应退费发票,请在财政发票系统内完成发票开具.\r\n 开具成功后请更新发票号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else if (FinInvoice.GetCurrentPh() > 0)
{
if (XtraMessageBox.Show("下一张财政发票号码:" + Envior.FIN_NEXT_BILL_NO + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
FinInvoice.Refund(fa001);
}
}
}
}
DialogResult = DialogResult.OK;
this.Close();
}
private void simpleButton20_Click(object sender, EventArgs e)
{
FinInvoice.PrintInvoice("3910", "00356018");
}
/// <summary>
/// 参数初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void simpleButton21_Click(object sender, EventArgs e)
{
//int result = FinInvoice.initDll(Envior.FIN_URL, Envior.FIN_APPID, Envior.FIN_APPKEY);
//XtraMessageBox.Show(result.ToString(),"结果");
FinInvoice.PrintInvoice("1", "2");
}
private void b_ok_Click(object sender, EventArgs e)
{
if (!gridView1.PostEditor())
{
return;
}
if (!gridView1.UpdateCurrentRow())
{
return;
}
if (!SaveCheck())
{
return; //数据合法性校验!!!
}
if (source == "1")
{
ac001 = Tools.GetEntityPK("RC01"); //逝者编号
}
string s_fa001 = source == "0"? string.Empty : Tools.GetEntityPK("FA01"); //结算流水号
string s_rc109 = RegisterAction.GenRegisterNo("0"); //正常登记寄存证号
string s_rc002 = rg_rc002.EditValue.ToString(); //性别
string s_rc202 = rg_rc202.EditValue.ToString(); //性别2
string s_rc003 = txtEdit_rc003.Text; //逝者姓名
string s_rc303 = txtEdit_rc303.Text; //逝者姓名2
int rc004 = int.Parse(txtEdit_rc004.Text); //年龄
int rc404;
if (!string.IsNullOrEmpty(txtEdit_rc404.Text))
{
rc404 = int.Parse(txtEdit_rc404.Text);
}
else
{
rc404 = 0;
}
string s_rc014 = txtedit_rc014.Text; //身份证号
string s_rc050 = txtEdit_rc050.Text; //联系人
string s_rc051 = txtEdit_rc051.Text; //联系电话
string s_rc052 = lookUp_rc052.EditValue.ToString(); //与逝者关系
string s_rc055 = txtEdit_ac055.Text; //联系地址
string s_rc099 = mem_rc099.Text; //备注
DateTime d_rc140 = DateTime.Now; //寄存日期
decimal nums = decimal.Parse(comboBox1.Text); //缴费年限
decimal dec_tax_sum = new decimal(0);
//输入交款人信息
string s_cuname = s_rc003;
List <string> itemId_List = new List <string>();
List <decimal> itemPrice_List = new List <decimal>();
List <int> itemNums_List = new List <int>();
if (fpfee > 0)
{
foreach (DataRow r in register_ds.Sa01.Rows)
{
itemId_List.Add(r["SA004"].ToString());
itemPrice_List.Add(Convert.ToDecimal(r["PRICE"]));
itemNums_List.Add(Convert.ToInt32(r["NUMS"]));
//计算税票项目金额
if (MiscAction.GetItemInvoiceType(r["SA004"].ToString()) == "T")
{
dec_tax_sum += Convert.ToDecimal(r["SA007"]);
}
}
}
string s_tip = string.Empty;
if (dec_tax_sum > 0)
{
s_tip = "本次结算共需要一张财政发票和一张税务发票,是否继续?";
}
else
{
s_tip = "本次结算共需要一张财政发票,是否继续?";
}
if (source == "1") //外来寄存
{
if (XtraMessageBox.Show(s_tip, "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
if (dec_tax_sum > 0 && !TaxInvoice.ClientIsOnline())
{
if (XtraMessageBox.Show("【税神通】客户端不在线!是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
}
}
int re = 0;
if (fpfee > 0)
{
re = RegisterAction.RegisterEnroll(ac001,
s_rc109,
s_fa001,
s_rc002,
s_rc202,
s_rc003,
s_rc303,
rc004,
rc404,
s_rc014,
s_rc050,
s_rc051,
s_rc052,
s_rc055,
s_rc099,
bitId,
bitPrice,
d_rc140,
d_rc140,
nums,
regfee,
source,
itemId_List.ToArray(),
itemPrice_List.ToArray(),
itemNums_List.ToArray(),
Envior.cur_userId
);
}
else
{
re = RegisterAction.RegisterEnroll(ac001,
s_rc109,
s_fa001,
s_rc002,
s_rc202,
s_rc003,
s_rc303,
rc004,
rc404,
s_rc014,
s_rc050,
s_rc051,
s_rc052,
s_rc055,
s_rc099,
bitId,
bitPrice,
d_rc140,
d_rc140,
nums,
regfee,
source,
Envior.cur_userId
);
}
if (IDC_FLAG)
{
ic01.ac001 = ac001;
ic01_dao.Insert(ic01);
///更新身份证照片
FileStream file = new FileStream("zp.bmp", FileMode.Open, FileAccess.Read);
Byte[] imgByte = new Byte[file.Length]; //把图片转成 Byte型 二进制流
file.Read(imgByte, 0, imgByte.Length); //把二进制流读入缓冲区
file.Close();
MiscAction.Update_IDC_Photo(ic01.ic001, imgByte);
}
if (re > 0 && source == "0")
{
XtraMessageBox.Show("寄存办理成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
DialogResult = DialogResult.OK;
this.Close();
}
else if (re > 0 && source == "1" /* 外来寄存 */)
{
if (XtraMessageBox.Show("现在打印【骨灰寄存证】吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
{
PrtServAction.PrtRegisterCert(ac001, s_fa001, Envior.mform.Handle.ToInt32());
}
//if (XtraMessageBox.Show("现在打印【寄存标签】吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) == DialogResult.Yes)
//{
// PrtServAction.PrtRegisterLabel(ac001,this.Handle.ToInt32());
//}
txtEdit_rc001.EditValue = ac001;
txtEdit_rc109.EditValue = s_rc109;
XtraMessageBox.Show("寄存登记成功!现在开始开具发票!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
///开财政票
if (FinInvoice.GetCurrentPh() > 0)
{
if (XtraMessageBox.Show("下一张财政发票号码:" + Envior.FIN_NEXT_BILL_NO + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
FinInvoice.Invoice(s_fa001);
}
}
//// 开税票
if (dec_tax_sum > 0)
{
//获取税务客户信息
Frm_TaxClientInfo frm_taxClient = new Frm_TaxClientInfo(s_rc003);
if (frm_taxClient.ShowDialog() == DialogResult.OK)
{
TaxClientInfo clientInfo = frm_taxClient.swapdata["taxclientinfo"] as TaxClientInfo;
if (TaxInvoice.GetNextInvoiceNo(s_fa001) > 0)
{
if (XtraMessageBox.Show("下一张税票代码:" + Envior.NEXT_BILL_CODE + "\r\n" + "票号:" + Envior.NEXT_BILL_NUM + ",是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
TaxInvoice.Invoice(s_fa001, clientInfo);
}
}
}
}
DialogResult = DialogResult.OK;
this.Close();
}
}
/// <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);
}
}
