/// <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="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();
}