public ReoGridView(Context ctx, IAttributeSet attrs)
: base(ctx, attrs)
{
this.baseScale = this.Context.Resources.DisplayMetrics.ScaledDensity - 0.5f;
this.sheetTab = new SheetTabView(this, ctx, attrs);
this.AddView(this.sheetTab);
this.worksheetView = new WorksheetView(this, ctx, attrs);
this.AddView(this.worksheetView);
this.adapter = new ReoGridViewAdapter(this);
this.renderer = new AndroidRenderer();
this.InitControl();
this.InitWorkbook(this.adapter);
}
public List <WorksheetView> Worksheet(WorksheetIdModels val)
{
HomeController hc = new HomeController();
List <WorksheetView> ul = new List <WorksheetView>();
using (SqlConnection con = hc.ConnectDatabase())
{
string _SQL = " EXEC [sp_WorkSheet] '" + val.tran_id + "' ";
using (SqlCommand cmd = new SqlCommand(_SQL, con))
{
DataTable _Dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(_Dt);
da.Dispose();
foreach (DataRow _Item in _Dt.Rows)
{
WorksheetView ws = new WorksheetView();
ws.kind = _Item["kind"].ToString();
ws.tran_code = _Item["tran_code"].ToString();
ws.number_po = _Item["number_po"].ToString();
ws.cus_name = _Item["cus_name"].ToString();
ws.branch_name = _Item["branch_name"].ToString();
ws.address = _Item["address"].ToString();
ws.contact_name = _Item["contact_name"].ToString();
ws.position = _Item["position"].ToString();
ws.tel = _Item["tel"].ToString();
ws.source = _Item["source"].ToString();
ws.destination = _Item["destination"].ToString();
ws.station = _Item["station"].ToString();
ws.driver1 = _Item["driver1"].ToString();
ws.driver1_license_start = _Item["driver1_license_start"].ToString();
ws.driver1_license_expire = _Item["driver1_license_expire"].ToString();
ws.driver2 = _Item["driver2"].ToString();
ws.driver2_license_start = _Item["driver2_license_start"].ToString();
ws.driver2_license_expire = _Item["driver2_license_expire"].ToString();
ws.driver3 = _Item["driver3"].ToString();
ws.driver3_license_start = _Item["driver3_license_start"].ToString();
ws.driver3_license_expire = _Item["driver3_license_expire"].ToString();
ws.driver4 = _Item["driver4"].ToString();
ws.driver4_license_start = _Item["driver4_license_start"].ToString();
ws.driver4_license_expire = _Item["driver4_license_expire"].ToString();
ws.license_head = _Item["license_head"].ToString();
ws.style_car_head = _Item["style_car_head"].ToString();
ws.license_tail = _Item["license_tail"].ToString();
ws.style_car_tail = _Item["style_car_tail"].ToString();
ws.doc_code = _Item["doc_code"].ToString();
ws.doc_name = _Item["doc_name"].ToString();
ws.doc_type_id = _Item["doc_type_id"].ToString();
ws.eq_code = _Item["eq_code"].ToString();
ws.eq_name = _Item["eq_name"].ToString();
ws.eq_amount = _Item["eq_amount"].ToString();
ws.product_name = _Item["product_name"].ToString();
ws.fleet = _Item["fleet"].ToString();
ws.method_contain = _Item["method_contain"].ToString();
ws.method_normal = _Item["method_normal"].ToString();
ws.method_special = _Item["method_special"].ToString();
ws.method_style = _Item["method_style"].ToString();
ws.cont1 = _Item["cont1"].ToString();
ws.cont2 = _Item["cont2"].ToString();
ws.remark = _Item["remark"].ToString();
ws.update_by_user_id = _Item["update_by_user_id"].ToString();
ws.update_date = _Item["update_date"].ToString();
ws.Approve_By = _Item["Approve_By"].ToString();
ws.bugget_tran = _Item["bugget_tran"].ToString();
ws.date_work = _Item["date_work"].ToString();
ws.date_start = _Item["date_start"].ToString();
ws.date_end = _Item["date_end"].ToString();
ws.value_order = _Item["value_order"].ToString();
ws.type_tran = _Item["type_tran"].ToString();
ws.size_cont1 = _Item["size_cont1"].ToString();
ws.size_cont2 = _Item["size_cont2"].ToString();
ws.condition_tran = _Item["condition_tran"].ToString();
ws.special_order = _Item["special_order"].ToString();
ws.tank_number = _Item["tank_number"].ToString();
ws.style_tank = _Item["style_tank"].ToString();
ws.weight_tank = _Item["weight_tank"].ToString();
ul.Add(ws);
}
}
con.Close();
}
return(ul);
}
