private void DataBindDDl() { try { DataSet ds = PH_RateCalc.PH_RateCalc_DateWeekSelAll(AppCode.strConnDB); ddlDateWeek.DataTextField = "dateweek"; ddlDateWeek.DataValueField = "dateweek"; ddlDateWeek.DataSource = ds; ddlDateWeek.DataBind(); /*DataTable dt = PH_UserVendor.PH_UserVendor_SelectAll(AppCode.strConnDB); * ddlVendorCode.DataTextField = "vendor_code"; * ddlVendorCode.DataValueField = "vendor_code"; * ddlVendorCode.DataSource = dt; * ddlVendorCode.DataBind();*/ DataTable dt = PH_HaulierInfo.PH_Haulier_SelAll(AppCode.strConnDB); ddlHaluier.DataTextField = "haulier_abbr"; ddlHaluier.DataValueField = "haulier_abbr"; ddlHaluier.DataSource = dt; ddlHaluier.DataBind(); } catch (Exception ex) { lblErr.Text = ex.Message; PH_ExceptionManager.WriteError(ex.Message); } }
public string[] GetHaulierCode(string prefixText) { DataTable dt = PH_HaulierInfo.PH_Haulier_SelAll(AppCode.strConnDB); List <string> items = new List <string>(dt.Rows.Count); for (int i = 0; i < dt.Rows.Count; i++) { string strName = dt.Rows[i]["haulier_taxid"].ToString() + "-" + dt.Rows[i]["haulier_name_en"].ToString() + "-" + dt.Rows[i]["haulier_name_th"].ToString(); items.Add(strName); } return(items.ToArray()); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { if (PHCore_User.SelAllUserName(AppCode.strConnDB, txtUserName.Text).Trim() != "") { lblErrUserName.Text = ConfigurationManager.AppSettings["PH_AddNew_UserName_Err"]; } else if (GetRoleId() == PHCore_Status.RoleID.HL.ToString() && PH_HaulierInfo.PH_Haulier_SelByTaxId(AppCode.strConnDB, txtHaulierCode.Text).Trim() == "") { lblErrHaulierCode.Text = ConfigurationManager.AppSettings["PH_AddNew_Haulier_Err"]; } else { InsertUserProfile(); } } catch (Exception ex) { lblError.Text = ex.Message; PH_ExceptionManager.WriteError(ex.Message); } }