public void Delete(int id) { CRM_CustomerUtility ru = new CRM_CustomerUtility(); //int id = Convert.ToInt32(DeleteTextBox.Text); ru.Delete(id); }
public List <CRM_Customer> Customers() { CRM_CustomerUtility ru = new CRM_CustomerUtility(); List <CRM_Customer> rList = ru.GetCustomers(); return(rList); }
protected void SelectBtn_Click(object sender, EventArgs e) { try { ErrorLab.Text = ""; int id = Convert.ToInt32(CompanyIDTextBox.Text); CRM_CustomerUtility ru = new CRM_CustomerUtility(); List <CRM_Customer> rList = ru.GetCustomer(id); CompanyNameTextBox.Text = rList[0].CompanyName; CompanyAddressTextBox.Text = rList[0].CompanyAddress; CompanyPhoneTextBox.Text = rList[0].CompanyPhone; OfficialWebsiteTextBox.Text = rList[0].OfficialWebsite; ContactPersonTextBox.Text = rList[0].ContactPerson; CP_PhoneTextBox.Text = rList[0].CP_Phone; CP_EmailTextBox.Text = rList[0].CP_Email; CompanyScaleDropDownList.SelectedValue = rList[0].CompanyScale; CompanyCategoryDropDownList.SelectedValue = rList[0].CompanyCategory; } catch (Exception) { ErrorLab.Text = "查無此客戶資料"; CompanyNameTextBox.Text = ""; CompanyAddressTextBox.Text = ""; CompanyPhoneTextBox.Text = ""; OfficialWebsiteTextBox.Text = ""; ContactPersonTextBox.Text = ""; CP_PhoneTextBox.Text = ""; CP_EmailTextBox.Text = ""; CompanyScaleDropDownList.SelectedValue = "未選擇"; CompanyCategoryDropDownList.SelectedValue = "未選擇"; } }
protected void InsertBtn_Click(object sender, EventArgs e) { try { ErrorLab.Text = "客戶資料新增成功"; CRM_Customer r = new CRM_Customer() { CompanyID = Convert.ToInt32(CompanyIDTextBox.Text), CompanyName = CompanyNameTextBox.Text, CompanyAddress = CompanyAddressTextBox.Text, CompanyPhone = CompanyPhoneTextBox.Text, OfficialWebsite = OfficialWebsiteTextBox.Text, ContactPerson = ContactPersonTextBox.Text, CP_Phone = CP_PhoneTextBox.Text, CP_Email = CP_EmailTextBox.Text, CompanyScale = CompanyScaleDropDownList.Text, CompanyCategory = CompanyCategoryDropDownList.Text }; CRM_CustomerUtility ru = new CRM_CustomerUtility(); ru.Insert(r); } catch (Exception) { ErrorLab.Text = "客戶資料格式錯誤或已建立,請確認統編"; } }
protected void InsertCompanyCategorysBtn_Click(object sender, EventArgs e) { CRM_Customer r = new CRM_Customer() { CompanyCategory = InsertCompanyCategorysTextBox.Text }; CRM_CustomerUtility ru = new CRM_CustomerUtility(); ru.InsertCompanyCategorys(r); }
protected void SelectBtn_Click(object sender, EventArgs e) { try { ErrorLab.Text = ""; int id = Convert.ToInt32(CompanyIDTextBox.Text); CRM_CustomerUtility ru = new CRM_CustomerUtility(); List <CRM_Customer> rList = ru.GetCustomer(id); CompanyNameTextBox.Text = rList[0].CompanyName; } catch (Exception) { ErrorLab.Text = "查無此客戶資料"; CompanyNameTextBox.Text = ""; } }
protected void UpdateBtn_Click(object sender, EventArgs e) { CRM_Customer r = new CRM_Customer() { CompanyID = Convert.ToInt32(CompanyID.Text) }; r.CompanyName = CompanyName.Text; r.CompanyAddress = CompanyAddress.Text; r.CompanyPhone = CompanyPhone.Text; r.OfficialWebsite = OfficialWebsite.Text; r.ContactPerson = ContactPerson.Text; r.CP_Phone = CP_Phone.Text; r.CP_Email = CP_Email.Text; r.CompanyScale = CompanyScale.Text; r.CompanyCategory = CompanyCategory.Text; CRM_CustomerUtility ru = new CRM_CustomerUtility(); ru.Update(r); }
protected void UpdateBtn_Click(object sender, EventArgs e) { CRM_Customer r = new CRM_Customer() { CompanyID = Convert.ToInt32(CompanyIDTextBox.Text) }; r.CompanyName = CompanyNameTextBox.Text; r.CompanyAddress = CompanyAddressTextBox.Text; r.CompanyPhone = CompanyPhoneTextBox.Text; r.OfficialWebsite = OfficialWebsiteTextBox.Text; r.ContactPerson = ContactPersonTextBox.Text; r.CP_Phone = CP_PhoneTextBox.Text; r.CP_Email = CP_EmailTextBox.Text; r.CompanyScale = CompanyScaleDropDownList.Text; r.CompanyCategory = CompanyCategoryDropDownList.Text; CRM_CustomerUtility ru = new CRM_CustomerUtility(); ru.Update(r); ErrorLab.Text = "修改客戶資料成功"; }