public override void BindControl() { if (IsRefineInstead) { ddlRefineList.Visible = true; txtRefineIntro.Visible = true; //btnSave.Visible = true; RefineDAL refDAL = new RefineDAL(); var refineList = refDAL.GetRefineBySource(SysConst.SourceTypeOrder, OrderNo); var result = (from r in refineList select new NameValueItem() { Name = r.Refine_No, Value = r.Refine_No }).ToList(); Utility.BindDataToDropdown(ddlRefineList, result); if (!string.IsNullOrEmpty(RefineNo)) { ddlRefineList.SelectedValue = RefineNo; } txtRefineIntro.Text = RefineIntro; } MachItemDAL dal = new MachItemDAL(); var machItems = dal.GetMachItemsByMachId(MachId); Utility.BindDataToRepeater(rpItems, machItems); }
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); }
protected void btnSave_Click(object sender, EventArgs e) { RefineDAL dal = new RefineDAL(); var refine = dal.GetRefineByNo(RefNo); refine.RefineMan = Utility.GetSelectedText(ddlRefMan); if (!string.IsNullOrEmpty(txtCompletedDate.Text)) { refine.RequestCompleteDate = DateTime.Parse(txtCompletedDate.Text); } AddFollowUp(followUpControl, refine.Status, Utility.GetSelectedText(ddlRefineStatus)); refine.Status = Utility.GetSelectedText(ddlRefineStatus); refine.NeedCustomerConfirm = chkConfirm.Checked; refine.CustomerConfirmIntro = txtConfirmIntro.Text; refine.IncludeMaching = chkIncludeMachining.Checked; refine.NeedApprove = chkNeedApprove.Checked; refine.RefineIntro = txtRefineIntro.Text; refine.CustomerCompanyName = customerInfoControl.CompanyName; refine.CustomerContactName = customerInfoControl.ContactName; refine.CustomerAddress = customerInfoControl.Address; refine.CustomerQQ = customerInfoControl.QQ; refine.CustomerEmail = customerInfoControl.Email; refine.CustomerPhone1 = customerInfoControl.Phone1; refine.CustomerPhone2 = customerInfoControl.Phone2; refine.CustomerOthers = customerInfoControl.Other; dal.Save(); //save new customer customerInfoControl.Save(); SetFocus(sender); }
private List <Refine> GetRefineList() { string refNo = txtRefineNo.Text; string refMan = Utility.GetSelectedText(ddlRefMan); string enqOrdMan = Utility.GetSelectedText(ddlEnqOrderResponder); string status = Utility.GetSelectedText(ddlRefineStatus); DateTime beginDate = !string.IsNullOrEmpty(txtBeginDate.Text) ? DateTime.Parse(txtBeginDate.Text) : DateTime.MinValue; DateTime endDate = !string.IsNullOrEmpty(txtEndDate.Text) ? DateTime.Parse(txtEndDate.Text) : DateTime.MaxValue; string companyName = Utility.GetSelectedText(ddlCompany); string contact = Utility.GetSelectedText(ddlContact); string email = txtEmail.Text; string phone = txtPhone.Text; string qq = txtQQ.Text; RefineDAL dal = new RefineDAL(); var result = dal.SearchRefine(refNo, refMan, enqOrdMan, status, beginDate, endDate, companyName, contact, email, phone, qq); return(result); }
protected void btnChangeStatus_Click(object sender, EventArgs e) { RefineDAL dal = new RefineDAL(); var refine = dal.GetRefineById(RefId); AddFollowUp(followUpControl, refine.Status, Utility.GetSelectedText(ddlRefineStatus)); refine.Status = Utility.GetSelectedText(ddlRefineStatus); dal.Save(); SetFocus(btnChangeStatus); }
protected void rpEnqList_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { Enquiry enq = e.Item.DataItem as Enquiry; RefineDAL rDal = new RefineDAL(); SurveyDAL sDal = new SurveyDAL(); QuotationDAL qDal = new QuotationDAL(); Repeater rpRefinement = e.Item.FindControl("rpRefinement") as Repeater; Utility.BindDataToRepeater(rpRefinement, rDal.GetRefineBySource(SysConst.SourceTypeEnquiry, enq.Enquiry_No)); Repeater rpSurvey = e.Item.FindControl("rpSurvey") as Repeater; Utility.BindDataToRepeater(rpSurvey, sDal.GetSurveyBySource(enq.Enquiry_No, SysConst.SourceTypeEnquiry)); Repeater rpQuoationa = e.Item.FindControl("rpQuoation") as Repeater; Utility.BindDataToRepeater(rpQuoationa, qDal.GetQuotesBySource(SysConst.SourceTypeEnquiry, enq.Enquiry_No)); FollowUpTop3UserControl followUp = e.Item.FindControl("followUpTop3UserControl") as FollowUpTop3UserControl; UIUtility.BindUserControl(followUp, SysConst.SourceTypeEnquiry, ((Enquiry)e.Item.DataItem).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(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; } } }