public async Task <HttpResponseMessage> GetLead(int CourseID = 0, string Month = "", string Year = "") { try { if (String.IsNullOrEmpty(Month) || Month == "\"\"") { DateTime dateTime = DateTime.Now; Month = dateTime.ToString("MMM"); } if (String.IsNullOrEmpty(Year) || Year == "\"\"") { DateTime dateTime = DateTime.Now; Year = dateTime.ToString("yyyy"); } EnquiryDAL dal = new EnquiryDAL(); LeadReturn data = await dal.GetLead(CourseID, Month, Year); if (data != null) { return(Request.CreateResponse <LeadReturn>(HttpStatusCode.OK, data)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Constants.ErrorNotFound)); } } catch (DbEntityValidationException ex) { var controllerName = ControllerContext.RouteData.Values["controller"].ToString(); var actionName = ControllerContext.RouteData.Values["action"].ToString(); Logger log = new Logger(); log.ErrorLog(ex, controllerName, actionName); return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Constants.ErrorSysError)); } }
public async Task <HttpResponseMessage> AddLeadActivity(LeadActivityInfo leadActivityInfo) { try { EnquiryDAL dal = new EnquiryDAL(); JsonResponse response = await dal.AddLeadActivity(leadActivityInfo); if (response != null && response.Flag) { return(Request.CreateResponse <JsonResponse>(HttpStatusCode.OK, response)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Constants.ErrorNotFound)); } } catch (DbEntityValidationException ex) { var controllerName = ControllerContext.RouteData.Values["controller"].ToString(); var actionName = ControllerContext.RouteData.Values["action"].ToString(); Logger log = new Logger(); log.ErrorLog(ex, controllerName, actionName); return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Constants.ErrorSysError)); } }
public override void BindControl() { SurveyDAL dal = new SurveyDAL(); var result = dal.GetSurveyBySource(SourceNo, SourceType); string enqNo = string.Empty; List <Survey> surveys2 = new List <Survey>(); Order ord = new Order(); if (string.Equals(SourceType, SysConst.SourceTypeEnquiry, StringComparison.OrdinalIgnoreCase)) { ord = new OrderDAL().GetOrderByEnq(SourceNo); if (ord != null) { surveys2 = dal.GetSurveyBySource(ord.Order_No, SysConst.SourceTypeOrder); } } else if (string.Equals(SourceType, SysConst.SourceTypeOrder, StringComparison.OrdinalIgnoreCase)) { ord = new OrderDAL().GetOrderByNo(SourceNo); if (!string.IsNullOrEmpty(ord.EnqNo)) { var enq = new EnquiryDAL().GetEnquiryByNo(ord.EnqNo); surveys2 = dal.GetSurveyByEnq(enq.Enquiry_No); } } result.AddRange(surveys2); result = result.Distinct(new SurveyComparer()).OrderBy(s => s.Survey_No).ToList(); Utility.BindDataToRepeater(rpSurveyList, result); }
public async Task <HttpResponseMessage> GetLeadByID(int ID) { try { EnquiryDAL dal = new EnquiryDAL(); LeadInfo data = await dal.GetLeadByID(ID); if (data != null) { return(Request.CreateResponse <LeadInfo>(HttpStatusCode.OK, data)); } else { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, Constants.ErrorNotFound)); } } catch (DbEntityValidationException ex) { var controllerName = ControllerContext.RouteData.Values["controller"].ToString(); var actionName = ControllerContext.RouteData.Values["action"].ToString(); Logger log = new Logger(); log.ErrorLog(ex, controllerName, actionName); return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, Constants.ErrorSysError)); } }
public override void BindControl() { RefineDAL dal = new RefineDAL(); var result = dal.GetRefineBySource(SourceType, SourceNo); string enqNo = string.Empty; List <Refine> refines2 = new List <Refine>(); Order ord = new Order(); if (string.Equals(SourceType, SysConst.SourceTypeEnquiry, StringComparison.OrdinalIgnoreCase)) { ord = new OrderDAL().GetOrderByEnq(SourceNo); if (ord != null) { refines2 = dal.GetRefineBySource(SysConst.SourceTypeOrder, ord.Order_No); } } else if (string.Equals(SourceType, SysConst.SourceTypeOrder, StringComparison.OrdinalIgnoreCase)) { ord = new OrderDAL().GetOrderByNo(SourceNo); if (!string.IsNullOrEmpty(ord.EnqNo)) { var enq = new EnquiryDAL().GetEnquiryByNo(ord.EnqNo); refines2 = dal.GetRefineByEnq(enq.Enquiry_No); } } result.AddRange(refines2); result = result.Distinct(new RefineComparer()).OrderBy(r => r.Refine_No).ToList(); Utility.BindDataToRepeater(rpRefinement, result); }
public override void BindControl() { QuotationDAL dal = new QuotationDAL(); var quotes = dal.GetQuotesBySource(SourceType, SourceNo); List <Quotation> quotes2 = new List <Quotation>(); string enqNo = string.Empty; Order ord = new Order(); if (string.Equals(SourceType, SysConst.SourceTypeEnquiry, StringComparison.OrdinalIgnoreCase)) { ord = new OrderDAL().GetOrderByEnq(SourceNo); if (ord != null) { quotes2 = dal.GetQuotesBySource(SysConst.SourceTypeOrder, ord.Order_No); } } else if (string.Equals(SourceType, SysConst.SourceTypeOrder, StringComparison.OrdinalIgnoreCase)) { ord = new OrderDAL().GetOrderByNo(SourceNo); if (!string.IsNullOrEmpty(ord.EnqNo)) { var enq = new EnquiryDAL().GetEnquiryByNo(ord.EnqNo); quotes2 = dal.GetQuoteByEnq(enq.Enquiry_No); } } quotes.AddRange(quotes2); var result = quotes.Distinct(new QuotationComparer()).OrderBy(q => q.Quotation_No); Utility.BindDataToRepeater(rpQuotation, result); }
protected void btnSave_Click(object sender, EventArgs e) { string enqNo = EnqNo; EnquiryDAL dal = new EnquiryDAL(); var enq = dal.GetEnquiryByNo(enqNo); if (!string.IsNullOrEmpty(txtBeginDate.Text)) { enq.ExpectedBeginDate = DateTime.Parse(txtBeginDate.Text); } if (!string.IsNullOrEmpty(txtEndDate.Text)) { enq.ExpectedEndDate = DateTime.Parse(txtEndDate.Text); } //update enq enq.TimeLimitRemark = txtTimeLimitRemark.Text; enq.EnqMan = Utility.GetSelectedText(ddlEnqMan);; enq.Remark = txtRemark.Text; enq.Summary = txtEnqSummary.Text; enq.CustomerCompanyName = customerInfoControl.CompanyName; enq.CustomerContactName = customerInfoControl.ContactName; enq.CustomerAddress = customerInfoControl.Address; enq.CustomerEmail = customerInfoControl.Email; enq.CustomerQQ = customerInfoControl.QQ; enq.CustomerPhone1 = customerInfoControl.Phone1; enq.CustomerPhone2 = customerInfoControl.Phone2; enq.CustomerOthers = customerInfoControl.Other; enq.EnquiryImgPath = enquiryImageControl.ImagePath; enq.IsSampleProvidedToCustomer = SampleControl1.IsSampleProvidedToCustomer; enq.IsCustomerProvideSample = SampleControl1.IsSampleFromCustomer; enq.IsCustomerProvideImage = customerDrawingControl.IsCustomerProvideImage; enq.IsSurveyNeeded = SurveyEditControl1.IsSurveyNeed; if (SurveyEditControl1.IsSurveyNeed) { enq.SurveyType = SurveyEditControl1.SurveyType; enq.SurveyIntro = SurveyEditControl1.SurveyIntro; } enq.IsCADRefinementNeeded = CADEditControl1.IsCADRefinementNeeded; if (CADEditControl1.IsCADRefinementNeeded) { enq.CADRefinementIntro = CADEditControl1.RefineIntro; enq.IsCADNeedCustomerConfirmation = CADEditControl1.IsCustomerCADConfirmationNeeded; } enq.DeliveryType = DeliveryEditControl1.DeliveryType; enq.DeliveryIntro = DeliveryEditControl1.DeliveryIntro; enq.DeliveryToAddress = DeliveryEditControl1.DeliveryToAddress; enq.IsInstallProvided = InstallEditControl1.IsInstallProvided; if (InstallEditControl1.IsInstallProvided) { enq.InstallType = InstallEditControl1.InstallType; enq.InstallIntro = InstallEditControl1.InstallIntro; } AddFollowUp(followUpControl, enq.Status, Utility.GetSelectedText(ddlEnquiryStatus)); enq.Status = ddlEnquiryStatus.SelectedItem.Text; dal.Save(); //save new customer customerInfoControl.Save(); this.SetFocus(sender); }
private List <Enquiry> GetEnquiryList() { string enqNo = txtEnqNo.Text; string companyName = Utility.GetSelectedText(ddlCompany); string contactName = Utility.GetSelectedText(ddlContact); string phone = txtPhone.Text; DateTime beginDate = string.IsNullOrWhiteSpace(txtBeginDate.Text) ? DateTime.MinValue : DateTime.Parse(txtBeginDate.Text); DateTime endDate = string.IsNullOrWhiteSpace(txtEndDate.Text) ? DateTime.MaxValue : DateTime.Parse(txtEndDate.Text); string status = string.Empty; if (ddlEnqStatus.SelectedItem != null) { status = ddlEnqStatus.SelectedItem.Text; } string enqMan = Utility.GetSelectedText(ddlEnqMan); EnquiryDAL dal = new EnquiryDAL(); var enqList = dal.SearchEnquiry( enqNo, companyName, contactName, phone, beginDate, endDate, string.Empty, status, enqMan); return(enqList); }
private void BindData() { EnquiryDAL dal = new EnquiryDAL(); var enq = dal.GetEnquiryByNo(EnqNo); lblDate.Text = enq.CreatedDate.ToString("yyyy-MM-dd"); lblContactName.Text = enq.CustomerContactName; if (!string.IsNullOrEmpty(enq.CustomerPhone1) && !string.IsNullOrEmpty(enq.CustomerPhone2)) { lblPhone.Text = enq.CustomerPhone1 + "/" + enq.CustomerPhone2; } else { lblPhone.Text = enq.CustomerPhone1 + enq.CustomerPhone2; } lblEmail.Text = enq.CustomerEmail; lblQQ.Text = enq.CustomerQQ; lblAddress.Text = enq.CustomerAddress; lblIsCustomerProvideImage.Text = enq.IsCustomerProvideImage ? YesNoConsts.Yes : YesNoConsts.No; lblSampleToCustomer.Text = enq.IsSampleProvidedToCustomer ? YesNoConsts.Yes : YesNoConsts.No; if (enq.IsSampleProvidedToCustomer) { lblTextSampleCode.Visible = true; lblSampleToCustomer.Visible = true; lblSampleCode.Visible = true; SampleProvidDAL sdal = new SampleProvidDAL(); var samples = sdal.GetSampleBySource(SysConst.SourceTypeEnquiry, EnqNo); StringBuilder sb = new StringBuilder(); foreach (var item in samples) { sb.Append(item.SampleName).Append(","); } if (sb.Length > 0) { sb.Remove(sb.Length - 1, 1); } lblSampleCode.Text = sb.ToString(); } lblSurveyNeeded.Text = enq.IsSurveyNeeded ? YesNoConsts.Yes : YesNoConsts.No; if (enq.IsSurveyNeeded) { lblSurveyType.Text = enq.SurveyType; } lblProvideRefine.Text = enq.IsCADRefinementNeeded ? YesNoConsts.Yes : YesNoConsts.No; lblProvideDelivery.Text = enq.DeliveryType; lblDeliveryType.Text = enq.DeliveryType; lblDeliveryAddress.Text = enq.DeliveryToAddress; lblProvideInstall.Text = enq.IsInstallProvided ? YesNoConsts.Yes : YesNoConsts.No; lblInstallType.Text = enq.InstallType; //item LineItemDAL lDAL = new LineItemDAL(); var items = lDAL.GetLineItemsBySource(enq.Enquiry_Id, SysConst.SourceTypeEnquiry); Utility.BindDataToRepeater(rpItems, items); //bankinfo Utility.BindDataToDropdown(ddlBankInfo, Utility.GetLookupList("账户列表")); SetBankInfo(); }
public void btnChangeStatus_OnClick(object sender, EventArgs e) { int enqId = int.Parse(GetQueryStringValue("enqid")); EnquiryDAL dal = new EnquiryDAL(); var enq = dal.GetEnquiryById(enqId); AddFollowUp(followUpControl, enq.Status, Utility.GetSelectedText(ddlEnquiryStatus)); enq.Status = this.ddlEnquiryStatus.SelectedItem.Text; dal.Save(); SetFocus(sender); }
protected void btnUpload_Click(object sender, EventArgs e) { string serverFilePath = string.Empty; Utility.UploadFile(fileUploadEnqImg, "EnquiryImage", SourceNo, ref serverFilePath); ImagePath = serverFilePath; EnquiryDAL dal = new EnquiryDAL(); var enq = dal.GetEnquiryById(EnquiryId); enq.EnquiryImgPath = serverFilePath; dal.Save(); BindControl(); }
protected void btnUpdateEnqNo_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtEnqNo.Text)) { EnquiryDAL dal = new EnquiryDAL(); Enquiry enq = dal.GetEnquiryById(EnqId); var dbEnq = dal.GetEnquiryByNo(txtEnqNo.Text); if (dbEnq != null && dbEnq.Enquiry_Id != EnqId) { ClientScript.RegisterClientScriptBlock(this.GetType(), "updateno", "<script>alert('已经有相同咨询单号!');</script>"); } else { enq.Enquiry_No = txtEnqNo.Text; dal.Save(); } } }
protected void btnCreate_Click(object sender, EventArgs e) { SeedDAL sdal = new SeedDAL(); string no = sdal.GetNoByTableName(SysConst.TableNameEnquiry, SysConst.SuffixEnquiry); Enquiry item = new Enquiry() { Enquiry_No = no, Status = FirstStatusConsts.Enquiry, CreatedAt = DateTime.Now, CreatedDate = DateTime.Now, CreatedBy = SMSContext.Current.User.UserName }; EnquiryDAL dal = new EnquiryDAL(); dal.AddEnquiry(item); dal.Save(); int enqId = item.Enquiry_Id; string enqNo = item.Enquiry_No; Utility.AddDefault(item.Enquiry_No, SysConst.SourceTypeEnquiry, FooterConsts.Enquiry); string script = string.Format("<script>window.open('enquiryform.aspx?enqid={0}&enqno={1}')</script>", enqId, enqNo); ClientScript.RegisterClientScriptBlock(this.GetType(), "createenq", script); }
protected void btnGenerateOrder_Click(object sender, EventArgs e) { Enquiry enq = new EnquiryDAL().GetEnquiryByNo(GetQueryStringValue("enqno")); OrderDAL dal = new OrderDAL(); var order = dal.GetOrderByEnq(enq.Enquiry_No); if (order != null) { ClientScript.RegisterClientScriptBlock(this.GetType(), "generateorder", string.Format("<script>window.open('OrderForm.aspx?ordid={0}&ordno={1}&sourcetype=E&sourceno={2}')</script>", order.Order_Id, order.Order_No, enq.Enquiry_No)); return; } SeedDAL sdal = new SeedDAL(); LineItemDAL lDAL = new LineItemDAL(); var no = sdal.GetNoByTableName(SysConst.TableOrder, SysConst.SuffixOrder); var enqItems = lDAL.GetLineItemsBySource(enq.Enquiry_Id, SysConst.SourceTypeEnquiry); Order ord = new Order(); ord.SourceType = SysConst.SourceTypeEnquiry; ord.SourceNo = enq.Enquiry_No; ord.Order_No = no; ord.Status = FirstStatusConsts.Order; ord.CreatedDate = DateTime.Now; ord.CustomerAddress = enq.CustomerAddress; ord.CustomerCompanyName = enq.CustomerCompanyName; ord.CustomerContactName = enq.CustomerContactName; ord.CustomerEmail = enq.CustomerEmail; ord.CustomerOthers = enq.CustomerOthers; ord.CustomerPhone1 = enq.CustomerPhone1; ord.CustomerPhone2 = enq.CustomerPhone2; ord.CustomerQQ = enq.CustomerQQ; ord.IsSampleProvidedToCustomer = enq.IsSampleProvidedToCustomer; ord.IsCustomerProvideSample = enq.IsCustomerProvideSample; ord.IsCustomerProvideImage = enq.IsCustomerProvideImage; ord.IsSurveyNeeded = enq.IsSurveyNeeded; ord.SurveyType = enq.SurveyType; ord.SurveyIntro = enq.SurveyIntro; ord.IsCADRefinementNeeded = enq.IsCADRefinementNeeded; ord.CADRefinementIntro = enq.CADRefinementIntro; ord.IsCADNeedCustomerConfirmation = enq.IsCADNeedCustomerConfirmation; ord.DeliveryType = enq.DeliveryType; ord.DeliveryIntro = enq.DeliveryIntro; ord.DeliveryToAddress = enq.DeliveryToAddress; ord.IsInstallProvided = enq.IsInstallProvided; ord.InstallType = string.IsNullOrEmpty(enq.InstallType) ? string.Empty : enq.InstallType; ord.InstallIntro = enq.InstallIntro; ord.EnqNo = enq.Enquiry_No; ord.IsActive = true; dal.AddOrder(ord); dal.Save(); //intro Utility.AddDefault(ord.Order_No, SysConst.SourceTypeOrder, FooterConsts.Order); //item foreach (var item in enqItems) { LineItem newItem = new LineItem() { Intro = item.Intro, Name = item.Name, Project = item.Project, Quantity = item.Quantity, Remark = item.Remark, SourceId = ord.Order_Id, SourceType = SysConst.SourceTypeOrder, Spec = item.Spec, Unit = item.Unit, UnitPrice = item.UnitPrice }; lDAL.AddLineItem(newItem); } lDAL.Save(); ClientScript.RegisterClientScriptBlock(this.GetType(), "generateorder", string.Format("<script>window.open('OrderForm.aspx?ordid={0}&ordno={1}&sourcetype=E&sourceno={2}')</script>", ord.Order_Id, ord.Order_No, enq.Enquiry_No)); }
protected void btnCreateQuotation_Click(object sender, EventArgs e) { //get no SeedDAL sdal = new SeedDAL(); string no = sdal.GetNoByTableName(SysConst.TableNameQuotation, SysConst.SuffixQuotation); //get enqordman string enqOrdMan = string.Empty; string companyName = string.Empty; string contact = string.Empty; string address = string.Empty; string email = string.Empty; string qq = string.Empty; string phone1 = string.Empty; string phone2 = string.Empty; string other = string.Empty; bool isSampleToCustomer = false; bool isSampleFromCustomer = false; bool isCustomerProvideImg = false; bool isSurveyNeed = false; string surveyType = string.Empty; string surveyIntro = string.Empty; bool isCADRefineNeeded = false; string refineIntro = string.Empty; bool isCustomerConfirmNeeded = false; string deliveryType = string.Empty; string deliveryIntro = string.Empty; string deliveryAdd = string.Empty; bool isInstallProvided = false; string installType = string.Empty; string insallIntro = string.Empty; string enqNo = string.Empty; List <LineItem> items = new List <LineItem>(); int sourceId = -1; if (string.Equals(SourceType, SysConst.SourceTypeSalesOrder, StringComparison.OrdinalIgnoreCase)) { OrderDAL soDAL = new OrderDAL(); var so = soDAL.GetOrderByNo(SourceNo); so.Status = "申请报价"; soDAL.Save(); OnQuotationCreated(so.Status, EventArgs.Empty); enqOrdMan = so.OrderMan; companyName = so.CustomerCompanyName; contact = so.CustomerContactName; address = so.CustomerAddress; email = so.CustomerEmail; qq = so.CustomerQQ; phone1 = so.CustomerPhone1; phone2 = so.CustomerPhone2; other = so.CustomerOthers; isSampleToCustomer = so.IsSampleProvidedToCustomer; isSampleFromCustomer = so.IsCustomerProvideSample; isCustomerProvideImg = so.IsCustomerProvideImage; isSurveyNeed = so.IsSurveyNeeded; surveyType = so.SurveyType; surveyIntro = so.SurveyIntro; isCADRefineNeeded = so.IsCADRefinementNeeded; refineIntro = so.CADRefinementIntro; isCustomerConfirmNeeded = so.IsCADNeedCustomerConfirmation; deliveryType = so.DeliveryType; deliveryIntro = so.DeliveryIntro; deliveryAdd = so.DeliveryToAddress; isInstallProvided = so.IsInstallProvided; installType = string.IsNullOrEmpty(so.InstallType) ?string.Empty : so.InstallType; insallIntro = so.InstallIntro; enqNo = so.EnqNo; sourceId = so.Order_Id; } else if (string.Equals(SourceType, SysConst.SourceTypeEnquiry, StringComparison.OrdinalIgnoreCase)) { EnquiryDAL enqDAL = new EnquiryDAL(); var enq = enqDAL.GetEnquiryByNo(SourceNo); enqOrdMan = enq.EnqMan; companyName = enq.CustomerCompanyName; contact = enq.CustomerContactName; address = enq.CustomerAddress; email = enq.CustomerEmail; qq = enq.CustomerQQ; phone1 = enq.CustomerPhone1; phone2 = enq.CustomerPhone2; other = enq.CustomerOthers; isSampleToCustomer = enq.IsSampleProvidedToCustomer; isSampleFromCustomer = enq.IsCustomerProvideSample; isCustomerProvideImg = enq.IsCustomerProvideImage; isSurveyNeed = enq.IsSurveyNeeded; surveyType = enq.SurveyType; surveyIntro = enq.SurveyIntro; isCADRefineNeeded = enq.IsCADRefinementNeeded; refineIntro = enq.CADRefinementIntro; isCustomerConfirmNeeded = enq.IsCADNeedCustomerConfirmation; deliveryType = enq.DeliveryType; deliveryIntro = enq.DeliveryIntro; deliveryAdd = enq.DeliveryToAddress; isInstallProvided = enq.IsInstallProvided; installType = string.IsNullOrEmpty(enq.InstallType) ? string.Empty : enq.InstallType; insallIntro = enq.InstallIntro; enqNo = SourceNo; sourceId = enq.Enquiry_Id; //update enq status enq.Status = "申请报价"; enqDAL.Save(); } //new quote QuotationDAL dal = new QuotationDAL(); Quotation quote = new Quotation() { Quotation_No = no, Status = FirstStatusConsts.Quotation, EnqOrdMan = enqOrdMan, SourceType = SourceType, SourceNo = SourceNo, CreatedDate = DateTime.Now, CreatedAt = DateTime.Now, CreatedBy = SMSContext.Current.User.UserName, CustomerCompanyName = companyName, CustomerContactName = contact, CustomerAddress = address, CustomerEmail = email, CustomerQQ = qq, CustomerPhone1 = phone1, CustomerPhone2 = phone2, CustomerOthers = other, IsSampleProvidedToCustomer = isSampleToCustomer, IsCustomerProvideSample = isSampleFromCustomer, IsCustomerProvideImage = isCustomerProvideImg, IsSurveyNeeded = isSurveyNeed, SurveyType = surveyType, SurveyIntro = surveyIntro, IsCADRefinementNeeded = isCADRefineNeeded, CADRefinementIntro = refineIntro, IsCADNeedCustomerConfirmation = isCustomerConfirmNeeded, DeliveryType = deliveryType, DeliveryIntro = deliveryIntro, DeliveryToAddress = deliveryAdd, IsInstallProvided = isInstallProvided, InstallType = installType, InstallIntro = insallIntro, EnqNo = enqNo }; dal.AddQuote(quote); dal.Save(); LineItemDAL lDAL = new LineItemDAL(); items = lDAL.GetLineItemsBySource(sourceId, SourceType); foreach (var item in items) { LineItem target = new LineItem() { Intro = item.Intro, Name = item.Name, OriginNo = item.OriginNo, Project = item.Project, Quantity = item.Quantity, Remark = item.Remark, SourceId = quote.Quotation_Id, SourceType = SysConst.SourceTypeQuote, Spec = item.Spec, Unit = item.Unit, UnitPrice = item.UnitPrice }; lDAL.AddLineItem(target); } lDAL.Save(); int quoId = quote.Quotation_Id; string quoNo = quote.Quotation_No; Utility.AddDefault(quote.Quotation_No, SysConst.SourceTypeQuote, FooterConsts.Quotation); string url = Page.ResolveUrl(string.Format("~/QuotationForm.aspx?quoid={0}&quono={1}&sourcetype={2}&sourceno={3}", quoId, quoNo, SourceType, SourceNo)); string script = string.Format("<script>window.open('{0}')</script>", url); Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "createquote", script); BindControl(); SetFocus(btnCreateQuotation); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //dropdown Utility.BindDataToDropdown(ddlEnquiryStatus, Utility.GetEnquiryStatusList()); Utility.BindDataToDropdown(ddlEnqMan, Utility.GetUserList2(true)); if (!string.IsNullOrWhiteSpace(EnqNo)) { EnquiryDAL dal = new EnquiryDAL(); var enq = dal.GetEnquiryById(EnqId); txtEnqNo.Text = enq.Enquiry_No; this.txtCreatedDate.Text = enq.CreatedDate.ToString("yyyy-MM-dd"); this.txtRemark.Text = enq.Remark; this.txtBeginDate.Text = enq.ExpectedBeginDate != null?enq.ExpectedBeginDate.Value.ToString("yyyy-MM-dd") : string.Empty; this.txtEndDate.Text = enq.ExpectedEndDate != null?enq.ExpectedEndDate.Value.ToString("yyyy-MM-dd") : string.Empty; this.txtTimeLimitRemark.Text = enq.TimeLimitRemark; this.lblStatus.Text = enq.Status; this.ddlEnqMan.SelectedValue = enq.EnqMan; this.txtEnqSummary.Text = enq.Summary; //customer info this.customerInfoControl.SetValue( enq.CustomerCompanyName, enq.CustomerContactName, enq.CustomerAddress, enq.CustomerEmail, enq.CustomerQQ, enq.CustomerPhone1, enq.CustomerPhone2, enq.CustomerOthers); //enq content UIUtility.BindUserControl(lineItemsControl, SysConst.SourceTypeEnquiry, enq.Enquiry_Id); //enq img enquiryImageControl.ImagePath = enq.EnquiryImgPath; enquiryImageControl.EnquiryId = enq.Enquiry_Id; UIUtility.BindUserControl(enquiryImageControl, SysConst.SourceTypeSurvey, enq.Enquiry_No); //sample this.SampleControl1.SetValue(enq.IsSampleProvidedToCustomer, enq.IsCustomerProvideSample); UIUtility.BindUserControl(SampleControl1, SysConst.SourceTypeEnquiry, enq.Enquiry_No); //customer drawing customerDrawingControl.IsCustomerProvideImage = enq.IsCustomerProvideImage; UIUtility.BindUserControl(customerDrawingControl, SysConst.SourceTypeEnquiry, enq.Enquiry_No); //survey SurveyEditControl1.IsSurveyNeed = enq.IsSurveyNeeded; SurveyEditControl1.SurveyIntro = enq.SurveyIntro; UIUtility.BindUserControl(SurveyEditControl1, SysConst.SourceTypeEnquiry, enq.Enquiry_No); SurveyEditControl1.SetSurveyType(enq.SurveyType); //cad CADEditControl1.IsCADRefinementNeeded = enq.IsCADRefinementNeeded; CADEditControl1.RefineIntro = enq.CADRefinementIntro; CADEditControl1.IsCustomerCADConfirmationNeeded = enq.IsCADNeedCustomerConfirmation; UIUtility.BindUserControl(CADEditControl1, SysConst.SourceTypeEnquiry, enq.Enquiry_No); //delivery DeliveryEditControl1.DeliveryIntro = enq.DeliveryIntro; DeliveryEditControl1.DeliveryToAddress = enq.DeliveryToAddress; UIUtility.BindUserControl(DeliveryEditControl1, SysConst.SourceTypeEnquiry, enq.Enquiry_No); DeliveryEditControl1.SetDeliveryType(enq.DeliveryType); //install InstallEditControl1.IsInstallProvided = enq.IsInstallProvided; InstallEditControl1.InstallIntro = enq.InstallIntro; UIUtility.BindUserControl(InstallEditControl1, SysConst.SourceTypeEnquiry, enq.Enquiry_No); InstallEditControl1.SetInstallType(enq.InstallType); //quote UIUtility.BindUserControl(quotationControl, SysConst.SourceTypeEnquiry, enq.Enquiry_No); //survey UIUtility.BindUserControl(surveyControl, SysConst.SourceTypeEnquiry, enq.Enquiry_No); //refine UIUtility.BindUserControl(cADRefinementControl, SysConst.SourceTypeEnquiry, enq.Enquiry_No); //intro UIUtility.BindUserControl(FooterIntroControl1, SysConst.SourceTypeEnquiry, enq.Enquiry_No); //status ddlEnquiryStatus.SelectedValue = enq.Status; //followup UIUtility.BindUserControl(followUpControl, SysConst.SourceTypeEnquiry, enq.Enquiry_No); } } }
protected void btnCreateCADRefinement_Click(object sender, EventArgs e) { //get no SeedDAL sdal = new SeedDAL(); string no = sdal.GetNoByTableName(SysConst.TableRefine, SysConst.SuffixRefine); //get enqordman string enqOrdMan = string.Empty; string companyName = string.Empty; string contact = string.Empty; string address = string.Empty; string email = string.Empty; string qq = string.Empty; string phone1 = string.Empty; string phone2 = string.Empty; string other = string.Empty; string enqNo = string.Empty; if (string.Equals(SourceType, SysConst.SourceTypeEnquiry, StringComparison.OrdinalIgnoreCase)) { EnquiryDAL enqDAL = new EnquiryDAL(); var enq = enqDAL.GetEnquiryByNo(SourceNo); enqOrdMan = enq.EnqMan; companyName = enq.CustomerCompanyName; contact = enq.CustomerContactName; address = enq.CustomerAddress; email = enq.CustomerEmail; qq = enq.CustomerQQ; phone1 = enq.CustomerPhone1; phone2 = enq.CustomerPhone2; other = enq.CustomerOthers; enqNo = SourceNo; //update enq status enq.Status = "申请CAD细化"; enqDAL.Save(); } if (string.Equals(SourceType, SysConst.SourceTypeSalesOrder, StringComparison.OrdinalIgnoreCase)) { OrderDAL soDAL = new OrderDAL(); var so = soDAL.GetOrderByNo(SourceNo); enqOrdMan = so.OrderMan; companyName = so.CustomerCompanyName; contact = so.CustomerContactName; address = so.CustomerAddress; email = so.CustomerEmail; qq = so.CustomerQQ; phone1 = so.CustomerPhone1; phone2 = so.CustomerPhone2; other = so.CustomerOthers; enqNo = so.EnqNo; //update enq status so.Status = "申请CAD细化"; soDAL.Save(); } //new refine RefineDAL dal = new RefineDAL(); Refine refine = new Refine() { Refine_No = no, Status = FirstStatusConsts.Refine, EnqOrdMan = enqOrdMan, SourceType = SourceType, SourceNo = SourceNo, CreatedDate = DateTime.Now, CreatedAt = DateTime.Now, CreatedBy = SMSContext.Current.User.UserName, CustomerCompanyName = companyName, CustomerContactName = contact, CustomerAddress = address, CustomerEmail = email, CustomerQQ = qq, CustomerPhone1 = phone1, CustomerPhone2 = phone2, CustomerOthers = other, EnqNo = enqNo }; dal.AddRefine(refine); dal.Save(); int refid = refine.Refine_Id; string refno = refine.Refine_No; string url = Page.ResolveUrl(string.Format("~/RefineForm.aspx?refid={0}&refno={1}&sourcetype={2}&sourceno={3}", refid, refno, SourceType, SourceNo)); string script = string.Format("<script>window.open('{0}')</script>", url); Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "createrefine", script); BindControl(); SetFocus(btnCreateCADRefinement); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Utility.BindDataToDropdown(ddlSurveyStatus, Utility.GetSurveyStatusList()); Utility.BindDataToDropdown(ddlEnqOrdMan, Utility.GetUserList2(true)); Utility.BindDataToDropdown(ddlSurveyMan, Utility.GetUserList2(true)); if (!string.IsNullOrEmpty(SourceType) && !string.IsNullOrEmpty(SourceNo)) { //link if (string.Equals(SourceType, SysConst.SourceTypeEnquiry, StringComparison.OrdinalIgnoreCase)) { EnquiryDAL eDAL = new EnquiryDAL(); var enq = eDAL.GetEnquiryByNo(SourceNo); lnkSource.NavigateUrl = Page.ResolveUrl(string.Format("~/enquiryform.aspx?enqno={0}&enqid={1}", SourceNo, enq.Enquiry_Id)); } else { OrderDAL sDAL = new OrderDAL(); var ord = sDAL.GetOrderByNo(SourceNo); lnkSource.NavigateUrl = Page.ResolveUrl(string.Format("~/orderform.aspx?ordno={0}&ordid={1}&sourcetype={2}&sourceno={3}", SourceNo, ord.Order_Id, ord.SourceType, ord.SourceNo)); } lnkSource.Text = SourceNo; SurveyDAL dal = new SurveyDAL(); var survey = dal.GetSurveyById(SVId); //basic txtCreatedDate.Text = survey.CreatedDate.ToString("yyyy-MM-dd"); ddlEnqOrdMan.SelectedValue = survey.EnqOrdMan; txtExpectedSurveyDate.Text = survey.ExpectedSurveyDate != null?survey.ExpectedSurveyDate.Value.ToString("yyyy-MM-dd") : string.Empty; txtOnsiteContactName.Text = survey.OnSiteContactName; txtOnsiteContactPhone.Text = survey.OnSiteContactPhone; txtSurveyIntro.Text = survey.SurveyIntro; ddlSurveyMan.SelectedValue = survey.SurveyMan; //goods bring Utility.BindDataToCheckBoxList(chklToos, Utility.GetLookupList("测量物品")); string goods = survey.GoodsBring; if (!string.IsNullOrEmpty(goods)) { foreach (ListItem item in chklToos.Items) { if (goods.Contains(item.Text)) { item.Selected = true; } } } //customer info this.customerInfoControl.SetValue( survey.CustomerCompanyName, survey.CustomerContactName, survey.CustomerAddress, survey.CustomerEmail, survey.CustomerQQ, survey.CustomerPhone1, survey.CustomerPhone2, survey.CustomerOthers); //line content LineItemsControl1.SourceId = survey.Survey_Id; UIUtility.BindUserControl(LineItemsControl1, SysConst.SourceTypeDelivery, survey.Survey_No); //history survey LineItemsControl1.IsPriceColumnVisible = false; LineItemsControl1.IsFooterVisible = false; LineItemsControl1.SourceId = survey.Survey_Id; UIUtility.BindUserControl(LineItemsControl1, SysConst.SourceTypeSurvey, survey.Survey_No); //cad refine UIUtility.BindUserControl(cADRefinementControl, SourceType, SourceNo); //customer drawing UIUtility.BindUserControl(customerDrawingControl, SourceType, SourceNo); //refine UIUtility.BindUserControl(surveyControl, SourceType, SourceNo); //survey data if (!string.IsNullOrEmpty(survey.SurveyImagePath)) { imgSurveyData.ImageUrl = Page.ResolveUrl(survey.SurveyImagePath); imgSurveyData.AlternateText = survey.SurveyImageName; } //followup UIUtility.BindUserControl(followUpControl, SysConst.SourceTypeSurvey, survey.Survey_No); //status dropdown ddlSurveyStatus.SelectedValue = survey.Status; } } }
protected void btnCreateSurvey_Click(object sender, EventArgs e) { //get no SeedDAL sdal = new SeedDAL(); string no = sdal.GetNoByTableName(SysConst.TableSurvey, SysConst.SuffixSuvey); //get enqordman string enqOrdMan = string.Empty; string companyName = string.Empty; string contact = string.Empty; string address = string.Empty; string email = string.Empty; string qq = string.Empty; string phone1 = string.Empty; string phone2 = string.Empty; string other = string.Empty; string surveyIntro = string.Empty; string enqNo = string.Empty; List <LineItem> items = new List <LineItem>(); int sourceId = -1; if (string.Equals(SourceType, SysConst.SourceTypeEnquiry, StringComparison.OrdinalIgnoreCase)) { EnquiryDAL enqDAL = new EnquiryDAL(); var enq = enqDAL.GetEnquiryByNo(SourceNo); enqOrdMan = enq.EnqMan; companyName = enq.CustomerCompanyName; contact = enq.CustomerContactName; address = enq.CustomerAddress; email = enq.CustomerEmail; qq = enq.CustomerQQ; phone1 = enq.CustomerPhone1; phone2 = enq.CustomerPhone2; other = enq.CustomerOthers; surveyIntro = enq.SurveyIntro; enqNo = SourceNo; sourceId = enq.Enquiry_Id; //update enq status enq.Status = "申请测量"; enqDAL.Save(); } if (string.Equals(SourceType, SysConst.SourceTypeSalesOrder, StringComparison.OrdinalIgnoreCase)) { OrderDAL soDAL = new OrderDAL(); var so = soDAL.GetOrderByNo(SourceNo); enqOrdMan = so.OrderMan; companyName = so.CustomerCompanyName; contact = so.CustomerContactName; address = so.CustomerAddress; email = so.CustomerEmail; qq = so.CustomerQQ; phone1 = so.CustomerPhone1; phone2 = so.CustomerPhone2; other = so.CustomerOthers; surveyIntro = so.SurveyIntro; enqNo = so.EnqNo; sourceId = so.Order_Id; //update ord status so.Status = "申请测量"; soDAL.Save(); } //new refine SurveyDAL dal = new SurveyDAL(); Survey survey = new Survey() { Survey_No = no, Status = FirstStatusConsts.Survey, EnqOrdMan = enqOrdMan, SourceType = SourceType, SourceNo = SourceNo, CreatedDate = DateTime.Now, CreatedAt = DateTime.Now, CreatedBy = SMSContext.Current.User.UserName, CustomerCompanyName = companyName, CustomerContactName = contact, CustomerAddress = address, CustomerEmail = email, CustomerQQ = qq, CustomerPhone1 = phone1, CustomerPhone2 = phone2, CustomerOthers = other, SurveyIntro = surveyIntro, EnqNo = enqNo }; dal.AddSurvey(survey); dal.Save(); LineItemDAL lDAL = new LineItemDAL(); items = lDAL.GetLineItemsBySource(sourceId, SourceType); foreach (var item in items) { LineItem target = new LineItem() { Intro = item.Intro, Name = item.Name, OriginNo = item.OriginNo, Project = item.Project, Quantity = item.Quantity, Remark = item.Remark, SourceId = survey.Survey_Id, SourceType = SysConst.SourceTypeSurvey, Spec = item.Spec, Unit = item.Unit, UnitPrice = item.UnitPrice }; lDAL.AddLineItem(target); } lDAL.Save(); int svid = survey.Survey_Id; string svno = survey.Survey_No; string url = Page.ResolveUrl(string.Format("~/SurveyForm.aspx?svid={0}&svno={1}&sourcetype={2}&sourceno={3}", svid, svno, SourceType, SourceNo)); string script = string.Format("<script>window.open('{0}')</script>", url); Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "createsuvey", script); BindControl(); SetFocus(btnCreateSurvey); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (!string.IsNullOrEmpty(SourceType) && !string.IsNullOrEmpty(SourceNo)) { Utility.BindDataToDropdown(ddlEnqOrdMan, Utility.GetUserList2(true)); Utility.BindDataToDropdown(ddlQuoteMan, Utility.GetUserList2(true)); //link if (string.Equals(SourceType, SysConst.SourceTypeEnquiry, StringComparison.OrdinalIgnoreCase)) { EnquiryDAL eDAL = new EnquiryDAL(); var enq = eDAL.GetEnquiryByNo(SourceNo); lnkSource.NavigateUrl = Page.ResolveUrl(string.Format("~/enquiryform.aspx?enqno={0}&enqid={1}", SourceNo, enq.Enquiry_Id)); } else { OrderDAL sDAL = new OrderDAL(); var ord = sDAL.GetOrderByNo(SourceNo); lnkSource.NavigateUrl = Page.ResolveUrl(string.Format("~/orderform.aspx?ordno={0}&ordid={1}&sourcetype={2}&sourceno={3}", SourceNo, ord.Order_Id, ord.SourceType, ord.SourceNo)); } lnkSource.Text = SourceNo; QuotationDAL dal = new QuotationDAL(); var quote = dal.GetQuoteByNo(QuoteNo); //basic txtCreatedDate.Text = quote.CreatedDate.ToString("yyyy-MM-dd"); ddlEnqOrdMan.SelectedValue = quote.EnqOrdMan; ddlQuoteMan.SelectedValue = quote.QuotationMan; txtQuoteIntro.Text = quote.QuotationIntro; //customer info this.customerInfoControl.SetValue( quote.CustomerCompanyName, quote.CustomerContactName, quote.CustomerAddress, quote.CustomerEmail, quote.CustomerQQ, quote.CustomerPhone1, quote.CustomerPhone2, quote.CustomerOthers); //lineitem UIUtility.BindUserControl(lineItemsControl, SysConst.SourceTypeQuote, quote.Quotation_Id); //sample this.SampleControl1.SetValue(quote.IsSampleProvidedToCustomer, quote.IsCustomerProvideSample); UIUtility.BindUserControl(SampleControl1, SysConst.SourceTypeQuote, quote.Quotation_No); //customer drawing customerDrawingControl.IsCustomerProvideImage = quote.IsCustomerProvideImage; UIUtility.BindUserControl(customerDrawingControl, SysConst.SourceTypeQuote, quote.Quotation_No); //survey SurveyEditControl1.IsSurveyNeed = quote.IsSurveyNeeded; SurveyEditControl1.SurveyIntro = quote.SurveyIntro; UIUtility.BindUserControl(SurveyEditControl1, SysConst.SourceTypeQuote, quote.Quotation_No); SurveyEditControl1.SetSurveyType(quote.SurveyType); //cad CADEditControl1.IsCADRefinementNeeded = quote.IsCADRefinementNeeded; CADEditControl1.RefineIntro = quote.CADRefinementIntro; CADEditControl1.IsCustomerCADConfirmationNeeded = quote.IsCADNeedCustomerConfirmation; UIUtility.BindUserControl(CADEditControl1, SysConst.SourceTypeQuote, quote.Quotation_No); //delivery DeliveryEditControl1.DeliveryIntro = quote.DeliveryIntro; DeliveryEditControl1.DeliveryToAddress = quote.DeliveryToAddress; UIUtility.BindUserControl(DeliveryEditControl1, SysConst.SourceTypeQuote, quote.Quotation_No); DeliveryEditControl1.SetDeliveryType(quote.DeliveryType); //install InstallEditControl1.IsInstallProvided = quote.IsInstallProvided; InstallEditControl1.InstallIntro = quote.InstallIntro; UIUtility.BindUserControl(InstallEditControl1, SysConst.SourceTypeQuote, quote.Quotation_No); InstallEditControl1.SetInstallType(quote.InstallType); //quotation UIUtility.BindUserControl(quotationControl, SourceType, SourceNo); //survey UIUtility.BindUserControl(surveyControl, SourceType, SourceNo); //customer provide drawing UIUtility.BindUserControl(customerDrawingControl1, SourceType, SourceNo); //refine UIUtility.BindUserControl(cADRefinementControl, SourceType, SourceNo); //intro UIUtility.BindUserControl(FooterIntroControl1, SysConst.SourceTypeQuote, quote.Quotation_No); //followup UIUtility.BindUserControl(followUpControl, SysConst.SourceTypeQuote, quote.Quotation_No); //status dropdown Utility.BindDataToDropdown(this.ddlQuotationStatus, Utility.GetQuotationStatusList()); ddlQuotationStatus.SelectedValue = quote.Status; if (string.Equals(quote.Status, "报价完成", StringComparison.OrdinalIgnoreCase) || string.Equals(quote.Status, "待确认", StringComparison.OrdinalIgnoreCase) || string.Equals(quote.Status, "确认", StringComparison.OrdinalIgnoreCase) || string.Equals(quote.Status, "不确认", StringComparison.OrdinalIgnoreCase) ) { SetControlsStatus(false); ddlQuotationStatus.Enabled = true; btnChangeStatus.Enabled = true; btnPrint.Disabled = false; btnCopy.Enabled = true; } if (quote.Status != "编辑中") { SetControlsStatus(false); SetControlEnabled(btnChangeStatus, true); SetControlEnabled(ddlQuotationStatus, true); } } } }
protected void rpEnqList_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "GenerateOrder" && (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)) { HiddenField hdId = e.Item.FindControl("hdId") as HiddenField; Enquiry enq = new EnquiryDAL().GetEnquiryById(int.Parse(hdId.Value)); OrderDAL dal = new OrderDAL(); var order = dal.GetOrderByEnq(enq.Enquiry_No); if (order != null) { ClientScript.RegisterClientScriptBlock(this.GetType(), "generateorder", string.Format("<script>window.open('OrderForm.aspx?ordid={0}&ordno={1}&sourcetype=E&sourceno={2}')</script>", order.Order_Id, order.Order_No, enq.Enquiry_No)); return; } SeedDAL sdal = new SeedDAL(); LineItemDAL lDAL = new LineItemDAL(); var no = sdal.GetNoByTableName(SysConst.TableOrder, SysConst.SuffixOrder); var enqItems = lDAL.GetLineItemsBySource(enq.Enquiry_Id, SysConst.SourceTypeEnquiry); Order ord = new Order(); ord.SourceType = SysConst.SourceTypeEnquiry; ord.SourceNo = enq.Enquiry_No; ord.Order_No = no; ord.Status = FirstStatusConsts.Order; ord.CreatedDate = DateTime.Now; ord.CustomerAddress = enq.CustomerAddress; ord.CustomerCompanyName = enq.CustomerCompanyName; ord.CustomerContactName = enq.CustomerContactName; ord.CustomerEmail = enq.CustomerEmail; ord.CustomerOthers = enq.CustomerOthers; ord.CustomerPhone1 = enq.CustomerPhone1; ord.CustomerPhone2 = enq.CustomerPhone2; ord.CustomerQQ = enq.CustomerQQ; ord.IsSampleProvidedToCustomer = enq.IsSampleProvidedToCustomer; ord.IsCustomerProvideSample = enq.IsCustomerProvideSample; ord.IsCustomerProvideImage = enq.IsCustomerProvideImage; ord.IsSurveyNeeded = enq.IsSurveyNeeded; ord.SurveyType = enq.SurveyType; ord.SurveyIntro = enq.SurveyIntro; ord.IsCADRefinementNeeded = enq.IsCADRefinementNeeded; ord.CADRefinementIntro = enq.CADRefinementIntro; ord.IsCADNeedCustomerConfirmation = enq.IsCADNeedCustomerConfirmation; ord.DeliveryType = enq.DeliveryType; ord.DeliveryIntro = enq.DeliveryIntro; ord.DeliveryToAddress = enq.DeliveryToAddress; ord.IsInstallProvided = enq.IsInstallProvided; ord.InstallType = string.IsNullOrEmpty(enq.InstallType) ? string.Empty : enq.InstallType; ord.InstallIntro = enq.InstallIntro; ord.EnqNo = enq.Enquiry_No; ord.IsActive = true; dal.AddOrder(ord); dal.Save(); //intro //intro Utility.AddDefault(ord.Order_No, SysConst.SourceTypeOrder, FooterConsts.Order); //item foreach (var item in enqItems) { LineItem newItem = new LineItem() { Intro = item.Intro, Name = item.Name, Project = item.Project, Quantity = item.Quantity, Remark = item.Remark, SourceId = ord.Order_Id, SourceType = SysConst.SourceTypeOrder, Spec = item.Spec, Unit = item.Unit, UnitPrice = item.UnitPrice }; lDAL.AddLineItem(newItem); } lDAL.Save(); ClientScript.RegisterClientScriptBlock(this.GetType(), "generateorder", string.Format("<script>window.open('OrderForm.aspx?ordid={0}&ordno={1}&sourcetype=E&sourceno={2}')</script>", ord.Order_Id, ord.Order_No, enq.Enquiry_No)); } else if (e.CommandName == "Delete" && (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)) { HiddenField hdId = e.Item.FindControl("hdId") as HiddenField; new EnquiryDAL().Delete(int.Parse(hdId.Value)); Utility.BindDataToRepeater(rpEnqList, GetEnquiryList()); } else { SetSorting(e); if (!string.IsNullOrWhiteSpace(SortOrder)) { Utility.BindDataToRepeater(rpEnqList, GetEnquiryList().Sort(string.Format("{0} {1}", e.CommandName, SortOrder))); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Utility.BindDataToDropdown(ddlEnqOrdMan, Utility.GetUserList2(true)); Utility.BindDataToDropdown(ddlRefMan, Utility.GetUserList2(true)); if (!string.IsNullOrEmpty(SourceType) && !string.IsNullOrEmpty(SourceNo)) { //link if (string.Equals(SourceType, SysConst.SourceTypeEnquiry, StringComparison.OrdinalIgnoreCase)) { EnquiryDAL eDAL = new EnquiryDAL(); var enq = eDAL.GetEnquiryByNo(SourceNo); lnkSource.NavigateUrl = Page.ResolveUrl(string.Format("~/enquiryform.aspx?enqno={0}&enqid={1}", SourceNo, enq.Enquiry_Id)); } else { OrderDAL sDAL = new OrderDAL(); var ord = sDAL.GetOrderByNo(SourceNo); lnkSource.NavigateUrl = Page.ResolveUrl(string.Format("~/orderform.aspx?ordno={0}&ordid={1}&sourcetype={2}&sourceno={3}", SourceNo, ord.Order_Id, ord.SourceType, ord.SourceNo)); } lnkSource.Text = SourceNo; RefineDAL dal = new RefineDAL(); var refine = dal.GetRefineByNo(RefNo); //basic txtCreatedDate.Text = refine.CreatedDate.ToString("yyyy-MM-dd"); ddlEnqOrdMan.SelectedValue = refine.EnqOrdMan; ddlRefMan.SelectedValue = refine.RefineMan; txtCompletedDate.Text = refine.RequestCompleteDate.HasValue ? refine.RequestCompleteDate.Value.ToString("yyyy-MM-dd") : string.Empty; chkConfirm.Checked = refine.NeedCustomerConfirm; txtConfirmIntro.Text = refine.CustomerConfirmIntro; chkIncludeMachining.Checked = refine.IncludeMaching; chkNeedApprove.Checked = refine.NeedApprove; txtRefineIntro.Text = refine.RefineIntro; //customer info this.customerInfoControl.SetValue( refine.CustomerCompanyName, refine.CustomerContactName, refine.CustomerAddress, refine.CustomerEmail, refine.CustomerQQ, refine.CustomerPhone1, refine.CustomerPhone2, refine.CustomerOthers); //history cad UIUtility.BindUserControl(cADRefinementControl, SourceType, SourceNo); //customer drawing UIUtility.BindUserControl(customerDrawingControl, SourceType, SourceNo); //survey UIUtility.BindUserControl(surveyControl, SourceType, SourceNo); //cad cADFileListControl.RefineId = RefId; UIUtility.BindUserControl(cADFileListControl, SourceType, SourceNo); //followup UIUtility.BindUserControl(followUpControl, SysConst.SourceTypeRefine, refine.Refine_No); //status dropdown var result = StatusEngine.GetRefineStatus(chkIncludeMachining.Checked, chkNeedApprove.Checked, chkConfirm.Checked); ddlRefineStatus.Items.Clear(); foreach (var item in result) { ddlRefineStatus.Items.Add(new ListItem() { Text = item, Value = item }); } ddlRefineStatus.SelectedValue = refine.Status; } } }