//物料需要计划 protected void GetPlan() { string ptc = Request.QueryString["PTC"].ToString(); string sql = "SELECT planno AS PH,pjnm AS Project,engnm AS Eng," + "depnm AS Dep,sqrnm AS Applicant,sqrtime AS Date,ptcode AS PTC," + "marid AS MaterialCode,marnm AS MaterialName,margg AS MaterialStandard," + "marunit AS Unit,B.num AS Num,B.fznum AS Weight FROM View_TBPC_PURCHASEPLAN_RVW AS A INNER JOIN View_TBPC_Newmarplan AS B ON A.ptcode=B.MP_TRACKNUM " + "WHERE ptcode='" + ptc + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sql); RepeaterPlan.DataSource = dt; RepeaterPlan.DataBind(); }
private void LoadData(int compid) { //,DateTime compdateform,int type //sel company detail from code //&& (cus.tcd_date_from >= compdateform && cus.tcd_date_to <= compdateform) && cus.mst_id == type var objcomp = (from cus in dbc.trn_company_details where cus.tcd_id == compid select cus).FirstOrDefault(); //where form? if (objcomp != null) { lblremark_compname_th.Text = objcomp.tcd_tname; lblremark_compname_en.Text = objcomp.tcd_ename; lbldoccode.Text = objcomp.tcd_document_no; lblcompcode.Text = objcomp.tcd_code; lblcompany_th.Text = objcomp.tcd_tname; lblcompany_en.Text = objcomp.tcd_ename; lbldeptowner.Text = objcomp.tcd_type; lblcompany_address.Text = objcomp.tcd_address; lblcompany_amphur.Text = objcomp.tcd_district; lblcompany_tumbon.Text = objcomp.tcd_tambon; lblcompany_province.Text = objcomp.tcd_province; lblcompany_postcode.Text = objcomp.tcd_postcode; //contact var objcontact = (from tcp in dbc.trn_contact_persons where tcp.mst_contact_type.mct_code == 'C' && tcp.tcd_id == objcomp.tcd_id select new { contact_name = tcp.tcp_name, contact_tel = tcp.tcp_tel, contact_fax = tcp.tcp_fax, contact_email = tcp.tcp_email }).ToList(); if (objcontact.Count > 0) { RepeaterContact.DataSource = objcontact; RepeaterContact.DataBind(); } //emp mtk name var objtcp = (from tcp in dbc.trn_contact_persons where tcp.tcd_id == objcomp.tcd_id && tcp.mst_contact_type.mct_code == 'M' select new { mtk_name = tcp.tcp_name, mtk_tel = tcp.tcp_tel, mtk_fax = tcp.tcp_fax, mtk_email = tcp.tcp_email }).ToList(); if (objtcp.Count > 0) { RepeaterMTK.DataSource = objtcp; RepeaterMTK.DataBind(); } lblcontact_s.Text = String.Format("{0:dd/MM/yyyy}", objcomp.tcd_date_from); lblcontact_e.Text = String.Format("{0:dd/MM/yyyy}", objcomp.tcd_date_to); lblpayor.Text = objcomp.tcd_payor; //plan var objplan = (from plan in dbc.trn_plans where plan.tcd_id == objcomp.tcd_id select new { plan_name = plan.tpl_name, plan_action = "..." }).ToList(); if (objplan.Count > 0) { RepeaterPlan.DataSource = objplan; RepeaterPlan.DataBind(); } //comp name billing lblcomp_name_bill.Text = objcomp.tcd_bill_company; //comp address billing lblcomp_addr_bill.Text = objcomp.tcd_bill_address + " " + objcomp.tcd_bill_tambon + " " + objcomp.tcd_bill_district + " " + objcomp.tcd_bill_province + " " + objcomp.tcd_bill_postcode; //contact person billing var objcontactbill = (from tcp in dbc.trn_contact_persons where tcp.mst_contact_type.mct_code == 'B' && tcp.tcd_id == objcomp.tcd_id select new { contact_bill_name = tcp.tcp_name, contact_bill_tel = tcp.tcp_tel, contact_bill_fax = tcp.tcp_fax, contact_bill_email = tcp.tcp_email }).ToList(); if (objcontactbill.Count > 0) { RepeaterContactBill.DataSource = objcontactbill; RepeaterContactBill.DataBind(); } var old_paymentType = (from t1 in dbc.trn_payments where t1.tcd_id == objcomp.tcd_id select new { mst_id = t1.mst_id, mst_nameTh = (t1.mst_type != null) ? t1.mst_type.mst_tname : "", mst_nameEn = (t1.mst_type != null) ? t1.mst_type.mst_ename : "", mpt_id = t1.mpt_id, mpt_nameTh = (t1.mst_payment_type != null) ? t1.mst_payment_type.mpt_tname : "", mpt_nameEn = (t1.mst_payment_type != null) ? t1.mst_payment_type.mpt_ename : "", tpa_mpt_credit = t1.tpa_mpt_credit, tpa_mpt_remark = t1.tpa_mpt_remark, mbm_id = t1.mbm_id, mbm_nameTh = (t1.mst_billing_method != null) ? t1.mst_billing_method.mbm_tname : "", mbm_nameEn = (t1.mst_billing_method != null) ? t1.mst_billing_method.mbm_ename : "", mpm_id = t1.mpm_id, mpm_nameTh = (t1.mst_payment_main != null) ? t1.mst_payment_main.mpm_tname : "", mpm_nameEn = (t1.mst_payment_main != null) ? t1.mst_payment_main.mpm_ename : "", mpr_id = t1.mpr_id, mpr_nameTh = (t1.mst_payment_rate != null) ? t1.mst_payment_rate.mpr_tname : "", mpr_nameEn = (t1.mst_payment_rate != null) ? t1.mst_payment_rate.mpr_ename : "", mpq_id = t1.mpq_id, mpq_nameTh = (t1.mst_payment_quatation != null) ? t1.mst_payment_quatation.mpq_tname : "", mpq_nameEn = (t1.mst_payment_quatation != null) ? t1.mst_payment_quatation.mpq_ename : "", tpa_mpq_credit = t1.tpa_mpq_credit, mpn_id = t1.mpn_id, mpn_nameTh = (t1.mst_payment_nquatation != null) ? t1.mst_payment_nquatation.mpn_tname : "", mpn_nameEn = (t1.mst_payment_nquatation != null) ? t1.mst_payment_nquatation.mpn_ename : "", tpa_mpn_credit = t1.tpa_mpn_credit, mrm_id = t1.mrm_id, mrm_nameTh = (t1.mst_receive_medicine != null) ? t1.mst_receive_medicine.mrm_tname : "", mrm_nameEn = (t1.mst_receive_medicine != null) ? t1.mst_receive_medicine.mrm_ename : "", tpa_coupon = t1.tpa_coupon, coupon_name = (t1.tpa_coupon == 'I') ? "ให้" : "ไม่ให้", tpa_coupon_remark = t1.tpa_coupon_remark, Status = "O", tpa_id = t1.tpa_id }).ToList(); _paymentType = (from t1 in old_paymentType select new PaymentType { mst_name = t1.mst_nameTh + "/" + t1.mst_nameEn, mpt_name = t1.mpt_nameTh + "/" + t1.mpt_nameEn, tpa_mpt_credit = t1.tpa_mpt_credit, tpa_mpt_remark = t1.tpa_mpt_remark, mbm_name = t1.mbm_nameTh + "/" + t1.mbm_nameEn, mpm_name = t1.mpm_nameTh + "/" + t1.mpm_nameEn, mpr_name = t1.mpr_nameTh + "/" + t1.mpr_nameEn, mpq_name = t1.mpq_nameTh + "/" + t1.mpq_nameEn, tpa_mpq_credit = t1.tpa_mpq_credit, mpn_name = t1.mpn_nameTh + "/" + t1.mpn_nameEn, tpa_mpn_credit = t1.tpa_mpn_credit, mrm_name = t1.mrm_nameTh + "/" + t1.mrm_nameEn, tpa_coupon = t1.tpa_coupon, coupon_name = (t1.tpa_coupon == 'I') ? "ให้" : "ไม่ให้", tpa_coupon_remark = t1.tpa_coupon_remark, }).ToList(); RepeaterPaymentType.DataSource = _paymentType; RepeaterPaymentType.DataBind(); //package and option Order set var objpackage = (from package in dbc.trn_package_details where package.tcd_id == objcomp.tcd_id select new { package_order = package.tpd_order_desc, package_price = package.tpd_price, package_payment = (from mpt in dbc.mst_payment_types where mpt.mpt_id == package.mpt_id select mpt.mpt_tname).FirstOrDefault(), package_credit = package.tpd_limit_credit, package_s_date = String.Format("{0:dd/MM/yyyy}", package.tpd_date_from), package_e_date = String.Format("{0:dd/MM/yyyy}", package.tpd_date_to), package_type = package.tpd_order_type }).ToList(); if (objpackage != null) { RepeaterPackage.DataSource = objpackage.Where(c => c.package_type == "Order Set"); RepeaterPackage.DataBind(); RepeaterOption.DataSource = objpackage.Where(c => c.package_type == "Option"); RepeaterOption.DataBind(); } //condition service employee, executive (edit code by morn) var objCond = (from mst_mcs in dbc.mst_condition_services join trn_mcs in dbc.trn_condition_services on mst_mcs.mcs_id equals trn_mcs.mcs_id where mst_mcs.mcs_status == 'A' && (trn_mcs.tcd_id == objcomp.tcd_id) && (trn_mcs.tcs_type == "EM" || trn_mcs.tcs_type == "EX") select new { type = trn_mcs.tcs_type, ename = mst_mcs.mcs_ename, tname = mst_mcs.mcs_tname }).ToList(); lblcondition_emp.Text = string.Join(", ", objCond.Where(x => x.type == "EM").Select(x => x.ename + '/' + x.tname)); lblcondition_exec.Text = string.Join(", ", objCond.Where(x => x.type == "EX").Select(x => x.ename + '/' + x.tname)); var objattach = Constant.GetObjAttachFile(objcomp.tcd_id, "CLT");//(from file in dbc.trn_attach_files where file.taf_user_type == 'H' && file.tcd_id == objcomp.tcd_id select new { file_name = file.taf_file_name, file_path = file.taf_path_name }).ToList(); if (objattach.Count > 0) { RepeaterFile.DataSource = objattach; RepeaterFile.DataBind(); } divremark.InnerHtml = Server.HtmlDecode(objcomp.tcd_remark); lbllastupdate.Text = String.Format("{0:dd/MM/yyyy}", objcomp.tcd_update_date); lbllastupdateby.Text = objcomp.mul_user_login; //search name check objnchk_list = (from tnc in dbc.trn_name_checks where tnc.tcd_id == objcomp.tcd_id select tnc).ToList(); if (objnchk_list != null) { //objnchk_list = objnchk_list; RepeaterPatient.DataSource = objnchk_list; RepeaterPatient.DataBind(); } } }