//物料需要计划
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();
}
}
}
