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