public static CreateReceiptReqeust ToCreateReceiptRequest(this DataRow resource)
{
CreateReceiptReqeust receipt = new CreateReceiptReqeust()
{
HEAD_REQUEST_NO = resource["HEAD_REQUEST_NO"].ToString(),
ID_CARD_NO = resource["ID_CARD_NO"].ToString(),
PETITION_TYPE_NAME = resource["PETITION_TYPE_NAME"].ToString(),
PAYMENT_DATE = Convert.ToDateTime(resource["PAYMENT_DATE"]),
FIRSTNAME = resource["FIRSTNAME"].ToString(),
LASTNAME = resource["LASTNAME"].ToString(),
GROUP_REQUEST_NO = resource["GROUP_REQUEST_NO"].ToString(),
//GROUP_DATE = Convert.ToDateTime(resource["GROUP_DATE"]),
RECEIPT_NO = resource["RECEIPT_NO"].ToString(),
PAYMENT_NO = resource["PAYMENT_NO"].ToString(),
RECEIPT_DATE = Convert.ToDateTime(resource["RECEIPT_DATE"]),
AMOUNT = Convert.ToDecimal(resource["AMOUNT"]),
// CREATED_DATE = Convert.ToDateTime(resource["CREATED_DATE"]),
CREATE_BY = resource["CREATED_BY"].ToString(),
//SIGNATURE_IMG = resource["SIGNATURE_IMG"].ToString(),
// RUN_NO = Convert.ToInt32(resource["RUN_NO"]),
IMG_SIGN = (byte[])(resource["IMG_SIGN"]),//milk
LICENSE_TYPE_CODE = resource["LICENSE_TYPE_CODE"].ToString()
};
return(receipt);
}
public static byte[] CreateQRcode(IAS.DAL.Interfaces.IIASPersonEntities ctx, CreateReceiptReqeust receipt)
{
byte[] qrcode = null;
QRCodeEncoder encoder = new QRCodeEncoder();
StringBuilder data = new StringBuilder("");
data.AppendLine(String.Format("เลขที่ใบเสร็จ: {0}", receipt.RECEIPT_NO));
data.AppendLine(String.Format("ชื่อ: {0}", receipt.FIRSTNAME));
data.AppendLine(String.Format("จำนวนเงิน: {0}", receipt.AMOUNT.ToString("#,##0.00")));
data.AppendLine(String.Format("Code: {0}", receipt.LICENSE_TYPE_CODE));
string qrres = receipt.LinkRecipt(ctx);
if (qrres.Contains("ไม่พบข้อมูล"))
{
return(null);
}
else
{
data.AppendLine(receipt.LinkRecipt(ctx));
Bitmap img = encoder.Encode(data.ToString(), System.Text.Encoding.UTF8);
ImageConverter converter = new ImageConverter();
qrcode = (byte[])converter.ConvertTo(img, typeof(byte[]));
}
return(qrcode);
}
public void CreateReceiptMapper_CanMap_DataRowTest()
{
string IdWhenCareteInDetail = "";
String G_req_no = "999999561000000091";
String receiptById = "130923130455931";
string IDcon = string.Empty;
if (IdWhenCareteInDetail != "") //สำหรับกรณีเก็บตกที่มีการerrorในการสร้างเอกสาร และต้องมากำหนดการสร้างรายคน
{
IDcon = String.Format(" and d.ID_CARD_NO = '{0}' ", IdWhenCareteInDetail);
}
string tmp = string.Empty;
tmp = " select * from ag_ias_subpayment_d_t d,ag_ias_subpayment_h_t h "
+ " where d.head_request_no = h.head_request_no and h.group_request_no = '" + G_req_no + "' and "
+ " d.record_status = '" + DTO.SubPayment_D_T_Status.A.ToString() + "' and d.receipt_by_id = '" + receiptById + "' ";
string H_req_no = "131010194915174";
string IDcard = "3909900148564";
string PayNo = "0004";
string crit = String.Format(" and d.head_request_no = '{0}' and d.ID_CARD_NO = '{1}' and d.payment_no = '{2}' ", H_req_no, IDcard, PayNo);
tmp = "SELECT d.head_request_no,d.id_card_no ,p.petition_type_name "
+ ",d.payment_date,FN.TITLE_NAME ||' '|| FN.NAMES || ' ' || FN.LASTNAME FirstName , "
+ " NN.NAME || ' ' || ipt.names || ' ' || ipt.lastname LASTNAME, "
+ "g.group_request_no,g.group_date,d.receipt_no,d.PAYMENT_NO,d.RECEIPT_DATE "
+ " ,d.AMOUNT,g.CREATED_DATE, ipt.signature_img , " //----> ipt.signature_img , add by milk
+ "ROW_NUMBER() OVER (ORDER BY g.group_request_no) RUN_NO , g.CREATED_BY "
+ "from ag_ias_payment_g_t g,ag_ias_subpayment_h_t h,ag_ias_subpayment_d_t d, "
+ "ag_petition_type_r p,AG_IAS_LICENSE_D FN ,AG_IAS_PERSONAL_T ipt " //,AG_IAS_PERSONAL_T ipt ---> add by milk
+ ",VW_IAS_TITLE_NAME NN " //milk
+ "where g.group_request_no = h.group_request_no "
+ "and d.head_request_no = h.head_request_no "
+ "and d.RECEIPT_BY_ID = ipt.ID " //->>>> this line add by Milk
+ "and d.petition_type_code = p.petition_type_code "
+ "and FN.ID_CARD_NO = d.id_card_no and NN.ID = ipt.pre_name_code "
+ "and d.petition_type_code in ('01','11','13','14','15','16','17','18') " + crit
+ "union "
+ "SELECT d.head_request_no,d.id_card_no ,p.petition_type_name "
+ ",d.payment_date,TT.NAME ||' '|| FN.NAMES || ' ' || FN.LASTNAME FirstName, "
+ " NN.NAME || ' ' || ipt.names || ' ' || ipt.lastname LASTNAME, "
+ "g.group_request_no,g.group_date,d.receipt_no,d.PAYMENT_NO,d.RECEIPT_DATE,d.AMOUNT,g.CREATED_DATE, ipt.signature_img , " //----> ipt.signature_img , add by milk
+ "ROW_NUMBER() OVER (ORDER BY g.group_request_no) RUN_NO , g.CREATED_BY "
+ "from ag_ias_payment_g_t g,ag_ias_subpayment_h_t h,ag_ias_subpayment_d_t d, "
+ "ag_petition_type_r p,AG_APPLICANT_T FN,VW_IAS_TITLE_NAME TT ,AG_IAS_PERSONAL_T ipt " //,AG_IAS_PERSONAL_T ipt ---> add by milk
+ ",VW_IAS_TITLE_NAME NN " //milk
+ "where g.group_request_no = h.group_request_no "
+ "and d.head_request_no = h.head_request_no "
+ "and d.RECEIPT_BY_ID = ipt.ID " //->>>> this line add by Milk
+ "and d.petition_type_code = p.petition_type_code "
+ "and TT.ID = fn.pre_name_code "
+ "and FN.ID_CARD_NO = d.id_card_no and NN.ID = ipt.pre_name_code "
+ "and fn.testing_no = d.TESTING_NO "
+ "and d.petition_type_code in ('01','11','13','14','15','16','17','18') " + crit;
OracleDB ora = new OracleDB();
DataSet DS_D_T = ora.GetDataSet(tmp);
CreateReceiptReqeust receipt = DS_D_T.Tables[0].Rows[0].ToCreateReceiptRequest();
Assert.AreEqual(receipt.GROUP_REQUEST_NO, G_req_no);
}
