void DataBinder(string id) { if (id.Length > 0) { DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_CallShipmentForOE_SP", new List <IFields>() { dal.CreateIFields() .Append("Option", "GetDetailList") .Append("ChinaMode", FSecurityHelper.CurrentUserDataGET()[25]) .Append("id", id).Append("sys", "OE") .Append("stat", FSecurityHelper.CurrentUserDataGET()[12]) .Append("ShowVoid", hidShowVoid.Text) } ).GetList(); DataTable dt1 = new DataTable(); DataTable dt2 = new DataTable(); if (hidShowInv.Text == "0") { ds.Tables[0].DefaultView.RowFilter = "oe_Type<>'LINV' and oe_Type<>'CTNR' and oe_Type<>'FINV'"; } else { ds.Tables[0].DefaultView.RowFilter = "oe_Type<>'CTNR'"; } dt1 = ds.Tables[0].DefaultView.ToTable(); dt2 = ds.Tables[1].DefaultView.ToTable(); if (ds != null && ds.Tables[0].Rows.Count > 0) { txtLotNo.InnerHtml = "<font color='red'>" + ds.Tables[0].Rows[0]["oe_lotno"].ToString() + "</font>"; txtMawb.InnerHtml = "<font color='red'>" + ds.Tables[0].Rows[0]["oe_mbl"].ToString() + "</font>"; labTransfer.InnerHtml = ds.Tables[0].Rows[0]["Exported"].ToString(); } string[] header = { "Status", "Date", "Type", "No.#", "POL/POD", "WT/Piece", "Amount", "Remark", "Action", "<div class='div_all_print'>Print</div>" }; string[] field = { "void", "oe_date", "oe_Type", "oe_KeyValue", "oe_POL", "WT", "oe_Currency|oe_Total", "remark", "Detail", "Print" }; string msg = "No data"; string[] header_ctnr = { "", "Status / S.Mode / Main", "Container No / S.No", "WT", "CBM", "PCS", "Remark", "Print" }; string[] field_r_ctnr_ = { "isvoid", "oe_serMode", "oe_KeyValue", "GWT", "CBM", "PIECE", "remark", "Print" }; string msg_ctnr = "No data"; txtcontent.InnerHtml = ControlBinder.gridHtml(dt1, header, field, msg); txtcontainer.InnerHtml = ControlBinder.gridHtml(dt2, header_ctnr, field_r_ctnr_, msg_ctnr); } }
void DataBinder(string id) { if (id.Length > 0) { DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_CallShipmentForAE_SP", new List <IFields>() { dal.CreateIFields() .Append("Option", "GetList") .Append("id", id) .Append("ChinaMode", FSecurityHelper.CurrentUserDataGET()[25]) .Append("sys", "AE") .Append("stat", FSecurityHelper.CurrentUserDataGET()[12]) }).GetList(); DataTable dt1 = new DataTable(); if (hidShowInv.Text == "0") { if (hidShowVoid.Text == "1") { ds.Tables[0].DefaultView.RowFilter = "ae_type<>'LINV' and ae_type<>'FINV'"; } else { ds.Tables[0].DefaultView.RowFilter = "ae_type<>'LINV' and ae_type<>'FINV' and (ae_void=0 or air_TransferFrom>0 or air_TransferTo>0)"; } } else { if (hidShowVoid.Text == "0") { ds.Tables[0].DefaultView.RowFilter = "ae_void=0 or air_TransferFrom>0 or air_TransferTo>0"; } } dt1 = ds.Tables[0].DefaultView.ToTable(); if (ds != null && ds.Tables[0].Rows.Count > 0) { txtLotNo.InnerHtml = "<font color='red'> " + ds.Tables[0].Rows[0]["ae_lotno"].ToString() + "</font>"; txtMawb.InnerHtml = "<font color='red'> " + ds.Tables[0].Rows[0]["ae_mawb"].ToString() + "</font>"; labTransfer.InnerHtml = ds.Tables[0].Rows[0]["Exported"].ToString(); } string[] header = { "Status", "Date", "Type", "No.#", "POL/POD", "WT/Piece", "Amount", "Remark", "Action", "<div class='div_all_print' style=\"padding-right:15px;\">Print</div>" }; string[] field = { "void", "ae_date", "ae_Type", "ae_KeyValue", "ae_POL", "wt", "ae_Currency|ae_Total", "remark", "Detail", "Print" }; string msg = "No data"; txtcontent.InnerHtml = ControlBinder.gridHtml(dt1, header, field, msg); } }
void DataBinder(string id) { if (id.Length > 0) { DataSet ds = dal.FactoryDAL(PageHelper.ConnectionStrings, "FW_CallShipmentForTR_SP", new List <IFields>() { dal.CreateIFields() .Append("Option", "GetDetailList").Append("id", id).Append("ChinaMode", FSecurityHelper.CurrentUserDataGET()[25]) .Append("stat", FSecurityHelper.CurrentUserDataGET()[12]) }).GetList(); DataTable dt1 = new DataTable(); if (hidShowInv.Text == "0") { if (hidShowVoid.Text == "1") { ds.Tables[0].DefaultView.RowFilter = "type<>'LINV'"; } else { ds.Tables[0].DefaultView.RowFilter = "type<>'LINV' and (tr_void=0 or tri_TransferFrom>0 or tri_TransferTo>0)"; } } else { if (hidShowVoid.Text == "0") { ds.Tables[0].DefaultView.RowFilter = "tr_void=0 or tri_TransferFrom>0 or tri_TransferTo>0"; } } dt1 = ds.Tables[0].DefaultView.ToTable(); if (ds != null && ds.Tables[0].Rows.Count > 0) { txtLotNo.InnerHtml = "<font color='red'> " + ds.Tables[0].Rows[0]["lotno"].ToString() + "</font>"; txtMawb.InnerHtml = "<font color='red'> " + ds.Tables[0].Rows[0]["mbl"].ToString() + "</font>"; } string[] header = { "Status", "Date", "Type", "No.#", "POL/POD", "WT/Piece", "Amount", "Remark", "Action", "Print" }; string[] field = { "void", "date", "type", "KeyValue", "POL", "WT", "currency|Total", "remark", "Detail", "Print" }; string msg = "No data"; txtcontent.InnerHtml = ControlBinder.gridHtml(dt1, header, field, msg); } }