/// <summary>
/// 打印管理费缴纳记录
/// </summary>
/// <param name="fa001"></param>
public static void PrintPayRecord(string fa001)
{
OracleCommand oc_command = new OracleCommand("select * from v_print_payrecord where pr001 = :fa001", SqlAssist.conn);
OracleParameter op_fa001 = new OracleParameter("fa001", OracleDbType.Varchar2, 10);
op_fa001.Direction = ParameterDirection.Input;
op_fa001.Value = fa001;
oc_command.Parameters.Add(op_fa001);
OracleDataReader reader = oc_command.ExecuteReader();
if (reader.HasRows && reader.Read())
{
StringBuilder sb_1 = new StringBuilder(100);
sb_1.Append(reader["AC001"].ToString() + PADSTR); //购墓流水号
sb_1.Append(string.Format("{0:yyyy-MM-dd}", reader["PR002"]) + PADSTR); //缴费开始日期
sb_1.Append(string.Format("{0:yyyy-MM-dd}", reader["PR003"]) + PADSTR); //缴费终止日期
sb_1.Append(reader["NUMS"].ToString() + PADSTR); //缴费年限
sb_1.Append(reader["HANDLER"].ToString() + PADSTR); //经办人
Send_PrintData printData = new Send_PrintData();
printData.command = "payrecord";
printData.data = sb_1.ToString();
printData.extra1 = reader["TIMES"].ToString();
Frm_main.socket.sendMsg(Tools.ConvertObjectToJson(printData));
}
else
{
XtraMessageBox.Show("未找到数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
reader.Dispose();
oc_command.Dispose();
}
/// <summary>
/// 补打火化证明(带身份证)
/// </summary>
/// <param name="ac001"></param>
public static void Print_HHZM_BD2(string ac001, DateTime birth)
{
StringBuilder sb_1 = new StringBuilder(200);
OracleCommand oc_command = new OracleCommand("select * from V_PRINT_HHZM where ac001 = :ac001", SqlHelper.conn);
OracleParameter op_ac001 = new OracleParameter("ac001", OracleDbType.Varchar2, 10);
op_ac001.Direction = ParameterDirection.Input;
op_ac001.Value = ac001;
oc_command.Parameters.Add(op_ac001);
OracleDataReader reader = oc_command.ExecuteReader();
if (reader.HasRows && reader.Read())
{
sb_1.Append(reader["AC003"].ToString() + PADSTR); //逝者姓名
sb_1.Append(reader["AC002"].ToString() + PADSTR); //逝者性别
//所属区县
if (reader["AC007"] == null || reader["AC007"] is DBNull)
{
sb_1.Append("" + PADSTR);
}
else
{
sb_1.Append(MiscAction.Mapper_DD(reader["AC007"].ToString()) + PADSTR);
}
sb_1.Append(reader["AC014"].ToString() + PADSTR); //身份证号
sb_1.Append(reader["FIRETIME"].ToString() + PADSTR); //火化日期
//死亡原因
if (reader["AC005"] == null || reader["AC005"] is DBNull)
{
sb_1.Append("" + PADSTR);
}
else
{
sb_1.Append(reader["AC005"].ToString() + PADSTR);
}
//经办日期
sb_1.Append(string.Format("{0:yyyy年MM月dd日}", MiscAction.GetServerTime()) + PADSTR);
sb_1.Append(string.Format("{0:yyyy年MM月dd日}", birth) + PADSTR);
Send_PrintData printData = new Send_PrintData();
printData.command = "hhzm_bd2";
printData.data = sb_1.ToString();
Frm_main.socket.sendMsg(Tool.ConvertObjectToJson(printData));
}
else
{
XtraMessageBox.Show("未找到数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
reader.Dispose();
oc_command.Dispose();
}
/// <summary>
/// 打印管理费缴纳记录
/// </summary>
/// <param name="fa001"></param>
public static void PrintPayRecord(string ac001, int orderId)
{
Send_PrintData printData = new Send_PrintData();
printData.command = "payrecord";
printData.data = "";
printData.extra1 = orderId.ToString();
printData.extra2 = GetPayRecordPrintData(ac001, orderId);
Frm_main.socket.sendMsg(Tools.ConvertObjectToJson(printData));
}
public static void Print_PayRecord(string fa001)
{
int i_order = RegAction.GetPayTimes(fa001);
StringBuilder sb_1 = new StringBuilder(200);
OracleCommand oc_command = new OracleCommand("select * from rc04 where rc010 = :fa001", SqlHelper.conn);
OracleParameter op_fa001 = new OracleParameter("fa001", OracleDbType.Varchar2, 10);
op_fa001.Direction = ParameterDirection.Input;
op_fa001.Value = fa001;
oc_command.Parameters.Add(op_fa001);
OracleDataReader reader = oc_command.ExecuteReader();
if (reader.HasRows && reader.Read())
{
int i_times = i_order % App_Const.PAYPAGECOUNT;
if (i_times == 1 && i_order > 1)
{
XtraMessageBox.Show("需要更换新证!请先将新证放入打印机打印基础信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
Print_RegCardBase(reader["RC001"].ToString());
}
if (i_times == 0)
{
i_times = App_Const.PAYPAGECOUNT;
}
sb_1.Append(string.Format("{0:yyyyMMdd}", reader["RC200"]) + PADSTR); //经办日期
sb_1.Append(string.Format("{0:yyyy-MM-dd}", reader["RC020"]) + PADSTR); //缴费开始
sb_1.Append(string.Format("{0:yyyy-MM-dd}", reader["RC022"]) + PADSTR); //缴费终止
string s_handler = reader["RC100"].ToString(); //经办人
string s_handler_code = SqlHelper.ExecuteScalar("select uc002 from uc01 where uc001='" + s_handler + "'").ToString();
sb_1.Append(s_handler_code + PADSTR); //经办人代码
sb_1.Append("第" + i_order.ToString() + "次" + PADSTR);
Send_PrintData printData = new Send_PrintData();
printData.command = "payrecord";
printData.data = sb_1.ToString();
printData.extra1 = i_times.ToString();
Frm_main.socket.sendMsg(Tool.ConvertObjectToJson(printData));
}
reader.Dispose();
oc_command.Dispose();
}
/// <summary>
/// 打印购墓协议
/// </summary>
/// <param name="ac001"></param>
public static void PrintProtocol(string ac001)
{
OracleCommand oc_command = new OracleCommand("select * from v_print_protocol where ac001 = :ac001", SqlAssist.conn);
OracleParameter op_ac001 = new OracleParameter("ac001", OracleDbType.Varchar2, 10);
op_ac001.Direction = ParameterDirection.Input;
op_ac001.Value = ac001;
oc_command.Parameters.Add(op_ac001);
OracleDataReader reader = oc_command.ExecuteReader();
if (reader.HasRows && reader.Read())
{
string s_szxm = string.Empty;
StringBuilder sb_1 = new StringBuilder(100);
sb_1.Append(reader["GUYNAME"].ToString() + PADSTR); //安葬逝者姓名
sb_1.Append(reader["AC005"].ToString() + PADSTR); //联系地址
//sb_1.Append(" " + PADSTR); //bitid
sb_1.Append(reader["SALEPRICE"].ToString() + PADSTR); //售价
sb_1.Append(reader["AC003"].ToString() + PADSTR); //购墓人
sb_1.Append(reader["RELATION"].ToString() + PADSTR); //与购墓人关系
sb_1.Append(reader["REGION_NAME"].ToString() + PADSTR); //墓区
sb_1.Append(reader["ROWER_NAME"].ToString() + PADSTR); //墓区排
sb_1.Append(reader["BITDESC"].ToString() + PADSTR); //号位描述
Send_PrintData printData = new Send_PrintData();
printData.command = "procotol";
printData.data = sb_1.ToString();
Frm_main.socket.sendMsg(Tools.ConvertObjectToJson(printData));
}
else
{
XtraMessageBox.Show("未找到数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
reader.Dispose();
oc_command.Dispose();
}
/// <summary>
/// 打印墓位证书
/// </summary>
/// <param name="ac001"></param>
/// <param name="orderId"></param>
public static void PrintCert(string ac001, int orderId)
{
string s_certId = string.Empty;
string s_position = string.Empty;
StringBuilder sb_1 = new StringBuilder(200);
OracleCommand oc_command = new OracleCommand("select * from v_print_cert where ac001 = :ac001", SqlAssist.conn);
OracleParameter op_ac001 = new OracleParameter("ac001", OracleDbType.Varchar2, 10);
op_ac001.Direction = ParameterDirection.Input;
op_ac001.Value = ac001;
oc_command.Parameters.Add(op_ac001);
OracleDataReader reader = oc_command.ExecuteReader();
if (reader.HasRows && reader.Read())
{
sb_1.Append(reader["AC001"].ToString() + PADSTR);
if (reader["PNAME"] == null || reader["PNAME"] is DBNull)
{
sb_1.Append("" + PADSTR); //安葬逝者姓名
}
else
{
sb_1.Append(reader["PNAME"].ToString() + PADSTR);
}
if (reader["PNAME2"] == null || reader["PNAME2"] is DBNull)
{
sb_1.Append("" + PADSTR); //安葬逝者姓名2
}
else
{
sb_1.Append(reader["PNAME2"].ToString() + PADSTR);
}
if (reader["AC049"] == null || reader["AC049"] is DBNull)
{
sb_1.Append("" + PADSTR); //购墓日期
}
else
{
sb_1.Append(string.Format("{0:yyyy-MM-dd}", reader["AC049"]) + PADSTR);
}
if (reader["BURYTIME"] == null || reader["BURYTIME"] is DBNull)
{
sb_1.Append("" + PADSTR); //安葬日期
}
else
{
sb_1.Append(string.Format("{0:yyyy-MM-dd}", reader["BURYTIME"]) + PADSTR);
}
sb_1.Append(reader["AC022"].ToString() + PADSTR); //墓位售价
sb_1.Append(reader["AC003"].ToString() + PADSTR); //购墓人
if (reader["AC005"] == null || reader["AC005"] is DBNull)
{
sb_1.Append("" + PADSTR); //联系地址
}
else
{
sb_1.Append(reader["AC005"].ToString() + PADSTR);
}
if (reader["AC050"] == null || reader["AC050"] is DBNull)
{
sb_1.Append("" + PADSTR); //证书编号
}
else
{
sb_1.Append(reader["AC050"].ToString() + PADSTR);
}
sb_1.Append(reader["HANDLER"].ToString() + PADSTR); //经办人
sb_1.Append(reader["POSITION"].ToString() + PADSTR); //墓穴位置
sb_1.Append(reader["AC020"].ToString() + PADSTR); //墓位定价
Send_PrintData printData = new Send_PrintData();
printData.command = "print_cert";
printData.data = sb_1.ToString();
if (orderId > 0)
{
printData.extra1 = orderId.ToString();
printData.extra2 = GetPayRecordPrintData(ac001, orderId);
}
Frm_main.socket.sendMsg(Tools.ConvertObjectToJson(printData));
}
else
{
XtraMessageBox.Show("未找到数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
reader.Dispose();
oc_command.Dispose();
}
/// <summary>
/// 打印墓位证书
/// </summary>
/// <param name="ac001"></param>
public static void PrintCert(string ac001)
{
string s_certId = string.Empty;
string s_position = string.Empty;
StringBuilder sb_1 = new StringBuilder(200);
OracleCommand oc_command = new OracleCommand("select * from v_print_cert where ac001 = :ac001", SqlAssist.conn);
OracleParameter op_ac001 = new OracleParameter("ac001", OracleDbType.Varchar2, 10);
op_ac001.Direction = ParameterDirection.Input;
op_ac001.Value = ac001;
oc_command.Parameters.Add(op_ac001);
OracleDataReader reader = oc_command.ExecuteReader();
if (reader.HasRows && reader.Read())
{
if (reader["AC113"] == null || reader["AC113"] is DBNull)
{
sb_1.Append("" + PADSTR); //安葬逝者姓名
}
else
{
sb_1.Append(reader["AC113"].ToString() + PADSTR);
}
if (reader["AC112"] == null || reader["AC112"] is DBNull)
{
sb_1.Append("" + PADSTR); //安葬逝者性别
}
else
{
sb_1.Append(reader["AC112"].ToString() + PADSTR);
}
if (reader["AC114"] == null || reader["AC114"] is DBNull)
{
sb_1.Append("" + PADSTR); //安葬逝者年龄
}
else
{
sb_1.Append(reader["AC114"].ToString() + PADSTR);
}
if (reader["AC115"] == null || reader["AC115"] is DBNull)
{
sb_1.Append("" + PADSTR); //安葬逝者籍贯
}
else
{
sb_1.Append(reader["AC115"].ToString() + PADSTR);
}
if (reader["AC116"] == null || reader["AC116"] is DBNull)
{
sb_1.Append("" + PADSTR); //安葬逝者生辰
}
else
{
sb_1.Append(string.Format("{0:yyyy-MM-dd}", reader["AC116"]) + PADSTR);
}
if (reader["AC118"] == null || reader["AC118"] is DBNull)
{
sb_1.Append("" + PADSTR); //安葬逝者死亡日期
}
else
{
sb_1.Append(string.Format("{0:yyyy-MM-dd}", reader["AC118"]) + PADSTR);
}
if (reader["AC119"] == null || reader["AC119"] is DBNull)
{
sb_1.Append("" + PADSTR); //安葬逝者 安葬日期
}
else
{
sb_1.Append(string.Format("{0:yyyy-MM-dd}", reader["AC119"]) + PADSTR);
}
if (reader["AC049"] == null || reader["AC049"] is DBNull)
{
sb_1.Append("" + PADSTR); //购墓日期
}
else
{
sb_1.Append(string.Format("{0:yyyy-MM-dd}", reader["AC049"]) + PADSTR);
}
if (reader["AC050"] == null || reader["AC050"] is DBNull)
{
sb_1.Append("" + PADSTR); //证书编号
}
else
{
sb_1.Append(string.Format("{0:yyyy-MM-dd}", reader["AC050"]) + PADSTR);
}
sb_1.Append(reader["POSITION"].ToString() + PADSTR);
Send_PrintData printData = new Send_PrintData();
printData.command = "print_cert";
printData.data = sb_1.ToString();
Frm_main.socket.sendMsg(Tools.ConvertObjectToJson(printData));
}
else
{
XtraMessageBox.Show("未找到数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
reader.Dispose();
oc_command.Dispose();
}
/// <summary>
/// 打印 迁出通知单
/// </summary>
/// <param name="rc001"></param>
public static void Print_OutCard(string rc001)
{
StringBuilder sb_1 = new StringBuilder(200);
OracleCommand oc_command = new OracleCommand("select * from v_outcard where rc001 = :rc001", SqlHelper.conn);
OracleParameter op_rc001 = new OracleParameter("rc001", OracleDbType.Varchar2, 10);
op_rc001.Direction = ParameterDirection.Input;
op_rc001.Value = rc001;
oc_command.Parameters.Add(op_rc001);
OracleDataReader reader = oc_command.ExecuteReader();
if (reader.HasRows && reader.Read())
{
sb_1.Append(reader["RC003"].ToString().Trim() + PADSTR); //逝者姓名
sb_1.Append(reader["RC109"].ToString().Trim() + PADSTR); //寄存证号
sb_1.Append(reader["POSITION"].ToString() + PADSTR); //寄存位置
if (reader["RC050"] == null || reader["RC050"] is DBNull)
{
sb_1.Append("" + PADSTR); //家属姓名
}
else
{
sb_1.Append(reader["RC050"].ToString().Trim() + PADSTR);
}
if (reader["RC051"] == null || reader["RC051"] is DBNull)
{
sb_1.Append("" + PADSTR); //联系电话
}
else
{
sb_1.Append(reader["RC051"].ToString().Trim() + PADSTR);
}
if (reader["OC002"] == null || reader["OC002"] is DBNull)
{
sb_1.Append("" + PADSTR); //迁出日期
}
else
{
sb_1.Append(string.Format("{0:yyyy-MM-dd}", reader["OC002"]) + PADSTR);
}
if (reader["RC055"] == null || reader["RC055"] is DBNull)
{
sb_1.Append("" + PADSTR); //联系地址
}
else
{
sb_1.Append(reader["RC055"].ToString().Trim() + PADSTR);
}
if (reader["OC005"] == null || reader["OC005"] is DBNull)
{
sb_1.Append("" + PADSTR); //迁出原因
}
else
{
sb_1.Append(reader["OC005"].ToString().Trim() + PADSTR);
}
Send_PrintData printData = new Send_PrintData();
printData.command = "OutCard";
printData.data = sb_1.ToString();
Frm_main.socket.sendMsg(Tool.ConvertObjectToJson(printData));
}
reader.Dispose();
oc_command.Dispose();
}
/// <summary>
/// 打印骨灰安放卡
/// </summary>
/// <param name="rc001"></param>
public static void Print_RegSettle(string rc001)
{
StringBuilder sb_1 = new StringBuilder(200);
OracleCommand oc_command = new OracleCommand("select * from rc01 where rc001 = :rc001", SqlHelper.conn);
OracleParameter op_rc001 = new OracleParameter("rc001", OracleDbType.Varchar2, 10);
op_rc001.Direction = ParameterDirection.Input;
op_rc001.Value = rc001;
oc_command.Parameters.Add(op_rc001);
OracleDataReader reader = oc_command.ExecuteReader();
if (reader.HasRows && reader.Read())
{
sb_1.Append(reader["RC003"].ToString() + PADSTR); //逝者姓名
sb_1.Append(reader["RC109"].ToString() + PADSTR); //寄存证号
if (reader["RC002"] == null || reader["RC002"] is DBNull)
{
sb_1.Append("" + PADSTR); //性别
}
else
{
sb_1.Append(reader["RC002"].ToString() + PADSTR);
}
if (reader["RC004"] == null || reader["RC004"] is DBNull)
{
sb_1.Append("" + PADSTR); //年龄
}
else
{
sb_1.Append(reader["RC004"].ToString() + PADSTR);
}
//寄存位置
string s_position = RegAction.GetRegPosition(reader["RC001"].ToString());
if (string.IsNullOrEmpty(s_position))
{
sb_1.Append("" + PADSTR);
}
else
{
sb_1.Append(s_position + PADSTR);
}
if (reader["RC050"] == null || reader["RC050"] is DBNull)
{
sb_1.Append("" + PADSTR); //联系人
}
else
{
sb_1.Append(reader["RC050"].ToString() + PADSTR);
}
if (reader["RC051"] == null || reader["RC051"] is DBNull)
{
sb_1.Append("" + PADSTR); //联系电话
}
else
{
sb_1.Append(reader["RC051"].ToString() + PADSTR);
}
if (reader["RC052"] == null || reader["RC052"] is DBNull)
{
sb_1.Append("" + PADSTR); //与逝者关系
}
else
{
sb_1.Append(reader["RC052"].ToString() + PADSTR);
}
if (reader["RC200"] == null || reader["RC200"] is DBNull)
{
sb_1.Append("" + PADSTR); //经办日期
}
else
{
sb_1.Append(string.Format("{0:yyyy年MM月dd日}", reader["RC200"]) + PADSTR);
}
if (reader["RC055"] == null || reader["RC055"] is DBNull)
{
sb_1.Append("" + PADSTR); //联系地址
}
else
{
sb_1.Append(reader["RC055"].ToString() + PADSTR);
}
Send_PrintData printData = new Send_PrintData();
printData.command = "RegSettleCard";
printData.data = sb_1.ToString();
Frm_main.socket.sendMsg(Tool.ConvertObjectToJson(printData));
}
reader.Dispose();
oc_command.Dispose();
}
/// <summary>
/// 打印火化证明
/// </summary>
/// <param name="ac001"></param>
public static void Print_HHZM(string ac001)
{
StringBuilder sb_1 = new StringBuilder(200);
OracleCommand oc_command = new OracleCommand("select * from V_PRINT_HHZM where ac001 = :ac001", SqlHelper.conn);
OracleParameter op_ac001 = new OracleParameter("ac001", OracleDbType.Varchar2, 10);
op_ac001.Direction = ParameterDirection.Input;
op_ac001.Value = ac001;
oc_command.Parameters.Add(op_ac001);
OracleDataReader reader = oc_command.ExecuteReader();
if (reader.HasRows && reader.Read())
{
if (reader["MM"] == null || reader["MM"] is DBNull)
{
sb_1.Append("" + PADSTR); //密码
}
else
{
sb_1.Append(reader["MM"].ToString() + PADSTR);
}
if (reader["AC003"] == null || reader["AC003"] is DBNull)
{
sb_1.Append("" + PADSTR); //逝者姓名
}
else
{
sb_1.Append(reader["AC003"].ToString() + PADSTR);
}
if (reader["AC002"] == null || reader["AC002"] is DBNull)
{
sb_1.Append("" + PADSTR); //逝者性别
}
else
{
sb_1.Append(reader["AC002"].ToString() + PADSTR);
}
if (reader["AC004"] == null || reader["AC004"] is DBNull)
{
sb_1.Append("" + PADSTR); //逝者年龄
}
else
{
sb_1.Append(reader["AC004"].ToString() + PADSTR);
}
if (reader["AC008"] == null || reader["AC008"] is DBNull)
{
sb_1.Append("" + PADSTR); //住址
}
else
{
sb_1.Append(reader["AC008"].ToString() + PADSTR);
}
if (reader["AC005"] == null || reader["AC005"] is DBNull)
{
sb_1.Append("" + PADSTR); //死因
}
else
{
sb_1.Append(reader["AC005"].ToString() + PADSTR);
}
if (reader["FIRETIME"] == null || reader["FIRETIME"] is DBNull)
{
sb_1.Append("" + PADSTR); //火化时间
}
else
{
sb_1.Append(reader["FIRETIME"].ToString() + PADSTR);
}
sb_1.Append(Envior.cur_user.UC003 + PADSTR); //经办人
if (reader["FIRETIME"] == null || reader["FIRETIME"] is DBNull)
{
sb_1.Append("" + PADSTR); //经办时间
}
else
{
sb_1.Append(reader["FIRETIME"].ToString() + PADSTR);
}
sb_1.Append(reader["UNITNAME"].ToString() + PADSTR); //单位
Send_PrintData printData = new Send_PrintData();
printData.command = "hhzm";
printData.data = sb_1.ToString();
Frm_main.socket.sendMsg(Tool.ConvertObjectToJson(printData));
}
else
{
XtraMessageBox.Show("未找到数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
reader.Dispose();
oc_command.Dispose();
}
/// <summary>
/// 打印寄存证(基础)
/// </summary>
/// <param name="rc001"></param>
public static void Print_RegCardBase(string rc001)
{
StringBuilder sb_1 = new StringBuilder(200);
OracleCommand oc_command = new OracleCommand("select * from rc01 where rc001 = :rc001", SqlHelper.conn);
OracleParameter op_rc001 = new OracleParameter("rc001", OracleDbType.Varchar2, 10);
op_rc001.Direction = ParameterDirection.Input;
op_rc001.Value = rc001;
oc_command.Parameters.Add(op_rc001);
OracleDataReader reader = oc_command.ExecuteReader();
if (reader.HasRows && reader.Read())
{
sb_1.Append(reader["RC003"].ToString() + PADSTR); //逝者姓名
sb_1.Append(reader["RC109"].ToString() + PADSTR); //寄存证号
if (reader["RC002"] == null || reader["RC002"] is DBNull)
{
sb_1.Append("" + PADSTR); //性别
}
else
{
sb_1.Append(reader["RC002"].ToString() + PADSTR);
}
if (reader["RC004"] == null || reader["RC004"] is DBNull)
{
sb_1.Append("" + PADSTR); //年龄
}
else
{
sb_1.Append(reader["RC004"].ToString() + PADSTR);
}
//寄存位置
string s_position = RegAction.GetRegPosition(reader["RC001"].ToString());
if (string.IsNullOrEmpty(s_position))
{
sb_1.Append("" + PADSTR);
}
else
{
sb_1.Append(s_position + PADSTR);
}
if (reader["RC050"] == null || reader["RC050"] is DBNull)
{
sb_1.Append("" + PADSTR); //联系人
}
else
{
sb_1.Append(reader["RC050"].ToString() + PADSTR);
}
if (reader["RC051"] == null || reader["RC051"] is DBNull)
{
sb_1.Append("" + PADSTR); //联系电话
}
else
{
sb_1.Append(reader["RC051"].ToString() + PADSTR);
}
if (reader["RC200"] == null || reader["RC200"] is DBNull)
{
sb_1.Append("" + PADSTR); //经办日期
}
else
{
sb_1.Append(string.Format("{0:yyyy年MM月dd日}", reader["RC200"]) + PADSTR);
}
if (reader["RC055"] == null || reader["RC055"] is DBNull)
{
sb_1.Append("" + PADSTR); //联系地址
}
else
{
sb_1.Append(reader["RC055"].ToString() + PADSTR);
}
if (reader["RC140"] == null || reader["RC140"] is DBNull)
{
sb_1.Append("" + PADSTR); //寄存日期
}
else
{
sb_1.Append(string.Format("{0:yyyy-MM-dd}", reader["RC140"]) + PADSTR);
}
DateTime d_end = Convert.ToDateTime(SqlHelper.ExecuteScalar("select min(rc022) from rc04 where status = '1' and rc001 = '" + rc001 + "'"));
if (d_end == null)
{
sb_1.Append("" + PADSTR); //截至日期
}
else
{
sb_1.Append(string.Format("{0:yyyy-MM-dd}", d_end) + PADSTR);
}
decimal price = RegAction.GetRegPrice(rc001);
sb_1.Append(price.ToString() + PADSTR);
Send_PrintData printData = new Send_PrintData();
printData.command = "RegCardBase";
printData.data = sb_1.ToString();
Frm_main.socket.sendMsg(Tool.ConvertObjectToJson(printData));
}
reader.Dispose();
oc_command.Dispose();
}
/// <summary>
/// 打印收款凭证（寄存收费）
/// </summary>
/// <param name="fa001"></param>
public static void Print_Skpz1(string fa001)
{
//结算数据
OracleCommand oc_jsd = new OracleCommand("select * from v_fa01 where fa001= :fa001", SqlHelper.conn);
OracleParameter op_fa001 = new OracleParameter("fa001", OracleDbType.Varchar2, 10);
op_fa001.Direction = ParameterDirection.Input;
op_fa001.Value = fa001;
OracleParameter op_sa010 = new OracleParameter("sa010", OracleDbType.Varchar2, 10);
op_sa010.Direction = ParameterDirection.Input;
op_sa010.Value = fa001;
oc_jsd.Parameters.Add(op_fa001);
//结算明细数据
OracleCommand oc_detail = new OracleCommand("select * from v_sa01 where sa010= :sa010", SqlHelper.conn);
oc_detail.Parameters.Add(op_sa010);
OracleDataReader reader = oc_jsd.ExecuteReader();
OracleDataReader reader2 = oc_detail.ExecuteReader();
string s_skr = string.Empty;
string s_skrq = string.Empty;
string s_cuname = string.Empty;
string s_memo = string.Empty;
int i_count = 0;
if (reader.HasRows && reader.Read())
{
StringBuilder sb_1 = new StringBuilder(100);
while (reader2.Read())
{
sb_1.Append(reader2["SA002"].ToString() + PADSTR); // 服务商品类别
sb_1.Append(reader2["SA003"].ToString() + PADSTR); // 服务或商品名
sb_1.Append(reader2["PRICE"].ToString() + PADSTR); // 单价
sb_1.Append(reader2["NUMS"].ToString() + PADSTR); // 数量
sb_1.Append(reader2["SA007"].ToString() + PADSTR); // 销售金额
sb_1.Append(PADSTR2);
i_count++;
}
s_skr = MiscAction.Mapper_Operator(reader["FA100"].ToString());
s_skrq = string.Format("{0:yyyyMMdd}", reader["FA200"]);
s_cuname = reader["FA003"].ToString();
Send_PrintData printData = new Send_PrintData();
printData.command = "print_skpz1";
printData.data = sb_1.ToString();
printData.extra1 = s_cuname;
printData.extra2 = s_skr;
printData.extra3 = s_skrq;
printData.extra4 = RegAction.GetRegFinMemo(fa001);
//i_pages = (int)Math.Ceiling(i_count / (App_Const.BILL_COUNT * 1.0));
//XtraMessageBox.Show("现在开始打印【结算单】，共需要" + i_pages.ToString() + "张!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
Frm_main.socket.sendMsg(Tool.ConvertObjectToJson(printData));
}
else
{
MessageBox.Show("未找到结算数据!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
reader.Dispose();
reader2.Dispose();
oc_jsd.Dispose();
}
