/// <summary>
/// 调整寄存日期
/// </summary>
/// <param name="rc001"></param>
/// <param name="rc020"></param>
/// <param name="rc022"></param>
/// <returns></returns>
public static int AdjustRegisterDate(string rc001, DateTime rc020, DateTime rc022)
{
//逝者编号
OracleParameter op_rc001 = new OracleParameter("ic_rc001", OracleDbType.Varchar2, 10);
op_rc001.Direction = ParameterDirection.Input;
op_rc001.Value = rc001;
//开始时间
OracleParameter op_begin = new OracleParameter("id_begin", OracleDbType.Date);
op_begin.Direction = ParameterDirection.Input;
op_begin.Value = rc020;
//结束日期
OracleParameter op_end = new OracleParameter("id_end", OracleDbType.Date);
op_end.Direction = ParameterDirection.Input;
op_end.Value = rc022;
return(SqlAssist.ExecuteProcedure("pkg_business.prc_AdjustRegisterDate", new OracleParameter[]
{ op_rc001, op_begin, op_end }));
}
/// <summary>
/// 根据墓位 号位文字描述+排序号 返回墓位编号
/// </summary>
/// <param name="rg001"></param>
/// <param name="bi003"></param>
/// <param name="rowerOrder"></param>
/// <returns></returns>
public static string GetBi001ByBitdescRowOrder(string rg001, string bi003, int rowerOrder)
{
OracleParameter op_rg001 = new OracleParameter("ic_rg001", OracleDbType.Varchar2, 10);
op_rg001.Direction = ParameterDirection.Input;
op_rg001.Value = rg001;
OracleParameter op_bi003 = new OracleParameter("ic_bi003", OracleDbType.Varchar2, 50);
op_bi003.Direction = ParameterDirection.Input;
op_bi003.Value = bi003;
OracleParameter op_order = new OracleParameter("in_roworder", OracleDbType.Int32);
op_order.Direction = ParameterDirection.Input;
op_order.Value = rowerOrder;
Object re = SqlAssist.ExecuteFunction("pkg_business.fun_GetBi001ByBitdescRowOrder", new OracleParameter[] { op_rg001, op_bi003, op_order });
return(re.ToString());
}
/// <summary>
/// 连接打印服务
/// </summary>
private void ConnectPrtServ()
{
IntPtr hwnd = FindWindow(null, "prtserv");
if (hwnd != IntPtr.Zero)
{
Envior.prtservHandle = hwnd;
int prtConnId = int.Parse(SqlAssist.ExecuteScalar("select seq_prtserv.nextval from dual", null).ToString());
////建立连接
PrtServAction.Connect(prtConnId, hwnd.ToInt32(), this.Handle.ToInt32());
Envior.prtConnId = prtConnId;
////给打印服务窗口发消息 建立连接
SendMessage(hwnd, 0x2710, 0, prtConnId);
}
else
{
MessageBox.Show("没有找到打印服务进程,不能打印!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
public static int ManageFee(string fa001, string ac001, decimal price, decimal nums, string handler, string ws001)
{
//结算流水号
OracleParameter op_fa001 = new OracleParameter("ic_fa001", OracleDbType.Varchar2, 10);
op_fa001.Direction = ParameterDirection.Input;
op_fa001.Value = fa001;
//购墓流水号
OracleParameter op_ac001 = new OracleParameter("ic_ac001", OracleDbType.Varchar2, 10);
op_ac001.Direction = ParameterDirection.Input;
op_ac001.Value = ac001;
//单价
OracleParameter op_price = new OracleParameter("in_price", OracleDbType.Decimal);
op_price.Direction = ParameterDirection.Input;
op_price.Value = price;
//年限
OracleParameter op_nums = new OracleParameter("in_nums", OracleDbType.Decimal);
op_nums.Direction = ParameterDirection.Input;
op_nums.Value = nums;
//经办人
OracleParameter op_pr100 = new OracleParameter("ic_pr100", OracleDbType.Varchar2, 10);
op_pr100.Direction = ParameterDirection.Input;
op_pr100.Value = handler;
//工作站编号
OracleParameter op_ws001 = new OracleParameter("ic_ws001", OracleDbType.Varchar2, 10);
op_ws001.Direction = ParameterDirection.Input;
op_ws001.Value = ws001;
return(SqlAssist.ExecuteProcedure("pkg_business.prc_ManageFee", new OracleParameter[] { op_fa001, op_ac001, op_price, op_nums, op_pr100, op_ws001 }));
}
///// <summary>
///// 发票开具
///// </summary>
///// <param name="invdata"></param>
///// <param name="ifprt"></param>
///// <param name="pjlx"></param>
///// <param name="bz"></param>
///// <returns></returns>
//public static string Invoice(string invdata,int ifprt,string pjlx,string bz)
//{
// StringBuilder sb_res = new StringBuilder();
// try
// {
// PZrPj(invdata, ifprt, pjlx, bz, sb_res);
// }
// catch (Exception ee)
// {
// XtraMessageBox.Show(ee.ToString(),"错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
// }
// return sb_res.ToString();
//}
///// <summary>
///// 作废财政发票
///// </summary>
///// <param name="pjh"></param>
///// <returns></returns>
//public static string Remove(string pjh)
//{
// StringBuilder sb_res = new StringBuilder();
// PDelPj(pjh, sb_res);
// return sb_res.ToString();
//}
///// <summary>
///// 作废财政发票
///// </summary>
///// <param name="zch"></param>
///// <param name="pjlx"></param>
///// <param name="pjh"></param>
///// <returns></returns>
//public static int Remove(string zch,string pjlx,string pjh)
//{
// string s_content = "票据类型=" + pjlx + "|票据号=" + pjh + "|注册号=" + zch;
// //MessageBox.Show(s_content);
// string retstr = Remove(s_content);
// if (retstr.IndexOf("成功") >= 0)
// {
// XtraMessageBox.Show("作废财政发票成功!\r\n" + "票据类型:" + pjlx + ",票据号:" + pjh + ",注册号:" + zch, "提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
// return 1;
// }
// else
// {
// LogUtils.Error("作废财政发票失败:\r\n" + "票据号:" + pjh + "注册号:" + zch + "\r\n" + "返回字符串:" + retstr);
// XtraMessageBox.Show("作废财政发票失败!请与管理员联系!\r\n" + retstr,"提示",MessageBoxButtons.OK,MessageBoxIcon.Error);
// return -1;
// }
//}
///// <summary>
///// 退费
///// </summary>
///// <param name="OldPjlx"></param>
///// <param name="OldPjh"></param>
///// <param name="OldZch"></param>
///// <param name="NewPjlx"></param>
///// <param name="tkitem"></param>
///// <param name="aQt"></param>
///// <param name="res"></param>
///// <returns></returns>
//public static int Refund(string OldPjlx,string OldPjh,string OldZch,string tkitem,string aQt,string fa001,string NewPjh,decimal hjje)
//{
// StringBuilder sb_res = new StringBuilder();
// PZrTkkp(OldPjh,OldPjlx, OldZch, Envior.FIN_INVOICE_TYPE, tkitem, aQt, sb_res);
// if (sb_res.ToString().IndexOf("成功") >= 0) //退费发票开具成功
// {
// if (FinInvoiceLog(fa001, Envior.FIN_INVOICE_TYPE, NewPjh, "", 0 - Math.Abs(hjje),Envior.cur_userId) > 0)
// {
// XtraMessageBox.Show("发票开具成功!\r\n" + "发票类型:" + Envior.FIN_INVOICE_TYPE + "\r\n" + "发票号:" + NewPjh, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
// return 1;
// }
// else
// {
// XtraMessageBox.Show("发票开具成功!但记录日志失败，请与管理员联系！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// return 1;
// }
// }
// else
// {
// XtraMessageBox.Show("发票开具失败!\r\n" + sb_res.ToString(),"错误",MessageBoxButtons.OK,MessageBoxIcon.Error);
// return -1;
// }
//}
///// <summary>
///// 根据结算流水号开具发票
///// </summary>
///// <param name="fa001"></param>
///// <returns></returns>
//public static int Invoice(string fa001)
//{
// OracleParameter op_fa001 = new OracleParameter("fa001", OracleDbType.Varchar2, 10);
// op_fa001.Direction = ParameterDirection.Input;
// op_fa001.Value = fa001;
// OracleDataReader reader_fa01 = SqlAssist.ExecuteReader("select fa003,fa180 from fa01 where fa001 = :fa001",new OracleParameter[] { op_fa001});
// string s_head = string.Empty;
// string s_memo = string.Empty; //备注
// decimal dec_hjje = decimal.Zero;
// while (reader_fa01.Read())
// {
// //读取交款人
// s_head = Envior.FIN_INVOICE_TITLE + "=" + reader_fa01["FA003"].ToString() + " ";
// s_memo = reader_fa01["FA180"].ToString();
// }
// reader_fa01.Dispose();
// string s_sql = @"select sa002,
// sa004,
// sa003,
// price,
// nums,
// sa020,
// sa007,
// pkg_business.fun_GetInvoiceCode(sa002,sa004) invcode
// from v_sa01
// where sa010 = :fa001 order by sa001";
// OracleDataReader reader_sa01 = SqlAssist.ExecuteReader(s_sql,new OracleParameter[] { op_fa001});
// StringBuilder sb_detail = new StringBuilder(100);
// while (reader_sa01.Read())
// {
// if (reader_sa01["SA020"].ToString() != "F") continue; //如果不是财政发票,忽略
// sb_detail.Append("收费项目=" + reader_sa01["INVCODE"].ToString() + " " + "计费数量=" + reader_sa01["NUMS"].ToString() + " " + "收费标准=" + reader_sa01["PRICE"].ToString() + " " + "金额=" + reader_sa01["SA007"].ToString() + " ");
// dec_hjje += Convert.ToDecimal(reader_sa01["SA007"]);
// }
// reader_sa01.Dispose();
// string vContent = "<&票据><&票据头>" + s_head + " " + "</&票据头>" + "<&收费项目>" + sb_detail.ToString() + "</&收费项目></&票据>";
// string retstr = Invoice(vContent, 1,Envior.FIN_INVOICE_TYPE, s_memo);
// if(retstr.IndexOf("成功") >= 0)
// {
// //TODO 4. 记录财政发票日志
// string s_info = retstr.Substring(3);
// string[] s_arry = s_info.Split(',');
// if(s_arry.Length >= 4)
// {
// string s_pjlx = s_arry[0]; //票据类型
// string s_pjh = s_arry[1]; //发票号
// string s_zch = s_arry[3]; //注册号
// if(FinInvoiceLog(fa001,s_pjlx,s_pjh,s_zch,dec_hjje,Envior.cur_userId) > 0)
// {
// XtraMessageBox.Show("发票开具成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
// return 1;
// }
// else
// {
// XtraMessageBox.Show("发票开具成功!!!但记录日志失败，请与管理员联系！","提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
// XtraMessageBox.Show("票据类型:" + s_pjlx + "\r\n" + "票据号:" + s_pjh + "\r\n注册号:" + s_zch + "\r\n");
// return 1;
// }
// }
// else
// {
// XtraMessageBox.Show("发票开具成功!但记录日志出现错误，请与管理员联系!！\r\n" + retstr + "数组大小:" + s_arry.Length.ToString(), "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// return 1;
// }
// }
// else
// {
// XtraMessageBox.Show("发票开具失败!\r\n" + retstr,"提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
// return -1;
// }
//}
/// <summary>
/// 财政发票开票日志
/// </summary>
/// <param name="fa001">结算流水号</param>
/// <param name="fplx">发票类型</param>
/// <param name="fph">发票号</param>
/// <param name="zch">注册号</param>
/// <returns></returns>
public static int FinInvoiceLog(string fa001, string fplx, string fph, string zch, decimal hjje, string kpr)
{
//逝者编号
OracleParameter op_fa001 = new OracleParameter("ic_fa001", OracleDbType.Varchar2, 10);
op_fa001.Direction = ParameterDirection.Input;
op_fa001.Value = fa001;
//票据类型
OracleParameter op_pjlx = new OracleParameter("ic_billCode", OracleDbType.Varchar2, 10);
op_pjlx.Direction = ParameterDirection.Input;
op_pjlx.Value = fplx;
//票号
OracleParameter op_fph = new OracleParameter("ic_billNo", OracleDbType.Varchar2, 10);
op_fph.Direction = ParameterDirection.Input;
op_fph.Value = fph;
//注册号
OracleParameter op_zch = new OracleParameter("ic_zch", OracleDbType.Varchar2, 10);
op_zch.Direction = ParameterDirection.Input;
op_zch.Value = zch;
//合计金额
OracleParameter op_hjje = new OracleParameter("in_hjje", OracleDbType.Decimal);
op_hjje.Direction = ParameterDirection.Input;
op_hjje.Value = hjje;
//开票人
OracleParameter op_kpr = new OracleParameter("ic_kpr", OracleDbType.Varchar2, 10);
op_kpr.Direction = ParameterDirection.Input;
op_kpr.Value = kpr;
return(SqlAssist.ExecuteProcedure("pkg_business.prc_FinInvoiceLog",
new OracleParameter[] { op_fa001, op_pjlx, op_fph, op_zch, op_hjje, op_kpr }));
}
/// <summary>
/// 购墓时必选项目
/// </summary>
private void AutoAdd()
{
using (OracleDataReader reader = SqlAssist.ExecuteReader("select * from v_all_validitem where autochoose = '1' "))
{
SA01 sa01 = null;
if (reader.HasRows)
{
while (reader.Read())
{
sa01 = new SA01(unitOfWork1);
sa01.SA004 = reader["ITEM_ID"].ToString();
sa01.SA001 = MiscAction.GetEntityPK("SA01");
sa01.SA002 = '1'; //销售项目类型 1 - 商品或服务
sa01.SA003 = reader["ITEM_NAME"].ToString(); //项目名称
sa01.STATUS = '1';
sa01.AC001 = s_ac001; //购墓流水号
sa01.SA005 = '0'; //销售类型 0-购墓
sa01.SA008 = '0'; //结算标志 0-未结算
sa01.SA100 = Envior.cur_userId; //经办人
sa01.SA200 = Tools.GetServerDate(); //经办日期
sa01.SA025 = Convert.ToDecimal(reader["TAXRATE"]);
if (sa01.SA003 == "管理费")
{
sa01.NUMS = MiscAction.GetSysParaValue1("MANAGEFEE_NUMS");
}
else
{
sa01.NUMS = 1;
}
sa01.PRICE = Convert.ToDecimal(reader["PRICE"]);//单价
sa01.SA007 = sa01.PRICE * sa01.NUMS;
sa01.SA006 = sa01.PRICE;
xpCollection_sa01.Add(sa01);
}
}
}
}
/// <summary>
/// 税务发票打印日志
/// </summary>
/// <param name="fa001"></param>
/// <param name="inv_code"></param>
/// <param name="inv_num"></param>
/// <returns></returns>
public static int Tax_Log(string fa001, string inv_code, string inv_num)
{
//结算流水号
OracleParameter op_fa001 = new OracleParameter("ic_fa001", OracleDbType.Varchar2, 10);
op_fa001.Direction = ParameterDirection.Input;
op_fa001.Value = fa001;
//发票代码
OracleParameter op_inv_code = new OracleParameter("ic_inv_code", OracleDbType.Varchar2, 50);
op_inv_code.Direction = ParameterDirection.Input;
op_inv_code.Value = inv_code;
//发票号码
OracleParameter op_inv_num = new OracleParameter("ic_inv_num", OracleDbType.Varchar2, 50);
op_inv_num.Direction = ParameterDirection.Input;
op_inv_num.Value = inv_num;
return(SqlAssist.ExecuteProcedure("pkg_business.prc_Tax_log", new OracleParameter[] { op_fa001, op_inv_code, op_inv_num }));
}
/// <summary>
/// 收费作废
/// </summary>
/// <param name="fa001"></param>
/// <param name="reason"></param>
/// <param name="handler"></param>
/// <returns></returns>
public static int FinanceRemove(string fa001, string reason, string handler)
{
//结算流水号
OracleParameter op_fa001 = new OracleParameter("ic_fa001", OracleDbType.Varchar2, 10);
op_fa001.Direction = ParameterDirection.Input;
op_fa001.Value = fa001;
//作废原因
OracleParameter op_reason = new OracleParameter("ic_reason", OracleDbType.Varchar2, 100);
op_reason.Direction = ParameterDirection.Input;
op_reason.Value = reason;
//经办人
OracleParameter op_handler = new OracleParameter("ic_handler", OracleDbType.Varchar2, 10);
op_handler.Direction = ParameterDirection.Input;
op_handler.Value = handler;
return(SqlAssist.ExecuteProcedure("pkg_business.prc_FinanceRemove", new OracleParameter[] { op_fa001, op_reason, op_handler }));
}
/// <summary>
/// 收款员统计
/// </summary>
/// <param name="s_begin"></param>
/// <param name="s_end"></param>
/// <returns></returns>
public static int CashierStat(string uc001, string s_begin, string s_end)
{
//收款员
OracleParameter op_uc001 = new OracleParameter("ic_uc001", OracleDbType.Varchar2, 10);
op_uc001.Direction = ParameterDirection.Input;
op_uc001.Value = uc001;
//统计起始日期
OracleParameter op_begin = new OracleParameter("ic_begin", OracleDbType.Varchar2, 10);
op_begin.Direction = ParameterDirection.Input;
op_begin.Value = s_begin;
//统计终止日期
OracleParameter op_end = new OracleParameter("ic_end", OracleDbType.Varchar2, 10);
op_end.Direction = ParameterDirection.Input;
op_end.Value = s_end;
return(SqlAssist.ExecuteProcedure("pkg_report.prc_cashier_stat", new OracleParameter[] { op_uc001, op_begin, op_end }));
}
/// <summary>
/// 打印税票清单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItem9_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
string s_fa001 = string.Empty;
int rowHandle;
if (tabPane1.SelectedPageIndex == 0)
{
rowHandle = gridView1.FocusedRowHandle;
if (gridView1.GetRowCellValue(rowHandle, "FA190").ToString().Substring(1, 1) == "0")
{
XtraMessageBox.Show("当前收费记录未开具税务发票!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
s_fa001 = gridView1.GetRowCellValue(rowHandle, "FA001").ToString();
}
else if (tabPane1.SelectedPageIndex == 1)
{
rowHandle = gridView3.FocusedRowHandle;
if (gridView3.GetRowCellValue(rowHandle, "BILLTYPE").ToString() == "F")
{
XtraMessageBox.Show("当前发票为财政发票!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
s_fa001 = gridView3.GetRowCellValue(rowHandle, "FA001").ToString();
}
OracleDataReader reader = SqlAssist.ExecuteReader("select * from tax_log where settleId='" + s_fa001 + "'");
{
reader.Read();
string s_fpdm = reader["INVOICECODE"].ToString();
string s_fphm = reader["INVOICENUM"].ToString();
if (XtraMessageBox.Show("发票代码:" + s_fpdm + "\r\n" + "发票号码:" + s_fphm + "\r\n是否继续?", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
TaxInvoice.PrintInvoice(s_fa001, "1");
}
}
reader.Dispose();
}
/// <summary>
/// 弃墓处理
/// </summary>
/// <param name="ac001"></param>
/// <param name="reason"></param>
/// <param name="handler"></param>
/// <returns></returns>
public static int TombQuit(string ac001, string reason, string handler)
{
//购墓流水号
OracleParameter op_ac001 = new OracleParameter("ic_ac001", OracleDbType.Varchar2, 10);
op_ac001.Direction = ParameterDirection.Input;
op_ac001.Value = ac001;
//调整原因
OracleParameter op_reason = new OracleParameter("ic_reason", OracleDbType.Varchar2, 100);
op_reason.Direction = ParameterDirection.Input;
op_reason.Value = reason;
//经办人
OracleParameter op_handler = new OracleParameter("ic_handler", OracleDbType.Varchar2, 10);
op_handler.Direction = ParameterDirection.Input;
op_handler.Value = handler;
return(SqlAssist.ExecuteProcedure("pkg_business.prc_tombQuit", new OracleParameter[] { op_ac001, op_reason, op_handler }));
}
/// <summary>
/// 打印发票
/// </summary>
/// <param name="fa001"></param>
/// <returns></returns>
public static int PrintInvoice(string fp001, string dylx)
{
string s_fphm = string.Empty;
OracleParameter op_fp001 = new OracleParameter("fp001", OracleDbType.Varchar2, 10);
op_fp001.Direction = ParameterDirection.Input;
op_fp001.Value = fp001;
OracleDataReader reader = SqlAssist.ExecuteReader("select * from fp01 where fp001 = :fp001", new OracleParameter[] { op_fp001 });
reader.Read();
if (reader.HasRows)
{
//查询发票代码和发票号码
string s_fpdm = reader["INVOICECODE"].ToString();
s_fphm = reader["INVOICENUM"].ToString();
return(PrintInvoice(s_fpdm, s_fphm, dylx));
}
else
{
XtraMessageBox.Show("未找到开票记录!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(-1);
}
}
/// <summary>
/// 应用用户套餐
/// </summary>
/// <param name="ac001"></param>
/// <param name="cb001"></param>
/// <param name="handler"></param>
/// <returns></returns>
public static int FireApplyUserCombo(string ac001, string cb001, string handler)
{
//逝者编号
OracleParameter op_ac001 = new OracleParameter("ic_ac001", OracleDbType.Varchar2, 10);
op_ac001.Direction = ParameterDirection.Input;
op_ac001.Value = ac001;
//套餐编号
OracleParameter op_cb001 = new OracleParameter("ic_cb001", OracleDbType.Varchar2, 10);
op_cb001.Direction = ParameterDirection.Input;
op_cb001.Value = cb001;
//经办人
OracleParameter op_handler = new OracleParameter("ic_handler", OracleDbType.Varchar2, 10);
op_handler.Direction = ParameterDirection.Input;
op_handler.Value = handler;
return(SqlAssist.ExecuteProcedure("pkg_business.prc_ApplyUserCombo",
new OracleParameter[] { op_ac001, op_cb001, op_handler }));
}
/// <summary>
/// 灵车办理
/// </summary>
/// <param name="ac001"></param>
/// <param name="si001"></param>
/// <param name="handler"></param>
/// <returns></returns>
public static int FireSales_07(string ac001, string si001, string handler)
{
//逝者编号
OracleParameter op_ac001 = new OracleParameter("ic_ac001", OracleDbType.Varchar2, 10);
op_ac001.Direction = ParameterDirection.Input;
op_ac001.Value = ac001;
//告别厅编号
OracleParameter op_si001 = new OracleParameter("ic_si001", OracleDbType.Varchar2, 10);
op_si001.Direction = ParameterDirection.Input;
op_si001.Value = si001;
//经办人
OracleParameter op_handler = new OracleParameter("ic_handler", OracleDbType.Varchar2, 10);
op_handler.Direction = ParameterDirection.Input;
op_handler.Value = handler;
return(SqlAssist.ExecuteProcedure("pkg_business.prc_FireBusiness07",
new OracleParameter[] { op_ac001, op_si001, op_handler }));
}
/// <summary>
/// 主窗体关闭
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Frm_main_FormClosed(object sender, FormClosedEventArgs e)
{
//销毁业务对象表
dt_bo01.Dispose();
//断开数据库
SqlAssist.DisConnect();
//关闭关联的打印进程
if (!printprocess.HasExited)
{
printprocess.Kill();
}
//保存皮肤
//Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
//if (string.IsNullOrEmpty(skinRibbonGalleryBarItem1.Gallery.GetCheckedItems()[0].Caption))
// config.AppSettings.Settings["skinname"].Value = "LiLian";
//else
// config.AppSettings.Settings["skinname"].Value = skinRibbonGalleryBarItem1.Gallery.GetCheckedItems()[0].Caption;
//config.Save(ConfigurationSaveMode.Modified);
}
/// <summary>
/// 工作站统计
/// </summary>
/// <param name="ws001"></param>
/// <param name="dbegin"></param>
/// <param name="dend"></param>
/// <returns></returns>
public static int WorkStationStat(string ws001, string dbegin, string dend)
{
//工作站编号
OracleParameter op_ws001 = new OracleParameter("ic_ws001", OracleDbType.Varchar2, 10);
op_ws001.Direction = ParameterDirection.Input;
op_ws001.Value = ws001;
//开始日期
OracleParameter op_dbegin = new OracleParameter("ic_begin", OracleDbType.Varchar2, 20);
op_dbegin.Direction = ParameterDirection.Input;
op_dbegin.Value = dbegin;
//结束日期
OracleParameter op_dend = new OracleParameter("ic_end", OracleDbType.Varchar2, 20);
op_dend.Direction = ParameterDirection.Input;
op_dend.Value = dend;
return(SqlAssist.ExecuteProcedure("pkg_report.prc_workStationStat",
new OracleParameter[] { op_ws001, op_dbegin, op_dend }));
}
/// <summary>
/// 税务发票作废日志
/// </summary>
/// <param name="fa001"></param>
/// <param name="zfr"></param>
/// <param name="reason"></param>
/// <returns></returns>
public static int TaxRemove_log(string fa001, string zfr, string reason)
{
//结算流水号
OracleParameter op_fa001 = new OracleParameter("ic_fa001", OracleDbType.Varchar2, 10);
op_fa001.Direction = ParameterDirection.Input;
op_fa001.Value = fa001;
//作废人
OracleParameter op_zfr = new OracleParameter("ic_zfr", OracleDbType.Varchar2, 50);
op_zfr.Direction = ParameterDirection.Input;
op_zfr.Value = zfr;
//作废原因
OracleParameter op_reason = new OracleParameter("ic_reason", OracleDbType.Varchar2, 100);
op_reason.Direction = ParameterDirection.Input;
op_reason.Value = reason;
return(SqlAssist.ExecuteProcedure("pkg_business.prc_TaxRemove_log",
new OracleParameter[] { op_fa001, op_zfr, op_reason }));
}
/// <summary>
/// 收款员收款统计
/// </summary>
/// <param name="dbegin"></param>
/// <param name="dend"></param>
/// <param name="handler"></param>
/// <returns></returns>
public static int CasherStat(string dbegin, string dend, string handler)
{
//开始日期
OracleParameter op_dbegin = new OracleParameter("ic_begin", OracleDbType.Varchar2, 20);
op_dbegin.Direction = ParameterDirection.Input;
op_dbegin.Value = dbegin;
//结束日期
OracleParameter op_dend = new OracleParameter("ic_end", OracleDbType.Varchar2, 20);
op_dend.Direction = ParameterDirection.Input;
op_dend.Value = dend;
//收款人
OracleParameter op_handler = new OracleParameter("ic_handler", OracleDbType.Varchar2, 10);
op_handler.Direction = ParameterDirection.Input;
op_handler.Value = handler;
return(SqlAssist.ExecuteProcedure("pkg_report.prc_CasherStat",
new OracleParameter[] { op_dbegin, op_dend, op_handler }));
}
/// <summary>
/// 打印发票清单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void barButtonItem30_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
int rowHandle = gridView1.FocusedRowHandle;
int papers = 0;
string s_fa001 = string.Empty;
if (rowHandle >= 0)
{
s_fa001 = gridView1.GetRowCellValue(rowHandle, "FA001").ToString();
papers = BusinessAction.GetHaveInvoicePapers(s_fa001);
if (papers == 0)
{
Tools.msg(MessageBoxIcon.Exclamation, "提示", "此收费记录尚未开具发票!");
return;
}
else if (papers == 1) //一张发票
{
using (OracleDataReader reader = SqlAssist.ExecuteReader("select * from fp01 where fa001='" + s_fa001 + "' and flag = '1' and rownum < 2"))
{
reader.Read();
string s_fpdm = reader["INVOICECODE"].ToString();
string s_fphm = reader["INVOICENUM"].ToString();
if (XtraMessageBox.Show("发票代码:" + s_fpdm + "\r\n" + "发票号码:" + s_fphm + "\r\n是否继续?", "确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
TaxInvoice.PrintInvoice(s_fpdm, s_fphm, "1");
}
}
}
else if (papers > 1) //多张发票
{
Frm_InvoiceDisplay frm_1 = new Frm_InvoiceDisplay();
frm_1.swapdata["fa001"] = s_fa001;
frm_1.ShowDialog();
frm_1.Dispose();
}
}
}
/// <summary>
/// 续交寄存费
/// </summary>
/// <param name="rc001"></param>
/// <param name="fa001"></param>
/// <param name="price"></param>
/// <param name="nums"></param>
/// <param name="handler"></param>
/// <returns></returns>
public static int RegisterPay(string rc001, string fa001, decimal price, decimal nums, string handler)
{
//逝者编号
OracleParameter op_rc001 = new OracleParameter("ic_rc001", OracleDbType.Varchar2, 10);
op_rc001.Direction = ParameterDirection.Input;
op_rc001.Value = rc001;
//结算流水号
OracleParameter op_fa001 = new OracleParameter("ic_fa001", OracleDbType.Varchar2, 10);
op_fa001.Direction = ParameterDirection.Input;
op_fa001.Value = fa001;
//单价
OracleParameter op_price = new OracleParameter("in_price", OracleDbType.Decimal);
op_price.Direction = ParameterDirection.Input;
op_price.Value = price;
//缴费年限
OracleParameter op_nums = new OracleParameter("in_nums", OracleDbType.Decimal);
op_nums.Direction = ParameterDirection.Input;
op_nums.Value = nums;
//经办人
OracleParameter op_handler = new OracleParameter("ic_handler", OracleDbType.Varchar2, 10);
op_handler.Direction = ParameterDirection.Input;
op_handler.Value = handler;
return(SqlAssist.ExecuteProcedure("pkg_business.prc_RegisterPay", new OracleParameter[]
{ op_rc001, op_fa001, op_price, op_nums, op_handler }));
}
/// <summary>
/// 业务初始化
/// </summary>
public override void Business_Init()
{
//获取逝者编号
AC001 = this.swapdata["parm"].ToString();
//填充逝者个人信息
parm1.Value = AC001;
parm2.Value = AC001;
reader = SqlAssist.ExecuteReader("select * from v_ac01 where ac001 = :ac001", new OracleParameter[] { parm2 });
if (!reader.HasRows)
{
XtraMessageBox.Show("参数传递错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
reader.Read();
txtedit_ac001.EditValue = AC001;
txtedit_ac003.EditValue = reader["AC003"]; //逝者姓名
txtedit_ac004.EditValue = reader["AC004"]; //年龄
rg_ac002.EditValue = reader["AC002"]; //性别
txtedit_ac020.EditValue = reader["AC020"]; //到达中心时间
txtedit_ac050.EditValue = reader["AC050"]; //联系人
txtedit_ac051.EditValue = reader["AC051"]; //电话
txtedit_ac052.Text = reader["AC052"].ToString(); //与逝者关系
this.Parent.Text = "火化业务办理" + "【" + reader["AC003"] + "】";
reader.Dispose();
///刷新销售数据
this.RefreshSalesData();
}
public static int TaxReLog(string fa001, string fpdm, string fph)
{
//结算流水号
OracleParameter op_fa001 = new OracleParameter("ic_fa001", OracleDbType.Varchar2, 10);
op_fa001.Direction = ParameterDirection.Input;
op_fa001.Value = fa001;
//发票代码
OracleParameter op_fpdm = new OracleParameter("ic_fpdm", OracleDbType.Varchar2, 20);
op_fpdm.Direction = ParameterDirection.Input;
op_fpdm.Value = fpdm;
//发票号
OracleParameter op_fph = new OracleParameter("ic_fph", OracleDbType.Varchar2, 20);
op_fph.Direction = ParameterDirection.Input;
op_fph.Value = fph;
return(SqlAssist.ExecuteProcedure("pkg_business.prc_TaxReLog",
new OracleParameter[] { op_fa001, op_fpdm, op_fph }));
}
private void Frm_InvoiceInfo_Load(object sender, EventArgs e)
{
///设置检索参数
fa001 = this.swapdata["FA001"].ToString();
op_fa001.Direction = ParameterDirection.Input;
op_fa001.Value = fa001;
this.Text = "发票信息【流水号" + fa001 + "】";
////检索结算信息
OracleDataReader reader = SqlAssist.ExecuteReader("select * from v_financeday where fa001='" + fa001 + "'");
reader.Read();
if (reader.HasRows)
{
te_fa001.EditValue = reader["FA001"];
te_fa002.EditValue = reader["FA002_TEXT"];
te_fa003.EditValue = reader["GUYNAME"];
te_fa100.EditValue = reader["HANDLER"];
}
adapter.SelectCommand.Parameters.Add(op_fa001);
gridControl2.DataSource = dt_invoice;
adapter.Fill(dt_invoice);
}
private void b_ok_Click(object sender, EventArgs e)
{
//string s_pjlx = te_pjlx.Text;
//string s_title = te_title.Text;
//if (string.IsNullOrEmpty(s_pjlx))
//{
// te_pjlx.ErrorImageOptions.Alignment = ErrorIconAlignment.MiddleRight;
// te_pjlx.ErrorText = "票据类型不能为空!";
// return;
//}else if (string.IsNullOrEmpty(s_title))
//{
// te_title.ErrorImageOptions.Alignment = ErrorIconAlignment.MiddleRight;
// te_title.ErrorText = "题头名称不能为空!";
// return;
//}
//if (AppAction.SaveFinanceInfo(s_pjlx,s_title)> 0)
//{
// XtraMessageBox.Show("保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
// Envior.FIN_INVOICE_TYPE = s_pjlx;
// Envior.FIN_INVOICE_TITLE = s_title;
// this.Close();
//}
string s_region_code = te_region_code.Text;
string s_agency_code = te_agency_code.Text;
string s_agency_name = te_agency_name.Text;
string s_url = te_url.Text;
string s_appid = te_appid.Text;
string s_appkey = te_appkey.Text;
string s_bill_code = te_code.Text;
string s_batch_code = te_batch_code.Text;
string s_bill_name = te_bill_name.Text;
string s_version = te_version.Text;
OracleTransaction trans = null;
try
{
trans = SqlAssist.conn.BeginTransaction();
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_region_code + "' where sp001 = '0000000060' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_agency_code + "' where sp001 = '0000000062' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_agency_name + "' where sp001 = '0000000063' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_url + "' where sp001 = '0000000064' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_appid + "' where sp001 = '0000000065' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_appkey + "' where sp001 = '0000000066' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_bill_code + "' where sp001 = '0000000068' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_batch_code + "' where sp001 = '0000000067' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_bill_name + "' where sp001 = '0000000069' ");
SqlAssist.ExecuteNonQuery_NoTans("update sp01 set sp005 ='" + s_version + "' where sp001 = '0000000061' ");
Envior.FIN_REGION_CODE = s_region_code;
Envior.FIN_AGENCY_CODE = s_agency_code;
Envior.FIN_AGENCY_NAME = s_agency_name;
Envior.FIN_URL = s_url;
Envior.FIN_APPID = s_appid;
Envior.FIN_APPKEY = s_appkey;
Envior.FIN_CODE = s_bill_code;
Envior.FIN_BATCH_CODE = s_batch_code;
Envior.FIN_BILLNAME = s_bill_name;
Envior.FIN_VERSION = s_version;
trans.Commit();
XtraMessageBox.Show("保存成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ee)
{
trans.Rollback();
XtraMessageBox.Show(ee.ToString(), "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// 单元格值改变
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridView1_CellValueChanged(object sender, CellValueChangedEventArgs e)
{
if (e.Column.FieldName.ToUpper() == "SA004" && (e.Value != DBNull.Value)) //选择服务或商品
{
DataRow dr_item = SqlAssist.GetSingelRow("select * from v_all_validItem where item_id='" + e.Value + "'");
if (dr_item != null)
{
gridView1.SetRowCellValue(e.RowHandle, "SA003", dr_item["ITEM_NAME"].ToString()); //项目名称
gridView1.SetRowCellValue(e.RowHandle, "PRICE", dr_item["PRICE"]); //单价
gridView1.SetRowCellValue(e.RowHandle, "SA006", dr_item["PRICE"]); //原始单价
gridView1.SetRowCellValue(e.RowHandle, "SA025", dr_item["TAXRATE"]); //税率
//计算小计金额
decimal dec_price = decimal.Zero;
int i_nums = 0;
if (decimal.TryParse(gridView1.GetRowCellValue(e.RowHandle, "PRICE").ToString(), out dec_price))
{
i_nums = Convert.ToInt32(gridView1.GetRowCellValue(e.RowHandle, "NUMS"));
gridView1.SetRowCellValue(e.RowHandle, "SA007", i_nums * dec_price);
}
else
{
gridView1.SetRowCellValue(e.RowHandle, "SA007", 0);
}
}
}
else if (e.Column.FieldName.ToUpper() == "PRICE") //修改单价
{
decimal dec_price = decimal.Zero;
int i_nums;
if (e.Value != DBNull.Value)
{
if (decimal.TryParse(gridView1.GetRowCellValue(e.RowHandle, "PRICE").ToString(), out dec_price))
{
i_nums = Convert.ToInt32(gridView1.GetRowCellValue(e.RowHandle, "NUMS"));
gridView1.SetRowCellValue(e.RowHandle, "SA007", i_nums * dec_price);
}
else
{
gridView1.SetRowCellValue(e.RowHandle, "SA007", 0);
}
}
else
{
gridView1.SetRowCellValue(e.RowHandle, "SA007", 0);
}
}
else if (e.Column.FieldName.ToUpper() == "NUMS")
{
decimal dec_price = decimal.Zero;
int i_nums;
if (e.Value != DBNull.Value)
{
if (decimal.TryParse(gridView1.GetRowCellValue(e.RowHandle, "PRICE").ToString(), out dec_price))
{
i_nums = Convert.ToInt32(gridView1.GetRowCellValue(e.RowHandle, "NUMS"));
gridView1.SetRowCellValue(e.RowHandle, "SA007", i_nums * dec_price);
}
else
{
gridView1.SetRowCellValue(e.RowHandle, "SA007", 0);
}
}
else
{
gridView1.SetRowCellValue(e.RowHandle, "SA007", 0);
}
}
else if (e.Column.FieldName.ToUpper() == "SA007") //销售金额
{
dec_sales = 0;
for (int i = 0; i < gridView1.RowCount; i++)
{
if (i == e.RowHandle)
{
dec_sales += Convert.ToDecimal(e.Value);
}
else
{
if (gridView1.GetRowCellValue(i, "SA007") != null && gridView1.GetRowCellValue(i, "SA007") != System.DBNull.Value)
{
dec_sales += Convert.ToDecimal(gridView1.GetRowCellValue(i, "SA007"));
}
}
}
///// 如果是新行
if (e.RowHandle < 0)
{
dec_sales += Convert.ToDecimal(e.Value);
}
this.Calc_sum();
}
}
/// <summary>
/// 返回服务器时间
/// </summary>
/// <returns></returns>
public static DateTime GetServerTime()
{
return(Convert.ToDateTime(SqlAssist.ExecuteScalar("select sysdate from dual")));
}
/// <summary>
/// 返回 分类统计笔数
/// </summary>
/// <returns></returns>
public static int GetClassStat_BS()
{
return(Convert.ToInt32(SqlAssist.ExecuteScalar("select pkg_report.fun_GetClassStat_BS from dual")));
}
/// <summary>
/// 墓区结构维护后,保存墓区基本信息
/// </summary>
/// <returns></returns>
public static int UpdateTombInfo()
{
return(SqlAssist.ExecuteProcedure("pkg_business.prc_UpdateTombInfo", new OracleParameter[] { }));
}
/// <summary>
/// 保存税务发票基本信息
/// </summary>
/// <param name="url"></param>
/// <param name="id"></param>
/// <param name="appId"></param>
/// <param name="addr"></param>
/// <param name="bank"></param>
/// <param name="fplx"></param>
/// <param name="publicKey"></param>
/// <param name="privateKey"></param>
/// <param name="cashier"></param>
/// <param name="checker"></param>
/// <returns></returns>
public static int SaveTaxInfo(string url, string id, string appId, string addr, string bank, string fplx, string publicKey, string privateKey, string cashier, string checker, decimal max)
{
//服务请求url
OracleParameter op_url = new OracleParameter("ic_url", OracleDbType.Varchar2, 50);
op_url.Direction = ParameterDirection.Input;
op_url.Value = url;
//纳税识别号
OracleParameter op_id = new OracleParameter("ic_id", OracleDbType.Varchar2, 20);
op_id.Direction = ParameterDirection.Input;
op_id.Value = id;
//AppId
OracleParameter op_appId = new OracleParameter("ic_appId", OracleDbType.Varchar2, 50);
op_appId.Direction = ParameterDirection.Input;
op_appId.Value = appId;
//地址、电话
OracleParameter op_addr = new OracleParameter("ic_addr", OracleDbType.Varchar2, 100);
op_addr.Direction = ParameterDirection.Input;
op_addr.Value = addr;
//银行、账号
OracleParameter op_bank = new OracleParameter("ic_bank", OracleDbType.Varchar2, 100);
op_bank.Direction = ParameterDirection.Input;
op_bank.Value = bank;
//发票类型
OracleParameter op_fplx = new OracleParameter("ic_fplx", OracleDbType.Varchar2, 10);
op_fplx.Direction = ParameterDirection.Input;
op_fplx.Value = fplx;
//公钥
OracleParameter op_public = new OracleParameter("ic_public", OracleDbType.Varchar2, 20);
op_public.Direction = ParameterDirection.Input;
op_public.Value = publicKey;
//私钥
OracleParameter op_private = new OracleParameter("ic_private", OracleDbType.Varchar2, 20);
op_private.Direction = ParameterDirection.Input;
op_private.Value = privateKey;
//收款人
OracleParameter op_cashier = new OracleParameter("ic_cashier", OracleDbType.Varchar2, 20);
op_cashier.Direction = ParameterDirection.Input;
op_cashier.Value = cashier;
//审核人
OracleParameter op_checker = new OracleParameter("ic_checker", OracleDbType.Varchar2, 20);
op_checker.Direction = ParameterDirection.Input;
op_checker.Value = checker;
//单张发票最大面额
OracleParameter op_max = new OracleParameter("in_max", OracleDbType.Decimal);
op_max.Direction = ParameterDirection.Input;
op_max.Value = max;
return(SqlAssist.ExecuteProcedure("pkg_business.prc_SaveTaxInfo", new OracleParameter[] { op_url, op_id, op_appId, op_addr, op_bank, op_fplx, op_public, op_private, op_cashier, op_checker, op_max }));
}
/// <summary>
/// 打印 火化、临时性销售发票
/// </summary>
/// <param name="settleId"></param>
/// <param name="invClient"></param>
public static void Print_Invoice(string settleId, InvoiceInfo invClient)
{
string s_tax_name = string.Empty;
string s_nextNum = GetTaxInvoiceNextNum();
MessageBox.Show("下一张发票号:" + s_nextNum, "", MessageBoxButtons.OK, MessageBoxIcon.Information);
OracleDataReader reader = SqlAssist.ExecuteReader("select * from v_sa01 where sa010 ='" + settleId + "'");
OracleDataReader itemTaxInfo = null;
int i_counter = 0;
///1.设置发票整体信息
Envior.mform.goldTax.InvInfoInit(); //发票信息初始化
Envior.mform.goldTax.InfoKind = 2; //发票类型 - 普通发票
Envior.mform.goldTax.InfoSellerBankAccount = MiscAction.GetTaxSellerBank(); //销方开户行及账号
Envior.mform.goldTax.InfoSellerAddressPhone = MiscAction.GetTaxSellerAddress(); //销方地址电话
Envior.mform.goldTax.InfoInvoicer = Envior.cur_invoicer; //开票人
Envior.mform.goldTax.InfoCashier = Envior.cur_invoicer; //收款人
Envior.mform.goldTax.InfoChecker = Envior.cur_checker; //复核人
Envior.mform.goldTax.InfoClientName = invClient.InfoClientName; //客户名称
Envior.mform.goldTax.InfoClientTaxCode = invClient.InfoClientTaxCode; //购方税号
Envior.mform.goldTax.InfoClientBankAccount = invClient.infoclientbankaccount; //购方银行账号
Envior.mform.goldTax.InfoClientAddressPhone = invClient.infoclientaddressphone; //购方地址电话
Envior.mform.goldTax.InfoTaxRate = 17; //税率
Envior.mform.goldTax.InfoBillNumber = settleId; //销售单据编号
Envior.mform.goldTax.ClearInvList();
while (reader.Read())
{
Envior.mform.goldTax.InvListInit();
if (reader["SA002"].ToString() == "08" || reader["SA003"].ToString().Contains("寄存费"))
{
s_tax_name = GetRegLevel_TaxName(Convert.ToDecimal(reader["PRICE"]));
Envior.mform.goldTax.ListGoodsName = s_tax_name;
Envior.mform.goldTax.InfoTaxRate = 0;
Envior.mform.goldTax.ListNumber = Convert.ToDouble(reader["NUMS"]);
Envior.mform.goldTax.ListPrice = Convert.ToDouble(reader["PRICE"]);
Envior.mform.goldTax.ListPriceKind = 1; //含税价标志，单价和金额的种类， 0 为不含税价，1 为含税价
Envior.mform.goldTax.AddInvList();
}
else
{
itemTaxInfo = SqlAssist.ExecuteReader("select * from v_allItem where item_id ='" + reader["SA004"].ToString() + "'");
if (itemTaxInfo.HasRows)
{
while (itemTaxInfo.Read())
{
if (string.IsNullOrEmpty(itemTaxInfo["TX003"].ToString()))
{
MessageBox.Show(reader["SA003"] + "未设置对应的税务项目!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
s_tax_name = itemTaxInfo["TX003"].ToString();
}
Envior.mform.goldTax.ListGoodsName = s_tax_name;
Envior.mform.goldTax.InfoTaxRate = Convert.ToSByte(itemTaxInfo["TX005"]);
Envior.mform.goldTax.ListNumber = Convert.ToDouble(reader["NUMS"]);
Envior.mform.goldTax.ListPrice = Convert.ToDouble(reader["PRICE"]);
Envior.mform.goldTax.ListPriceKind = 1; //含税价标志，单价和金额的种类， 0 为不含税价，1 为含税价
Envior.mform.goldTax.AddInvList();
}
}
}
i_counter++;
}
if (i_counter > 7 /*AppInfo.TAXITEMCOUNT*/)
{
Envior.mform.goldTax.InfoListName = "商品服务项目清单" + settleId; //设置后才会打印清单
}
//开具发票
Envior.mform.goldTax.Invoice();
string s_invoice_code = string.Empty;
int i_invoice_num = 0;
if (Envior.mform.goldTax.RetCode == 4011)
{
s_invoice_code = Envior.mform.goldTax.InfoTypeCode;
i_invoice_num = Envior.mform.goldTax.InfoNumber;
if (Tax_Log(settleId, s_invoice_code, i_invoice_num.ToString()) == 1)
{
MessageBox.Show("开票成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
///////////////////// 打印发票 ///////////////////////////
Envior.mform.goldTax.InfoKind = 2; //发票类型
Envior.mform.goldTax.InfoTypeCode = s_invoice_code; //发票代码
Envior.mform.goldTax.InfoNumber = i_invoice_num; //发票号
Envior.mform.goldTax.InfoShowPrtDlg = 1; //是否显示确认对话框
Envior.mform.goldTax.GoodsListFlag = 0; //打印发票
Envior.mform.goldTax.PrintInv();
if (i_counter > 7 /*AppInfo.TAXITEMCOUNT*/)
{
if (MessageBox.Show("是否打印发票清单?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
Envior.mform.goldTax.InfoKind = 2; //发票类型
Envior.mform.goldTax.InfoTypeCode = s_invoice_code; //发票代码
Envior.mform.goldTax.InfoNumber = i_invoice_num; //发票号
Envior.mform.goldTax.InfoShowPrtDlg = 1; //是否显示确认对话框
Envior.mform.goldTax.GoodsListFlag = 1; //打印清单
Envior.mform.goldTax.PrintInv();
}
}
}
else
{
MessageBox.Show("错误代码:" + Envior.mform.goldTax.RetCode + "\n" + "错误信息:" + Envior.mform.goldTax.RetMsg, "开票失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
