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); }