public static void addButton4Cmb(System.Web.UI.Page mypage, ASPxComboBox cmb, int Buttontype, string popupID) { string prefixCookie = mypage.GetType().ToString().Replace("ASP.", ""); switch (Buttontype) { case 0://add cả 2 button AddFavButton4Cmb(cmb); AddNewButton4Cmb(cmb); cmb.ClientSideEvents.Init = "function(s,e){ GetDefaultValue4Cmb(s,'" + prefixCookie + "_" + cmb.ClientInstanceName + "'); }"; cmb.ClientSideEvents.ButtonClick = "function(s,e){ if( e.buttonIndex == 0){setCookie('" + prefixCookie + "_" + cmb.ClientInstanceName + "',s.GetValue(),365);} else { popupWindow4Cmb('" + popupID + "');} }"; break; case 1://chi add button new AddNewButton4Cmb(cmb); cmb.ClientSideEvents.ButtonClick = "function(s,e){ popupWindow4Cmb('" + popupID + "'); }"; break; case 2://chỉ add button fav AddNewButton4Cmb(cmb); cmb.ClientSideEvents.Init = "function(s,e){ GetDefaultValue4Cmb(s,'" + prefixCookie + "_" + cmb.ClientInstanceName + "'); }"; cmb.ClientSideEvents.ButtonClick = "function(s,e){ setCookie('" + prefixCookie + "_" + cmb.ClientInstanceName + "',s.GetValue(),365); }"; break; } /* * <ButtonStyle BackColor="Transparent"> <Paddings Padding="0px" /> <Border BorderStyle="None" /> </ButtonStyle> */ cmb.ClientSideEvents.GotFocus = "function(s,e){ s.SelectAll(); }"; //cmb.ButtonStyle.BackColor = Color.Transparent; //cmb.ButtonStyle.Width = Unit.Pixel(15); //cmb.ButtonStyle.Paddings.Padding = Unit.Pixel(0); //cmb.ButtonStyle.Border.BorderStyle = BorderStyle.None; //cmb.SkinID = "cmbDefault"; }
public static void SeleccionarItemCombo(ref ASPxComboBox combo, string valor, string texto) { combo.SelectedIndex = -1; if ((combo.Items.FindByValue(valor) == null)) combo.Items.Insert(0, new ListEditItem(texto, valor)); combo.Items.FindByValue(valor).Selected = true; }
protected void FillCombo_OLD_SYSTEM(ASPxComboBox cmb, string SYS_CODE) { try { if (string.IsNullOrEmpty(SYS_CODE)) return; string SQL = ""; SQL = " SELECT CTLT_SYS_USER_RIGHT.USER_RIGHT ROLE_ID"; SQL += " ,SYS_CODE"; SQL += " ,CTLT_USER_RIGHT.USER_RIGHT_DESC ROLE_NAME"; SQL += " FROM CTLT_SYS_USER_RIGHT "; SQL += " LEFT JOIN CTLT_USER_RIGHT ON CTLT_USER_RIGHT.USER_RIGHT = CTLT_SYS_USER_RIGHT.USER_RIGHT"; SQL += " WHERE SYS_CODE='" + SYS_CODE + "'"; //string SQL = string.Format("select ROLE_ID,ROLE_NAME from ODS_SYSTEM_ROLE WHERE SYS_CODE='{0}' ORDER BY [ROLE_NAME]", SYS_CODE); SqlDataAdapter DA = new SqlDataAdapter(SQL, OPM_BL.DefaultConnectionString); DataTable DTRole = new DataTable(); DA.Fill(DTRole); cmb.DataSource = DTRole; cmb.ValueField = "ROLE_ID"; cmb.TextField = "ROLE_NAME"; cmb.DataBindItems(); //AccessDataSource2.FilterExpression = " SYS_CODE='" + SYS_CODE + "'"; //DataView dv = (DataView)AccessDataSource2.Select(DataSourceSelectArguments.Empty); //DataTable DT = dv.ToTable(); } catch (Exception ex) { } }
protected void FillCombo(ASPxComboBox cmb, string SYS_CODE) { try { if (string.IsNullOrEmpty(SYS_CODE)) return; //AccessDataSource2.SelectParameters.Clear(); ////string SQL = AccessDataSource2.SelectCommand; //AccessDataSource2.SelectCommand = " select SYS_CODE ,ROLE_ID,ROLE_NAME from ODS_SYSTEM_ROLE "; //AccessDataSource2.SelectCommand = SQL; string SQL = string.Format("select ROLE_ID,ROLE_NAME from ODS_SYSTEM_ROLE WHERE SYS_CODE='{0}' ORDER BY [ROLE_NAME]", SYS_CODE); SqlDataAdapter DA = new SqlDataAdapter(SQL, OPM_BL.DefaultConnectionString); DataTable DTRole = new DataTable(); DA.Fill(DTRole); cmb.DataSource = DTRole; cmb.ValueField = "ROLE_ID"; cmb.TextField = "ROLE_NAME"; cmb.DataBindItems(); //AccessDataSource2.FilterExpression = " SYS_CODE='" + SYS_CODE + "'"; //DataView dv = (DataView)AccessDataSource2.Select(DataSourceSelectArguments.Empty); //DataTable DT = dv.ToTable(); } catch (Exception ex) { } }
public static void AddFavButton4Cmb(ASPxComboBox cmb) { var btnFav = new EditButton { Position = ButtonsPosition.Left }; btnFav.Image.Url = "~/img/btnico/star.png"; btnFav.Image.Width = Unit.Pixel(16); btnFav.ToolTip = "Nhấn vào đây để chọn mục này là mặc định cho lần sau."; cmb.Buttons.Add(btnFav); }
protected void FillSectionCombo(ASPxComboBox cmb, string SiteID) { if (SiteID == "0") return; cmb.DataSourceID = "ObjectDataSourceSection"; ObjectDataSourceSection.SelectParameters[0].DefaultValue = SiteID; cmb.DataBindItems(); cmb.Items.Insert(0, new ListEditItem("", null)); // Null Item }
/* <dx:EditButton Position="Left" ToolTip="<%$ Resources:Control, DefaultButton.Tooltip %>"> <Image Height="16px" Url="~/img/btnico/star.png" Width="16px"> </Image> </dx:EditButton> <dx:EditButton ToolTip="<%$ Resources:Control, AddButton.Tooltip %>"> <Image Url="~/img/common/Add.png" Width="16px"> </Image> </dx:EditButton> */ public static void AddNewButton4Cmb(ASPxComboBox cmb) { var btnNew = new EditButton { Position = ButtonsPosition.Right }; btnNew.Image.Url = "~/img/common/Add.png"; btnNew.Image.Width = Unit.Pixel(16); btnNew.ToolTip = "Nhấn vào đây để tạo mới thêm danh mục này"; cmb.Buttons.Add(btnNew); }
/// <summary> /// Tao nut add/fav/refresh /// </summary> /// <param name="cmb">Truyen vao control combobox</param> /// <param name="type">Truyen vao loai nut. 0 : Fav; 1:Fav+Add;2:Fav+Add+Refresh;3:Only Refresh;4:Only Add;5: Fav+Refresh</param> public void buildcmbButton(ASPxComboBox cmb, int type, string popupCode = "") { int modulePage = -1; try { Int32.TryParse(CU.getCurrentModuleID().ToString(), out modulePage); } catch (System.NullReferenceException) { } int width = 500; int height = 500; string title = "Error load Page!!!"; string param = ""; DataTable dtPopupWindow = new DataTable(); dtPopupWindow = SY_GetModuleID_for_PopUpcontrol(popupCode); if (dtPopupWindow.Rows.Count > 0) { SiAuto.Main.LogDataTable(dtPopupWindow); moduleID = int.Parse(dtPopupWindow.Rows[0]["moduleID"].ToString()); width = int.Parse(dtPopupWindow.Rows[0]["width"].ToString()); height = int.Parse(dtPopupWindow.Rows[0]["height"].ToString()); title = dtPopupWindow.Rows[0]["title"].ToString(); param = dtPopupWindow.Rows[0]["paramArray"].ToString(); } else return; SiAuto.Main.LogInt("ModulePage=", modulePage); SiAuto.Main.LogInt("ModuleID=", moduleID); switch (type) { case 0: buildFavBtn(cmb, modulePage); break; case 1: if (checkPermissionBtn(moduleID)) buildFavAddBtn(cmb, popupCode, modulePage, moduleID, width, height, title, param); else buildFavBtn(cmb, modulePage); break; case 2: if (checkPermissionBtn(moduleID)) buildAllBtn(cmb, popupCode, modulePage, moduleID, width, height, title, param); else buildFavRefresh(cmb, modulePage); break; case 3: buildRefreshBtn(cmb); break; case 4: if (checkPermissionBtn(moduleID)) buildAddBtn(cmb, popupCode, moduleID, width, height, title, param); break; case 5: buildFavRefresh(cmb, modulePage); break; default: break; } }
static void InitDurationCombo(ASPxComboBox cbSnooze) { cbSnooze.Items.Clear(); TimeSpan[] snoozeTimeSpans = GetTimeSpans(); int length = snoozeTimeSpans.Length; for (int i = 0; i < length; i++) { TimeSpan span = snoozeTimeSpans[i]; cbSnooze.Items.Add(new ListEditItem(ConvertTimeSpanToString(span), span)); } cbSnooze.SelectedIndex = 4; }
public List<WebControl> RenderControl(XmlNode xmlControl) { base.Initialize(xmlControl); ASPxComboBox aspxListBox = new ASPxComboBox { ID = _PropertyMapper.GetID(), ClientInstanceName = _PropertyMapper.GetID() }; if (string.IsNullOrEmpty(_PropertyMapper.GetDefault())) aspxListBox.SelectedIndex = 0; aspxListBox.Callback += new DevExpress.Web.ASPxClasses.CallbackEventHandlerBase(aspxListBox_Callback); XmlNode valuesNode = _PropertyMapper.GetValuesNode(); // Carga los datos de la lista foreach (XmlNode xmlValueNode in valuesNode.ChildNodes) { ListEditItem listEditItem = new ListEditItem(); listEditItem.Value = xmlValueNode.GetAttribute("CCLAVE"); listEditItem.Text = xmlValueNode.GetAttribute("CTEXTO"); listEditItem.Selected = (_PropertyMapper.GetDefault() == xmlValueNode.GetAttribute("CCLAVE")) ? true : false; aspxListBox.Items.Add(listEditItem); } try { if (xmlControl.GetAttribute("CCONTROLASOC") != null) { aspxListBox.ClientSideEvents.ValueChanged = "function(s, e) {" + xmlControl.GetAttribute("CCONTROLASOC") + ".PerformCallback(" + _PropertyMapper.GetID() + ".GetValue());}"; aspxListBox.ClientSideEvents.Init = "function(s, e) {" + xmlControl.GetAttribute("CCONTROLASOC") + ".PerformCallback(" + _PropertyMapper.GetID() + ".GetValue());}"; } } catch (Exception) { } _Controls.Add(aspxListBox); return _Controls; }
void FillEditor(ASPxComboBox editor) { if (editor == null) return; editor.Items.Clear(); editor.ValueType = GetComboBoxValueType(); IEnumerable dataSource = GetDataSource(); if (_propertyType.IsGenericType && _propertyType.GetGenericTypeDefinition() == typeof(Nullable<>)) { editor.Items.Add(CaptionHelper.NullValueText, null); } if (dataSource != null) foreach (object value in dataSource) { if (value is ListEditItem) editor.Items.Add(value as ListEditItem); else editor.Items.Add(CreateEditItem(value)); } }
/// <summary> /// Binds the DataTable to ComboBox list with given value and text fields /// </summary> /// <param name="cmbBox">Name of the ComboBox list to process</param> /// <param name="dt">DataTable to Bind</param> /// <param name="strValue">Value field name as string</param> /// <param name="strText">Text fiels name as string</param> public static void BindDropDown(ASPxComboBox cmbBox, DataTable dt, string strValue, string strText) { // clsDataFunctionsBAL objFunctions = null; try { if (DataTableHasRows(dt)) { cmbBox.DataSource = dt; cmbBox.ValueField = strValue; cmbBox.TextField = strText; cmbBox.DataBindItems(); } } catch (Exception ex) { //objFunctions = new clsDataFunctionsBAL(); //objFunctions.SaveErrorLog(ex.Message, m_strModule, MethodBase.GetCurrentMethod().Name); } finally { // objFunctions = null; } }
// แสดงชื่อตำแหน่งของลูกจ้างโครงการ ไกท์ไลน์ public static void SetDDLPositionNameOtherType(ASPxComboBox ddl) { try { string sql = ""; sql += " SELECT ROW_NUMBER() OVER(ORDER BY LINE_INORG ASC) AS Row,LINE_INORG FROM ( "; sql += " SELECT DISTINCT LINE_INORG FROM PSST_POSITION WHERE PER_TYPE in ('23','Z0') AND POS_Status=1 AND LINE_INORG IS NOT NULL "; sql += " )AS TB ORDER BY LINE_INORG "; SqlDataAdapter da = new SqlDataAdapter(sql, StaticDefaultConnectionString); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { ddl.Columns.Clear(); ddl.Columns.Add("LINE_INORG", "ตำแหน่ง"); ddl.ValueField = "Row"; ddl.TextField = "LINE_INORG"; ddl.DataSource = dt; ddl.DataBind(); } } catch (Exception ex) { } }
public static void SetDDLPERSONBYPERTYPE(ASPxComboBox ddl, string per_type, bool IsAll = false) { try { string sql = " select ID,PREFIX_NAME + NAME + ' ' + SURNAME PER_FULLNAME "; sql += " from vw_CMN_PERSON "; sql += " where name is not null and per_type='" + per_type + "' "; sql += " AND RETIRE_DATE>GetDate() "; sql += " AND ID IN ( SELECT ID FROM PSST_POSITION WHERE PER_TYPE='" + per_type + "' AND POS_STATUS=1 AND LENGTH_CODE LIKE 'K%') "; sql += " order by name,surname "; //string sql = "select ID,PREFIX_NAME + NAME + ' ' + SURNAME PER_FULLNAME from vw_CMN_PERSON "; //sql += " where name is not null and per_type='" + per_type + "' order by name,surname"; DataTable dt = new DataTable(); dt = OPM_BL.GetDatatable(sql, null); if (dt.Rows.Count > 0) { //ddl.Columns.Clear(); //ddl.Columns.Add("ID", "เลขที่"); //ddl.Columns.Add("PER_FULLNAME", "ชื่อ"); if (IsAll == true) { DataRow dr = dt.NewRow(); dr["ID"] = "0"; dr["PER_FULLNAME"] = "ทั้งหมด"; dt.Rows.InsertAt(dr, 0); } ddl.ValueField = "ID"; ddl.TextField = "PER_FULLNAME"; ddl.DataSource = dt; ddl.DataBind(); //ddl.SelectedIndex = 0; } } catch (Exception ex) { } }
public static void SetDDLPerTypeISMAIN1(ASPxComboBox ddl, bool isAll = false) { try { string sql = "select PER_TYPE,PER_TYPE_NAME from SMM_PER_TYPE Where IS_MAIN =1 ORDER BY PER_TYPE_NAME"; DataTable dt = GetDatatable(sql, null); if (dt.Rows.Count > 0) { if (isAll == true) { DataRow dr = dt.NewRow(); dr["PER_TYPE"] = "0"; dr["PER_TYPE_NAME"] = "ทั้งหมด"; dt.Rows.InsertAt(dr, 0); } ddl.ValueField = "PER_TYPE"; ddl.TextField = "PER_TYPE_NAME"; ddl.DataSource = dt; ddl.DataBind(); } } catch (Exception ex) { } }
public static void SetDDLJDEVALSCORE(ASPxComboBox ddl) { try { DataTable dt =new DataTable(); dt.Columns.Add("Score_ID"); dt.Columns.Add("Score_Name"); DataRow dr ; dr=dt.NewRow(); dr["Score_ID"]="0"; dr["Score_Name"]="เลือกระดับ"; dt.Rows.Add(dr); dr=dt.NewRow(); dr["Score_ID"]="1"; dr["Score_Name"]="ระดับ 1"; dt.Rows.Add(dr); dr=dt.NewRow(); dr["Score_ID"]="2"; dr["Score_Name"]="ระดับ 2"; dt.Rows.Add(dr); dr=dt.NewRow(); dr["Score_ID"]="3"; dr["Score_Name"]="ระดับ 3"; dt.Rows.Add(dr); dr=dt.NewRow(); dr["Score_ID"]="4"; dr["Score_Name"]="ระดับ 4"; dt.Rows.Add(dr); dr=dt.NewRow(); dr["Score_ID"]="5"; dr["Score_Name"]="ระดับ 5"; dt.Rows.Add(dr); ddl.ValueField = "Score_ID"; ddl.TextField = "Score_Name"; ddl.DataSource = dt; ddl.DataBind(); } catch (Exception ex) { } }
public static void SetDDLORG(ASPxComboBox ddl) { try { string sql = "SELECT '' ORG_SERIAL,'เลือกหน่วยงาน' ORG_NAME,'' ORG_ABBR UNION ALL SELECT CONVERT(varchar,ORG_SERIAL) ORG_SERIAL,ORG_NAME,ORG_ABBR FROM vw_SMM_ORG"; SqlDataAdapter da = new SqlDataAdapter(sql, StaticDefaultConnectionString); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { ddl.Columns.Clear(); ddl.Columns.Add("ORG_NAME", "ชื่อหน่วยงาน"); ddl.Columns.Add("ORG_ABBR", "ชื่อย่อ"); ddl.ValueField = "ORG_SERIAL"; ddl.TextField = "ORG_NAME"; ddl.DataSource = dt; ddl.DataBind(); } } catch (Exception ex) { } }
private void job_save() { try { ASPxPageControl pageControl = this.grid_job.FindEditFormTemplateControl("pageControl") as ASPxPageControl; ASPxTextBox txt_JobNo = pageControl.FindControl("txt_JobNo") as ASPxTextBox; string jobNo = SafeValue.SafeString(txt_JobNo.Text, ""); Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJob), "JobNo='" + jobNo + "'"); C2.CtmJob ctmJob = C2.Manager.ORManager.GetObject(query) as C2.CtmJob; ASPxDateEdit jobDate = pageControl.FindControl("txt_JobDate") as ASPxDateEdit; bool isNew = false; if (ctmJob == null) { isNew = true; ctmJob = new C2.CtmJob(); ctmJob.JobNo = C2Setup.GetNextNo("", "CTM_Job", jobDate.Date); } ASPxDateEdit jobEta = pageControl.FindControl("date_Eta") as ASPxDateEdit; ASPxDateEdit jobEtd = pageControl.FindControl("date_Etd") as ASPxDateEdit; //ASPxButtonEdit partyId = pageControl.FindControl("btn_PartyId") as ASPxButtonEdit; ASPxTextBox ves = pageControl.FindControl("txt_Ves") as ASPxTextBox; ASPxTextBox voy = pageControl.FindControl("txt_Voy") as ASPxTextBox; //ASPxButtonEdit carrier = pageControl.FindControl("btn_CarrierId") as ASPxButtonEdit; //ASPxTextBox CarrierBlNo = pageControl.FindControl("txt_CarrierBlNo") as ASPxTextBox; //ASPxTextBox CarrierBkgNo = pageControl.FindControl("txt_CarrierBkgNo") as ASPxTextBox; ASPxComboBox Terminal = pageControl.FindControl("cbb_Terminal") as ASPxComboBox; ASPxMemo PickupFrom = pageControl.FindControl("txt_PickupFrom") as ASPxMemo; ASPxMemo DeliveryTo = pageControl.FindControl("txt_DeliveryTo") as ASPxMemo; ASPxMemo Remark = pageControl.FindControl("txt_Remark") as ASPxMemo; ASPxMemo SpecialInstruction = pageControl.FindControl("txt_SpecialInstruction") as ASPxMemo; ASPxTextBox txt_Pol = pageControl.FindControl("txt_Pol") as ASPxTextBox; ASPxTextBox txt_Pod = pageControl.FindControl("txt_Pod") as ASPxTextBox; ASPxTextBox txt_EtaTime = pageControl.FindControl("txt_EtaTime") as ASPxTextBox; ASPxTextBox txt_EtdTime = pageControl.FindControl("txt_EtdTime") as ASPxTextBox; ASPxComboBox cbb_JobType = pageControl.FindControl("cbb_JobType") as ASPxComboBox; //ASPxButtonEdit btn_ClientId = pageControl.FindControl("btn_ClientId") as ASPxButtonEdit; ASPxTextBox txt_ClientRefNo = pageControl.FindControl("txt_ClientRefNo") as ASPxTextBox; //ASPxButtonEdit btn_HaulierId = pageControl.FindControl("btn_HaulierId") as ASPxButtonEdit; ctmJob.JobDate = SafeValue.SafeDate(jobDate.Date, new DateTime(1753, 1, 1)); ctmJob.EtaDate = SafeValue.SafeDate(jobEta.Date, new DateTime(1753, 1, 1)); ctmJob.EtdDate = SafeValue.SafeDate(jobEtd.Date, new DateTime(1753, 1, 1)); //ctmJob.PartyId = partyId.Text; ctmJob.Vessel = ves.Text; ctmJob.Voyage = voy.Text; ctmJob.CarrierId = ""; ctmJob.CarrierBlNo = ""; ctmJob.CarrierBkgNo = ""; ctmJob.Terminalcode = SafeValue.SafeString(Terminal.Value); ctmJob.PickupFrom = PickupFrom.Text; ctmJob.DeliveryTo = DeliveryTo.Text; ctmJob.Remark = Remark.Text; ctmJob.SpecialInstruction = SpecialInstruction.Text; ctmJob.Pol = txt_Pol.Text; ctmJob.Pod = txt_Pod.Text; ctmJob.EtaTime = txt_EtaTime.Text; ctmJob.EtdTime = txt_EtdTime.Text; ctmJob.JobType = cbb_JobType.Text; ctmJob.ClientId = ""; ctmJob.ClientRefNo = txt_ClientRefNo.Text; ctmJob.HaulierId = ""; string userId = HttpContext.Current.User.Identity.Name; if (isNew) { ctmJob.StatusCode = "USE"; ctmJob.CreateBy = userId; ctmJob.CreateDateTime = DateTime.Now; ctmJob.UpdateBy = userId; ctmJob.UpdateDateTime = DateTime.Now; C2.Manager.ORManager.StartTracking(ctmJob, Wilson.ORMapper.InitialState.Inserted); C2.Manager.ORManager.PersistChanges(ctmJob); } else { ctmJob.UpdateBy = userId; ctmJob.UpdateDateTime = DateTime.Now; C2.Manager.ORManager.StartTracking(ctmJob, Wilson.ORMapper.InitialState.Updated); C2.Manager.ORManager.PersistChanges(ctmJob); } if (isNew) { txt_JobNo.Text = ctmJob.JobNo; //txt_search_JobNo.Text = txt_JobNo.Text; C2Setup.SetNextNo("", "CTM_Job", ctmJob.JobNo, jobDate.Date); } Session["CTM_Job"] = "JobNo='" + ctmJob.JobNo + "'"; this.dsJob.FilterExpression = Session["CTM_Job"].ToString(); if (this.grid_job.GetRow(0) != null) { this.grid_job.StartEdit(0); } } catch { } }
private void SaveAndUpdate() { ASPxTextBox cerId = this.ASPxGridView1.FindEditFormTemplateControl("txt_Id") as ASPxTextBox; ASPxComboBox cmb_PartyTo = this.ASPxGridView1.FindEditFormTemplateControl("cmb_PartyTo") as ASPxComboBox; ASPxDateEdit txt_CerDt = this.ASPxGridView1.FindEditFormTemplateControl("txt_CerDt") as ASPxDateEdit; ASPxTextBox txt_GstPermitNo = this.ASPxGridView1.FindEditFormTemplateControl("txt_GstPermitNo") as ASPxTextBox; ASPxSpinEdit spin_GstPaidAmt = this.ASPxGridView1.FindEditFormTemplateControl("spin_GstPaidAmt") as ASPxSpinEdit; ASPxTextBox serialNo = this.ASPxGridView1.FindEditFormTemplateControl("txt_SerialNo") as ASPxTextBox; ASPxTextBox mastRefNCtr = this.ASPxGridView1.FindEditFormTemplateControl("txt_MastRefNo") as ASPxTextBox; ASPxTextBox jobRefNCtr = this.ASPxGridView1.FindEditFormTemplateControl("txt_JobRefNo") as ASPxTextBox; ASPxTextBox jobType = this.ASPxGridView1.FindEditFormTemplateControl("txt_MastType") as ASPxTextBox; ASPxButtonEdit btn_RefCurrency = this.ASPxGridView1.FindEditFormTemplateControl("btn_RefCurrency") as ASPxButtonEdit; ASPxSpinEdit txt_RefExRate = this.ASPxGridView1.FindEditFormTemplateControl("txt_RefExRate") as ASPxSpinEdit; C2.SeaCertificate cer = Manager.ORManager.GetObject(typeof(SeaCertificate), SafeValue.SafeInt(cerId.Text, 0)) as SeaCertificate; if (cer == null)// first insert invoice { cer = new SeaCertificate(); cer.GstPermitNo = txt_GstPermitNo.Text; cer.GstPaidAmt = SafeValue.SafeDecimal(spin_GstPaidAmt.Value); cer.HandingAgent = SafeValue.SafeString(cmb_PartyTo.Value); cer.CerDate = txt_CerDt.Date; cer.RefNo = mastRefNCtr.Text; cer.JobNo = jobRefNCtr.Text; cer.RefType = jobType.Text; cer.SerialNo = serialNo.Text; cer.Currency = btn_RefCurrency.Text; cer.ExRate = SafeValue.SafeDecimal(txt_RefExRate.Value); try { C2.Manager.ORManager.StartTracking(cer, Wilson.ORMapper.InitialState.Inserted); C2.Manager.ORManager.PersistChanges(cer); } catch { } } else { cer.GstPermitNo = txt_GstPermitNo.Text; cer.GstPaidAmt = SafeValue.SafeDecimal(spin_GstPaidAmt.Value); cer.HandingAgent = SafeValue.SafeString(cmb_PartyTo.Value); cer.CerDate = txt_CerDt.Date; cer.RefNo = mastRefNCtr.Text; cer.JobNo = jobRefNCtr.Text; cer.RefType = jobType.Text; cer.SerialNo = serialNo.Text; cer.Currency = btn_RefCurrency.Text; cer.ExRate = SafeValue.SafeDecimal(txt_RefExRate.Value); try { Manager.ORManager.StartTracking(cer, InitialState.Updated); Manager.ORManager.PersistChanges(cer); } catch { } } Session["ExportCertificate"] = "Id=" + cer.Id; this.dsCertificate.FilterExpression = Session["ExportCertificate"].ToString(); if (this.ASPxGridView1.GetRow(0) != null) { this.ASPxGridView1.StartEdit(0); } }
protected void ASPxCallbackPanel1_Callback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e) { ASPxTextBox txtTrainingEmpId = ASPxCallbackPanel1.FindControl("RoundPanelDaoTao2").FindControl("txtTrainingEmpId") as ASPxTextBox; ASPxTextBox txtTrainingId = ASPxCallbackPanel1.FindControl("RoundPanelDaoTao2").FindControl("txtTrainingId") as ASPxTextBox; ASPxTextBox txtSkill = ASPxCallbackPanel1.FindControl("RoundPanelDaoTao2").FindControl("txtSkill") as ASPxTextBox; ASPxTextBox txtDecision = ASPxCallbackPanel1.FindControl("RoundPanelDaoTao2").FindControl("txtTrainingDecision") as ASPxTextBox; ASPxTextBox txtCoSoDaoTao = ASPxCallbackPanel1.FindControl("RoundPanelDaoTao2").FindControl("txtCoSoDaoTao") as ASPxTextBox; ASPxTextBox txtTrainingDecision = ASPxCallbackPanel1.FindControl("RoundPanelDaoTao2").FindControl("txtTrainingDecision") as ASPxTextBox; ASPxDateEdit calDateEnd = ASPxCallbackPanel1.FindControl("RoundPanelDaoTao2").FindControl("calDateEnd") as ASPxDateEdit; ASPxDateEdit calStartDateTraining = ASPxCallbackPanel1.FindControl("RoundPanelDaoTao2").FindControl("calStartDateTraining") as ASPxDateEdit; ASPxListBox lstBoxChon = ASPxCallbackPanel1.FindControl("RoundPanelDaoTao1").FindControl("lbChoosen") as ASPxListBox; ASPxTextBox txtFee = ASPxCallbackPanel1.FindControl("RoundPanelDaoTao2").FindControl("txtFee") as ASPxTextBox; ASPxComboBox cboQualification = ASPxCallbackPanel1.FindControl("RoundPanelDaoTao2").FindControl("cboQualification") as ASPxComboBox; ASPxComboBox cboTrainingForm = ASPxCallbackPanel1.FindControl("RoundPanelDaoTao2").FindControl("cboTrainingForm") as ASPxComboBox; ASPxComboBox cmbDonViToChuc = ASPxCallbackPanel1.FindControl("RoundPanelDaoTao2").FindControl("cmbDonViToChuc") as ASPxComboBox; ASPxComboBox cmbDiaDiemDaoTao = ASPxCallbackPanel1.FindControl("RoundPanelDaoTao2").FindControl("cmbDiaDiemDaoTao") as ASPxComboBox; ASPxDateEdit tuNgay = ASPxCallbackPanel1.FindControl("RoundPanelDaoTao2").FindControl("calStartDateTraining") as ASPxDateEdit; ASPxDateEdit denNgay = ASPxCallbackPanel1.FindControl("RoundPanelDaoTao2").FindControl("calDateEnd") as ASPxDateEdit; ASPxComboBox cboResult = ASPxCallbackPanel1.FindControl("RoundPanelDaoTao2").FindControl("cboResult") as ASPxComboBox; ASPxHiddenField HiddentfileKem = ASPxCallbackPanel1.FindControl("RoundPanelDaoTao2").FindControl("HiddentfileKem") as ASPxHiddenField; ASPxCheckBox checkCamKet = ASPxCallbackPanel1.FindControl("RoundPanelDaoTao2").FindControl("checkCamKet") as ASPxCheckBox; if (e.Parameter.ToString().Equals("1")) { txtCoSoDaoTao.Text = ""; txtDecision.Text = ""; txtFee.Text = ""; txtSkill.Text = ""; LoadcboQualification(); LoadcboTrainingForm(); LoadcmbDiaDiemDaoTao(); lbChoosen.Items.Clear(); lstBoxChon.EnableViewState = false; Session["Add"] = 1; lbChoosen.EnableViewState = false; } else if (e.Parameter.ToString().Equals("")) { txtDecision.ReadOnly = false; List <Training.TrainingInfo> emps = objTraining.GetTrainingByDecision(txtDecision.Text.ToString()); if (emps.Count > 0) { foreach (Training.TrainingInfo item in emps) { this.training = objTraining.GetTraining(Int32.Parse(item.id.ToString())); if (this.training != null) { this.objTraining.DeleteTraining(training); } } } if (Session["Add"] != null) { if (Session["Decision"] != null) { List <Training.TrainingInfo> list = objTraining.GetTrainingByDecision(Session["Decision"].ToString()); foreach (Training.TrainingInfo obj in list) { ListEditItem item = lbChoosen.Items.FindByValue(obj.employeeid.ToString()); if (item != null) { lbChoosen.Items.Remove(item); } } } foreach (ListEditItem item in lbChoosen.Items) { this.training.id = -1; this.training.donvitochucId = Convert.ToInt32(cmbDonViToChuc.SelectedItem.Value.ToString()); this.training.diadiemtochucId = Convert.ToInt32(cmbDiaDiemDaoTao.SelectedItem.Value.ToString()); this.training.decision = txtDecision.Text; this.training.schoolname = txtCoSoDaoTao.Text.Trim(); this.training.skill = txtSkill.Text; this.training.fee = txtFee.Text; this.training.fromdate = Convert.ToDateTime(calStartDateTraining.Value); this.training.todate = Convert.ToDateTime(calDateEnd.Value); this.training.editor = this.UserId; this.training.result = cboResult.SelectedItem.Text; this.training.modifieddate = DateTime.Now; this.training.ip = HttpContext.Current.Request.UserHostAddress; this.training.employeeid = Int32.Parse(item.Value.ToString()); this.training.qualificationid = Int32.Parse(cboQualification.SelectedItem.Value.ToString()); this.training.trainingformid = Int32.Parse(cboTrainingForm.SelectedItem.Value.ToString()); this.training.camket = checkCamKet.Checked == true ? checkCamKet.Checked : false; if (Session["img"] != null) { this.training.fileKem = Session["img"].ToString(); } Session.Remove("img"); objTraining.AddTraining(this.training); } } else { foreach (ListEditItem item in lbChoosen.Items) { this.training.id = -1; this.training.donvitochucId = Convert.ToInt32(cmbDonViToChuc.SelectedItem.Value.ToString()); this.training.diadiemtochucId = Convert.ToInt32(cmbDiaDiemDaoTao.SelectedItem.Value.ToString()); this.training.decision = txtDecision.Text; this.training.schoolname = txtCoSoDaoTao.Text.Trim(); this.training.skill = txtSkill.Text; this.training.fee = txtFee.Text; this.training.fromdate = Convert.ToDateTime(calStartDateTraining.Value); this.training.todate = Convert.ToDateTime(calDateEnd.Value); this.training.result = cboResult.SelectedItem.Text; this.training.editor = this.UserId; this.training.modifieddate = DateTime.Now; this.training.ip = HttpContext.Current.Request.UserHostAddress; this.training.employeeid = Int32.Parse(item.Value.ToString()); this.training.qualificationid = Int32.Parse(cboQualification.SelectedItem.Value.ToString()); this.training.trainingformid = Int32.Parse(cboTrainingForm.SelectedItem.Value.ToString()); this.training.camket = checkCamKet.Checked == true ? checkCamKet.Checked : false; if (Session["img"] != null) { this.training.fileKem = Session["img"].ToString(); } Session.Remove("img"); objTraining.AddTraining(this.training); } } Session["Decision"] = txtDecision.Text.Trim(); Session.Remove("Add"); ASPxWebControl.RedirectOnCallback(DotNetNuke.Common.Globals.ApplicationPath + "/Default.aspx?tabid=232"); } else if (e.Parameter.ToString().Equals("2")) { Session.Remove("Add"); List <Training.TrainingInfo> list = objTraining.GetTrainingByDecision(cmbQuyetDinh.SelectedItem.Value.ToString()); foreach (Training.TrainingInfo obj in list) { this.training = obj; } if (this.training != null) { if (training.schoolname != null) { txtCoSoDaoTao.Text = training.schoolname.ToString(); } if (training.decision != null) { txtDecision.Text = training.decision.ToString(); } if (training.fee != null) { txtFee.Text = training.fee.ToString(); } if (training.skill != null) { txtSkill.Text = training.skill.ToString(); } //txtDecision.ReadOnly = true; ListEditItem item1 = cboQualification.Items.FindByValue(training.qualificationid.ToString()); if (item1 != null) { item1.Selected = true; } ListEditItem item7 = cboResult.Items.FindByText(training.result.ToString()); if (item7 != null) { item7.Selected = true; } ListEditItem item2 = cboTrainingForm.Items.FindByValue(training.trainingformid.ToString()); if (item2 != null) { item2.Selected = true; } ListEditItem item3 = cmbDonViToChuc.Items.FindByValue(training.donvitochucId.ToString()); if (item3 != null) { item3.Selected = true; } ListEditItem item4 = cmbDiaDiemDaoTao.Items.FindByValue(training.diadiemtochucId.ToString()); if (item4 != null) { item4.Selected = true; } tuNgay.Date = training.fromdate; denNgay.Date = training.todate; } } }
public static ASPxComboBox MontaComboEmpresa(ASPxComboBox pCombo) { return(SreDblib.MontaCombo(pCombo, "empresa", "apelido", "apelido", false, "")); }
private void SaveBill() { #region save ASPxTextBox oidCtr = this.ASPxGridView1.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox; ASPxComboBox partyTo = this.ASPxGridView1.FindEditFormTemplateControl("cmb_PartyTo") as ASPxComboBox; ASPxTextBox otherPartyName = this.ASPxGridView1.FindEditFormTemplateControl("txt_OtherPartyName") as ASPxTextBox; ASPxComboBox docType = this.ASPxGridView1.FindEditFormTemplateControl("cbo_DocType") as ASPxComboBox; ASPxComboBox docType1 = this.ASPxGridView1.FindEditFormTemplateControl("cbo_DocType1") as ASPxComboBox; ASPxTextBox docN = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox; ASPxDateEdit docDate = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocDt") as ASPxDateEdit; ASPxMemo remark = this.ASPxGridView1.FindEditFormTemplateControl("txt_Remarks1") as ASPxMemo; ASPxButtonEdit docCurr = this.ASPxGridView1.FindEditFormTemplateControl("txt_Currency") as ASPxButtonEdit; ASPxSpinEdit exRate = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocExRate") as ASPxSpinEdit; ASPxButtonEdit acCode = this.ASPxGridView1.FindEditFormTemplateControl("txt_AcCode") as ASPxButtonEdit; ASPxTextBox slipNo = this.ASPxGridView1.FindEditFormTemplateControl("txt_SlipNo") as ASPxTextBox; ASPxTextBox bankName = this.ASPxGridView1.FindEditFormTemplateControl("txt_BankName") as ASPxTextBox; ASPxTextBox acDorc = this.ASPxGridView1.FindEditFormTemplateControl("txt_AcDorc") as ASPxTextBox; ASPxTextBox chqNo = this.ASPxGridView1.FindEditFormTemplateControl("txt_ChequeNo") as ASPxTextBox; ASPxDateEdit chqDt = this.ASPxGridView1.FindEditFormTemplateControl("txt_ChqDt") as ASPxDateEdit; ASPxTextBox pic = this.ASPxGridView1.FindEditFormTemplateControl("txt_Pic") as ASPxTextBox; ASPxSpinEdit docAmt = this.ASPxGridView1.FindEditFormTemplateControl("spin_DocAmt") as ASPxSpinEdit; ASPxCheckBox isReturn = this.ASPxGridView1.FindEditFormTemplateControl("ck_IsReturn") as ASPxCheckBox; C2.pay_doc inv = Manager.ORManager.GetObject(typeof(pay_doc), SafeValue.SafeInt(oidCtr.Text, 0)) as pay_doc; if (null == inv)// first insert invoice { //string invN = C2Setup.GetNextNo("AR-RECEIPT"); inv = new C2.pay_doc(); inv.PartyTo = SafeValue.SafeString(partyTo.Value, ""); //inv.DocNo = invN; inv.DocType = docType.Value.ToString(); inv.DocType1 = docType1.Value.ToString(); inv.DocDate = docDate.Date; inv.ChqDate = chqDt.Date; inv.Remark = remark.Text; inv.DocCurrency = docCurr.Text.ToString(); inv.DocExRate = SafeValue.SafeDecimal(exRate.Value, 1); if (inv.DocExRate <= 0) { inv.DocExRate = 1; } inv.AcCode = acCode.Text; inv.BankName = bankName.Text; inv.SlipNo = slipNo.Text; inv.ChqNo = chqNo.Text; inv.ExportInd = "N"; if (inv.DocType1.ToLower() == "refund") { inv.AcSource = "CR"; } else { inv.AcSource = "DB"; } inv.DocAmt = SafeValue.SafeDecimal(docAmt.Value, 0); inv.LocAmt = inv.DocAmt * inv.DocExRate; inv.CancelDate = new DateTime(1900, 1, 1); inv.CancelInd = "N"; inv.BankRec = "N"; inv.BankDate = new DateTime(1900, 1, 1); inv.OtherPartyName = otherPartyName.Text; string[] currentPeriod = EzshipHelper.GetAccPeriod(docDate.Date); inv.AcYear = SafeValue.SafeInt(currentPeriod[1], docDate.Date.Year); inv.AcPeriod = SafeValue.SafeInt(currentPeriod[0], docDate.Date.Month); inv.Pic = pic.Text; inv.IsReturn = isReturn.Checked; try { inv.GenerateInd = "N"; inv.CreateBy = HttpContext.Current.User.Identity.Name; inv.CreateDateTime = DateTime.Now; inv.UpdateBy = HttpContext.Current.User.Identity.Name; inv.UpdateDateTime = DateTime.Now; inv.PostBy = ""; inv.PostDateTime = new DateTime(1900, 1, 1); C2.Manager.ORManager.StartTracking(inv, Wilson.ORMapper.InitialState.Inserted); C2.Manager.ORManager.PersistChanges(inv); inv.DocNo = inv.Id.ToString(); C2.Manager.ORManager.StartTracking(inv, Wilson.ORMapper.InitialState.Updated); C2.Manager.ORManager.PersistChanges(inv); //C2Setup.SetNextNo("AR-RECEIPT", invN); } catch { } } else { inv.PartyTo = SafeValue.SafeString(partyTo.Value, ""); inv.DocDate = docDate.Date; inv.ChqDate = chqDt.Date; inv.Remark = remark.Text; inv.DocCurrency = docCurr.Text.ToString(); inv.DocExRate = SafeValue.SafeDecimal(exRate.Value, 1); if (inv.DocExRate <= 0) { inv.DocExRate = 1; } inv.AcCode = acCode.Text; inv.BankName = bankName.Text; inv.SlipNo = slipNo.Text; inv.ChqNo = chqNo.Text; inv.DocAmt = SafeValue.SafeDecimal(docAmt.Value, 0); inv.LocAmt = inv.DocAmt * inv.DocExRate; string[] currentPeriod = EzshipHelper.GetAccPeriod(docDate.Date); inv.AcYear = SafeValue.SafeInt(currentPeriod[1], docDate.Date.Year); inv.AcPeriod = SafeValue.SafeInt(currentPeriod[0], docDate.Date.Month); inv.OtherPartyName = otherPartyName.Text; inv.Pic = pic.Text; inv.IsReturn = isReturn.Checked; try { inv.UpdateBy = HttpContext.Current.User.Identity.Name; inv.UpdateDateTime = DateTime.Now; Manager.ORManager.StartTracking(inv, InitialState.Updated); Manager.ORManager.PersistChanges(inv); } catch { } } Session["ArRecWhere"] = "Id=" + inv.Id; this.dsArReceipt.FilterExpression = Session["ArRecWhere"].ToString(); if (this.ASPxGridView1.GetRow(0) != null) { this.ASPxGridView1.StartEdit(0); } #endregion }
public void FilldataSource_DataBind_Dev(Control Ctrl, string Sqlstr, object LinQ, Boolean ActivePropertyGrid) { if (_Conexion.State == ConnectionState.Closed) { _Conexion.Open(); } if (Sqlstr != "") { SqlDataAdapter MysqlAdapter = new SqlDataAdapter(Sqlstr, _Conexion); DataSet Mydataset = new DataSet(); MysqlAdapter.Fill(Mydataset); if (Ctrl is ASPxGridView) { ASPxGridView Ctrl1 = (ASPxGridView)Ctrl; Ctrl1.DataSource = Mydataset.Tables[0]; } if (Ctrl is ASPxGridLookup) { ASPxGridLookup Ctrl1 = (ASPxGridLookup)Ctrl; Ctrl1.DataSource = Mydataset.Tables[0]; } if (Ctrl is ASPxComboBox) { ASPxComboBox Ctrl1 = (ASPxComboBox)Ctrl; Ctrl1.DataSource = Mydataset.Tables[0]; } if (Ctrl is BootstrapComboBox) { BootstrapComboBox Ctrl1 = (BootstrapComboBox)Ctrl; Ctrl1.DataSource = Mydataset.Tables[0]; } } else { if (Ctrl is ASPxGridView) { ASPxGridView Ctrl1 = (ASPxGridView)Ctrl; Ctrl1.DataSource = LinQ; } if (Ctrl is ASPxGridLookup) { ASPxGridLookup Ctrl1 = (ASPxGridLookup)Ctrl; Ctrl1.DataSource = LinQ; } if (Ctrl is ASPxComboBox) { ASPxComboBox Ctrl1 = (ASPxComboBox)Ctrl; Ctrl1.DataSource = LinQ; } if (Ctrl is BootstrapComboBox) { BootstrapComboBox Ctrl1 = (BootstrapComboBox)Ctrl; Ctrl1.DataSource = LinQ; } } if (ActivePropertyGrid == false) { if (Ctrl is ASPxGridView) { ASPxGridView Ctrl1 = (ASPxGridView)Ctrl; Ctrl1.DataBind(); } if (Ctrl is ASPxGridLookup) { ASPxGridLookup Ctrl1 = (ASPxGridLookup)Ctrl; Ctrl1.DataBind(); } if (Ctrl is ASPxComboBox) { ASPxComboBox Ctrl1 = (ASPxComboBox)Ctrl; Ctrl1.DataBind(); } if (Ctrl is BootstrapComboBox) { BootstrapComboBox Ctrl1 = (BootstrapComboBox)Ctrl; Ctrl1.DataBind(); } } _Conexion.Close(); }
protected void ASPxGridView1_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e) { string filter = e.Parameters; ASPxTextBox oidCtr = this.ASPxGridView1.FindEditFormTemplateControl("txt_Oid") as ASPxTextBox; //ASPxTextBox docN = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox; if (filter == "P") { SaveBill(); #region Post string sql = @"SELECT AcYear, AcPeriod, DocType, DocNo, DocDate, DocCurrency, DocExRate, PartyTo, OtherPartyName, DocAmt, LocAmt, AcCode, AcSource, ChqNo, ChqDate, ExportInd, BankName, Remark,GenerateInd FROM pay_doc"; sql += " WHERE Id='" + oidCtr.Text + "'"; DataTable dt = Manager.ORManager.GetDataSet(sql).Tables[0]; int acYear = 0; int acPeriod = 0; string docN = ""; string docType = ""; string acSource = ""; string acCode = ""; decimal locAmt = 0; decimal docAmt = 0; decimal exRate = 0; string currency = ""; DateTime docDt = DateTime.Today; string remarks = ""; string partyTo = ""; string otherPartyName = ""; string chqNo = ""; string generateInd = ""; if (dt.Rows.Count == 1) { acYear = SafeValue.SafeInt(dt.Rows[0]["AcYear"], 0); acPeriod = SafeValue.SafeInt(dt.Rows[0]["AcPeriod"], 0); acSource = dt.Rows[0]["AcSource"].ToString(); acCode = dt.Rows[0]["AcCode"].ToString(); docN = dt.Rows[0]["DocNo"].ToString(); docType = dt.Rows[0]["DocType"].ToString(); locAmt = SafeValue.SafeDecimal(dt.Rows[0]["LocAmt"].ToString(), 0); docAmt = SafeValue.SafeDecimal(dt.Rows[0]["DocAmt"].ToString(), 0); exRate = SafeValue.SafeDecimal(dt.Rows[0]["DocExRate"].ToString(), 0); currency = dt.Rows[0]["DocCurrency"].ToString(); docDt = SafeValue.SafeDate(dt.Rows[0]["DocDate"], new DateTime(1900, 1, 1)); // partyId = dt.Rows[0][""].ToString(); remarks = dt.Rows[0]["Remark"].ToString(); partyTo = dt.Rows[0]["PartyTo"].ToString(); otherPartyName = dt.Rows[0]["OtherPartyName"].ToString(); chqNo = dt.Rows[0]["ChqNo"].ToString(); generateInd = SafeValue.SafeString(dt.Rows[0]["GenerateInd"]); } else { e.Result = "Can't find the ArReceipt!"; return; } if (generateInd.ToUpper() != "Y") { e.Result = "Have not generate no!"; return; } string sqlDet = string.Format("select count(Id) from pay_line where RepId='{0}'", oidCtr.Text); int detCnt = SafeValue.SafeInt(Manager.ORManager.ExecuteScalar(sqlDet), 0); if (detCnt == 0) { e.Result = "No Detail, Can't Post"; return; } sqlDet = string.Format("select max(docDate) from pay_line where RepId='{0}'", oidCtr.Text); DateTime maxLineDocDate = SafeValue.SafeDate(Manager.ORManager.ExecuteScalar(sqlDet), new DateTime(1900, 1, 1)); if (maxLineDocDate > new DateTime(2000, 1, 1) && maxLineDocDate > docDt) { e.Result = "The bill's Date can't be greater than receipt date."; return; } //check account period if (acYear < 1 || acPeriod < 1) { e.Result = "Account year or Period Invalid!"; return; } string sql1 = "select CloseInd from XXAccPeriod where Year='" + acYear + "' and Period ='" + acPeriod + "'"; string closeInd = SafeValue.SafeString(Manager.ORManager.ExecuteScalar(sql1), ""); if (closeInd == "") { e.Result = "Can't find this account period!"; return; } else if (closeInd == "Y") { e.Result = "The account period is closed!"; return; } //mast.amt det.amt is match sql = string.Format("select sum(locamt) from pay_line where RepId='{0}' and AcSource='CR'", oidCtr.Text); decimal amt_detCr = SafeValue.SafeDecimal(Manager.ORManager.ExecuteScalar(sql), 0); sql = string.Format("select sum(locamt) from pay_line where RepId='{0}' and AcSource='DB'", oidCtr.Text); decimal amt_detDb = SafeValue.SafeDecimal(Manager.ORManager.ExecuteScalar(sql), 0); if (docType == "RE" && locAmt != amt_detCr - amt_detDb) { e.Result = "Amount can't match, can't post"; return; } else if (docType == "PC" && locAmt != -amt_detCr + amt_detDb) { e.Result = "Amount can't match, can't post"; return; } sql = "select count(*) from pay_line where AcCode='' and RepId='" + oidCtr.Text + "'"; detCnt = SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar(sql), 0); if (detCnt > 0) { e.Result = "Some Item's Accode is blank, pls check"; return; } //delete old post data sql = string.Format("SELECT SequenceId from XAGlEntry WHERE DocNo='{0}' and DocType='{1}'", docN, docType); int glOldOid = SafeValue.SafeInt(Manager.ORManager.ExecuteScalar(sql), 0); if (glOldOid > 0) { DeleteGl(glOldOid); } //Insert into gl entry int glOid = 0; try { C2.XAGlEntry gl = new XAGlEntry(); gl.AcPeriod = acPeriod; gl.AcYear = acYear; gl.ArApInd = "AR"; gl.DocType = docType; gl.DocDate = docDt; gl.DocNo = docN; gl.CrAmt = docAmt; gl.DbAmt = docAmt; gl.CurrencyCrAmt = locAmt; gl.CurrencyDbAmt = locAmt; gl.CurrencyId = currency; gl.EntryDate = DateTime.Now; gl.ExRate = exRate; gl.PostDate = DateTime.Now; gl.PostInd = "N"; gl.Remark = remarks; gl.UserId = HttpContext.Current.User.Identity.Name; gl.CancelInd = "N"; gl.CancelDate = new DateTime(1900, 1, 1); gl.PartyTo = partyTo; gl.OtherPartyName = otherPartyName; gl.ChqNo = chqNo; gl.SupplierBillNo = ""; gl.SupplierBillDate = new DateTime(1900, 1, 1); Manager.ORManager.StartTracking(gl, InitialState.Inserted); Manager.ORManager.PersistChanges(gl); glOid = gl.SequenceId; //insert Detail OPathQuery query = new OPathQuery(typeof(pay_line), "RepId='" + oidCtr.Text + "'"); ObjectSet set = Manager.ORManager.GetObjectSet(query); int index = 1; XAGlEntryDet det1 = new XAGlEntryDet(); det1.AcCode = acCode; det1.ArApInd = "AR"; det1.AcPeriod = acPeriod; det1.AcSource = acSource; det1.AcYear = acYear; det1.CrAmt = 0; det1.CurrencyCrAmt = 0; det1.DbAmt = docAmt; det1.CurrencyDbAmt = locAmt; det1.CurrencyId = currency; det1.DocNo = docN; det1.DocType = docType; det1.ExRate = exRate; det1.GlLineNo = index; det1.GlNo = gl.SequenceId; det1.Remark = remarks; Manager.ORManager.StartTracking(det1, InitialState.Inserted); Manager.ORManager.PersistChanges(det1); for (int i = 0; i < set.Count; i++) { try { index++; pay_line invDet = set[i] as pay_line; XAGlEntryDet det = new XAGlEntryDet(); det.AcCode = invDet.AcCode; det.ArApInd = "AR"; det.AcPeriod = acPeriod; det.AcSource = invDet.AcSource; det.AcYear = acYear; if (invDet.AcSource == "DB") { det.DbAmt = invDet.DocAmt; det.CurrencyDbAmt = invDet.LocAmt; det.CrAmt = 0; det.CurrencyCrAmt = 0; } else// if (det.AcSource == "CR") { det.CrAmt = invDet.DocAmt; det.CurrencyCrAmt = invDet.LocAmt; det.DbAmt = 0; det.CurrencyDbAmt = 0; } det.CurrencyId = invDet.Currency; det.DocNo = docN; det.DocType = docType; det.ExRate = invDet.ExRate; det.GlLineNo = index; det.GlNo = gl.SequenceId; det.Remark = invDet.Remark1; Manager.ORManager.StartTracking(det, InitialState.Inserted); Manager.ORManager.PersistChanges(det); } catch { e.Result = "Posting Error, Please repost!"; DeleteGl(glOid); } } UpdateArInv(oidCtr.Text); EzshipLog.Log(docN, "", docType, "Post"); e.Result = "Post completely!"; } catch { e.Result = "Posting Error, Please repost!"; DeleteGl(glOid); } #endregion } else if (filter == "DD") { #region delete receipt try { string sql = "SELECT Id,DocId, DocType FROM pay_line where RepId ='" + oidCtr.Text + "'"; DataTable tab = C2.Manager.ORManager.GetDataSet(sql).Tables[0]; for (int i = 0; i < tab.Rows.Count; i++) { try { string id = tab.Rows[i]["Id"].ToString(); string docId = tab.Rows[i]["DocId"].ToString(); string docType = tab.Rows[i]["DocType"].ToString(); string sql_det = "delete from pay_line where Id='" + id + "'"; if (C2.Manager.ORManager.ExecuteCommand(sql_det) > 0) { UpdateMaster(docId, docType); } } catch (Exception ex) { throw new Exception(ex.Message); } } } catch (Exception ex) { throw new Exception(ex.Message); } #endregion } else if (filter == "Reverse") { #region reverse receipt 0:period is closed? 1:unpost 2:exportind='N' 3: delete all item try { string sql1 = string.Format("select CloseInd from xxaccperiod where Year=(select AcYear from pay_doc where Id='{0}') and Period=(select top(1)AcPeriod from pay_doc where SequenceId='{0}')", oidCtr.Text); if (SafeValue.SafeString(ConnectSql.ExecuteScalar(sql1)) != "N") { throw new Exception("Acc Period is Closed!"); } string sql_invoice = string.Format("select sequenceid from xaglentry where ArApInd='AR' and docno=(select docno from pay_doc where id='{0}') and DocType=(select doctype from pay_doc where id='{0}') ", oidCtr.Text); DeleteGl(SafeValue.SafeInt(ConnectSql.ExecuteScalar(sql_invoice), 0)); sql_invoice = "update pay_doc set IsReturn='true', ExportInd='N' where Id='" + oidCtr.Text + "'"; Manager.ORManager.ExecuteCommand(sql_invoice); string sql = "SELECT Id,DocId, DocType FROM pay_line where RepId ='" + oidCtr.Text + "'"; DataTable tab = C2.Manager.ORManager.GetDataSet(sql).Tables[0]; for (int i = 0; i < tab.Rows.Count; i++) { try { string id = tab.Rows[i]["Id"].ToString(); string docId = tab.Rows[i]["DocId"].ToString(); string docType = tab.Rows[i]["DocType"].ToString(); string sql_det = "delete from pay_line where Id='" + id + "'"; if (C2.Manager.ORManager.ExecuteCommand(sql_det) > 0) { UpdateMaster(docId, docType); } } catch (Exception ex) { throw new Exception(ex.Message); } } } catch (Exception ex) { throw new Exception(ex.Message); } #endregion } else if (filter == "GainLoss") { #region GAIN LOSS ASPxComboBox docType = this.ASPxGridView1.FindEditFormTemplateControl("cbo_DocType") as ASPxComboBox; string sql = string.Format("select (select LocAmt from pay_doc where Id='{0}')-iSNULL(sum(case when AcSource='CR' then -LocAmt else LocAmt end),0) As LocAmt from pay_line where repid='{0}'", oidCtr.Text); if (docType.Text == "RE") { sql = string.Format("select (select LocAmt from pay_doc where Id='{0}')-iSNULL(sum(case when AcSource='DB' then -LocAmt else LocAmt end),0) As LocAmt from pay_line where repid='{0}'", oidCtr.Text); } decimal balAmt = SafeValue.SafeDecimal(C2.Manager.ORManager.ExecuteScalar(sql), 0); if (balAmt > 0) { string gainAccCode = System.Configuration.ConfigurationManager.AppSettings["GainLoseAcCode"]; pay_line det = new pay_line(); det.AcCode = gainAccCode; if (docType.Text == "RE") { det.AcSource = "CR"; } else { det.AcSource = "DB"; } det.DocType = docType.Text; det.RepType = docType.Text; det.Currency = System.Configuration.ConfigurationManager.AppSettings["Currency"]; det.DocAmt = balAmt; det.DocDate = new DateTime(1900, 1, 1); det.DocId = 0; det.DocNo = ""; det.ExRate = 1; det.LocAmt = balAmt; det.Remark1 = "GAIN AND LOSS"; det.Remark2 = ""; det.Remark3 = ""; det.RepId = SafeValue.SafeInt(oidCtr.Text, 0); ASPxTextBox docN = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox; det.RepNo = docN.Text; string sql_detCnt = "select count(DocNo) from pay_line where RepId='" + oidCtr.Text + "'"; int lineNo = SafeValue.SafeInt(Manager.ORManager.ExecuteScalar(sql_detCnt), 0) + 1; det.RepLineNo = lineNo; C2.Manager.ORManager.StartTracking(det, Wilson.ORMapper.InitialState.Inserted); C2.Manager.ORManager.PersistChanges(det); } else if (balAmt < 0) { string gainAccCode = System.Configuration.ConfigurationManager.AppSettings["GainLoseAcCode"]; pay_line det = new pay_line(); det.AcCode = gainAccCode; if (docType.Text == "RE") { det.AcSource = "DB"; } else { det.AcSource = "CR"; } det.DocType = docType.Text; det.RepType = docType.Text; det.Currency = System.Configuration.ConfigurationManager.AppSettings["Currency"]; det.DocAmt = -balAmt; det.DocDate = new DateTime(1900, 1, 1); det.DocId = 0; det.DocNo = ""; det.ExRate = 1; det.LocAmt = -balAmt; det.Remark1 = "GAIN AND LOSS"; det.Remark2 = ""; det.Remark3 = ""; det.RepId = SafeValue.SafeInt(oidCtr.Text, 0); ASPxTextBox docN = this.ASPxGridView1.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox; det.RepNo = docN.Text; string sql_detCnt = "select count(DocNo) from pay_line where RepId='" + oidCtr.Text + "'"; int lineNo = SafeValue.SafeInt(Manager.ORManager.ExecuteScalar(sql_detCnt), 0) + 1; det.RepLineNo = lineNo; C2.Manager.ORManager.StartTracking(det, Wilson.ORMapper.InitialState.Inserted); C2.Manager.ORManager.PersistChanges(det); } #endregion } else if (filter == "Generate") { string sql = @"SELECT DocType, DocDate FROM pay_doc WHERE Id='" + oidCtr.Text + "'"; DataTable dt = Manager.ORManager.GetDataSet(sql).Tables[0]; if (dt.Rows.Count == 1) { DateTime docDate = SafeValue.SafeDate(dt.Rows[0]["DocDate"], DateTime.Today); string docType = SafeValue.SafeString(dt.Rows[0]["DocType"]); string invN = C2Setup.GetNextNo(docType, "AR-RECEIPT", docDate); sql = string.Format("Update pay_doc set DocNo='{1}',GenerateInd='Y' where Id='{0}'", oidCtr.Text, invN); if (ConnectSql.ExecuteSql(sql) > -1) { C2Setup.SetNextNo(docType, "AR-RECEIPT", invN, docDate); } e.Result = invN; } } }
protected void GridOrderDetail_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { string[] parameter = e.Parameters.Split(':'); switch (parameter[0]) { case ("Save"): int rowKey; int intSortShipper = 0; int intQuantity = 0; int intShipper = 0; for (int i = 0; i < GridOrderDetail.VisibleRowCount; i++) { rowKey = Convert.ToInt32(GridOrderDetail.GetRowValues(Convert.ToInt32(i), "OrderDetailID")); if (GridOrderDetail.IsGroupRow(i)) { ASPxSpinEdit spinSortShipper = (ASPxSpinEdit)GridOrderDetail.FindGroupRowTemplateControl(i, "spinSortShipper"); ((IPostBackDataHandler)spinSortShipper).LoadPostData("spinSortShipper", Request.Form); intSortShipper = Convert.ToInt32(spinSortShipper.Value); ASPxComboBox cboShipper = (ASPxComboBox)GridOrderDetail.FindGroupRowTemplateControl(i, "cboShipper"); ((IPostBackDataHandler)cboShipper).LoadPostData("cboShipper", Request.Form); intShipper = Convert.ToInt32(cboShipper.Value); ASPxSpinEdit spinQuantity = (ASPxSpinEdit)GridOrderDetail.FindGroupRowTemplateControl(i, "spinQuantity"); ((IPostBackDataHandler)spinQuantity).LoadPostData("spinQuantity", Request.Form); intQuantity = Convert.ToInt32(spinQuantity.Value); } if (!GridOrderDetail.IsGroupRow(i)) { ASPxComboBox cboProduct = (ASPxComboBox)GridOrderDetail.FindRowCellTemplateControl(i, (GridViewDataComboBoxColumn)GridOrderDetail.Columns["ProductID"], "cboProduct"); ((IPostBackDataHandler)cboProduct).LoadPostData("cboProduct", Request.Form); ASPxSpinEdit spinSortProduct = (ASPxSpinEdit)GridOrderDetail.FindRowCellTemplateControl(i, (GridViewDataSpinEditColumn)GridOrderDetail.Columns["SortProduct"], "spinSortProduct"); ((IPostBackDataHandler)spinSortProduct).LoadPostData("spinSortProduct", Request.Form); ASPxSpinEdit spinDefaultPrice = (ASPxSpinEdit)GridOrderDetail.FindRowCellTemplateControl(i, (GridViewDataSpinEditColumn)GridOrderDetail.Columns["DefaultPrice"], "spinDefaultPrice"); ((IPostBackDataHandler)spinDefaultPrice).LoadPostData("spinDefaultPrice", Request.Form); ASPxSpinEdit spinUnitPrice = (ASPxSpinEdit)GridOrderDetail.FindRowCellTemplateControl(i, (GridViewDataSpinEditColumn)GridOrderDetail.Columns["UnitPrice"], "spinUnitPrice"); ((IPostBackDataHandler)spinUnitPrice).LoadPostData("spinUnitPrice", Request.Form); ASPxSpinEdit spinDiscount = (ASPxSpinEdit)GridOrderDetail.FindRowCellTemplateControl(i, (GridViewDataSpinEditColumn)GridOrderDetail.Columns["Discount"], "spinDiscount"); ((IPostBackDataHandler)spinDiscount).LoadPostData("spinDiscount", Request.Form); ASPxSpinEdit spinIncrease = (ASPxSpinEdit)GridOrderDetail.FindRowCellTemplateControl(i, (GridViewDataSpinEditColumn)GridOrderDetail.Columns["Increase"], "spinIncrease"); ((IPostBackDataHandler)spinIncrease).LoadPostData("spinIncrease", Request.Form); ASPxSpinEdit spinRowTotal = (ASPxSpinEdit)GridOrderDetail.FindRowCellTemplateControl(i, (GridViewDataSpinEditColumn)GridOrderDetail.Columns["TotalPrice"], "spinRowTotal"); ((IPostBackDataHandler)spinRowTotal).LoadPostData("spinRowTotal", Request.Form); ASPxSpinEdit spinRowTotalCustomer = (ASPxSpinEdit)GridOrderDetail.FindRowCellTemplateControl(i, (GridViewDataSpinEditColumn)GridOrderDetail.Columns["TotalCustomer"], "spinRowTotalCustomer"); ((IPostBackDataHandler)spinRowTotalCustomer).LoadPostData("spinRowTotalCustomer", Request.Form); SqlCommand comm = new SqlCommand(); comm.Connection = con; comm.CommandText = "update OrderDetails set SortProduct = @SortProduct, DefaultPrice = @DefaultPrice, UnitPrice = @UnitPrice,Discount = @Discount, Increase = @Increase, TotalPrice = @TotalPrice, TotalCustomer = @TotalCustomer, SortShipper = @SortShipper, Quantity = @Quantity, ShipperID = @ShipperID, ProductID = @ProductID " + "where OrderDetailID = @OrderDetailID"; comm.Parameters.AddWithValue("@OrderDetailID", rowKey); comm.Parameters.AddWithValue("@ShipperID", Convert.ToInt32(intShipper)); comm.Parameters.AddWithValue("@SortShipper", Convert.ToInt32(intSortShipper)); comm.Parameters.AddWithValue("@Quantity", Convert.ToInt32(intQuantity)); comm.Parameters.AddWithValue("@ProductID", Convert.ToInt32(cboProduct.Value)); comm.Parameters.AddWithValue("@SortProduct", Convert.ToInt32(spinSortProduct.Value)); comm.Parameters.AddWithValue("@DefaultPrice", Convert.ToDouble(spinDefaultPrice.Value)); comm.Parameters.AddWithValue("@UnitPrice", Convert.ToDouble(spinUnitPrice.Value)); comm.Parameters.AddWithValue("@Discount", Convert.ToDouble(spinDiscount.Value)); comm.Parameters.AddWithValue("@Increase", Convert.ToDouble(spinIncrease.Value)); comm.Parameters.AddWithValue("@TotalPrice", Convert.ToDouble(spinRowTotal.Value)); comm.Parameters.AddWithValue("@TotalCustomer", Convert.ToDouble(spinRowTotalCustomer.Value)); con.Open(); comm.ExecuteNonQuery(); con.Close(); } } ASPxSpinEdit spinDiscountTotal = (ASPxSpinEdit)GridOrderDetail.FindFooterCellTemplateControl((GridViewDataSpinEditColumn)GridOrderDetail.Columns["Discount"], "spinDiscountTotal"); ((IPostBackDataHandler)spinDiscountTotal).LoadPostData("spinDiscountTotal", Request.Form); ASPxSpinEdit spinIncreaseTotal = (ASPxSpinEdit)GridOrderDetail.FindFooterCellTemplateControl((GridViewDataSpinEditColumn)GridOrderDetail.Columns["Increase"], "spinIncreaseTotal"); ((IPostBackDataHandler)spinIncreaseTotal).LoadPostData("spinIncreaseTotal", Request.Form); ASPxSpinEdit spinGrandTotal = (ASPxSpinEdit)GridOrderDetail.FindFooterCellTemplateControl((GridViewDataSpinEditColumn)GridOrderDetail.Columns["TotalPrice"], "spinGrandTotal"); ((IPostBackDataHandler)spinGrandTotal).LoadPostData("spinGrandTotal", Request.Form); ASPxSpinEdit spinGrandTotalCustomer = (ASPxSpinEdit)GridOrderDetail.FindFooterCellTemplateControl((GridViewDataSpinEditColumn)GridOrderDetail.Columns["TotalCustomer"], "spinGrandTotalCustomer"); ((IPostBackDataHandler)spinGrandTotalCustomer).LoadPostData("spinGrandTotalCustomer", Request.Form); SqlCommand commTotal = new SqlCommand(); commTotal.Connection = con; commTotal.CommandText = "update Orders set TotalDiscount = @TotalDiscount, TotalIncrease = @TotalIncrease, GrandTotal = @GrandTotal, TotalCustomer = @TotalCustomer " + "where OrderID = @OrderID"; commTotal.Parameters.AddWithValue("@OrderID", Convert.ToInt32(Request.Params["OrderID"])); commTotal.Parameters.AddWithValue("@TotalDiscount", Convert.ToDouble(spinDiscountTotal.Value)); commTotal.Parameters.AddWithValue("@TotalIncrease", Convert.ToDouble(spinIncreaseTotal.Value)); commTotal.Parameters.AddWithValue("@GrandTotal", Convert.ToDouble(spinGrandTotal.Value)); commTotal.Parameters.AddWithValue("@TotalCustomer", Convert.ToDouble(spinGrandTotalCustomer.Value)); con.Open(); commTotal.ExecuteNonQuery(); con.Close(); GridOrderDetail.DataBind(); switch (parameter[1]) { case ("New"): GridOrderDetail.AddNewRow(); break; } break; } }
protected void SavePrice() { try { ASPxPageControl pageControl = this.grid_Price.FindEditFormTemplateControl("pageControl_Hbl") as ASPxPageControl; ASPxTextBox txt_Id = grid_Price.FindEditFormTemplateControl("txt_Id") as ASPxTextBox; string pId = SafeValue.SafeString(txt_Id.Text, ""); Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(WhTrans), "Id='" + pId + "'"); WhTrans whTrans = C2.Manager.ORManager.GetObject(query) as WhTrans; ASPxDateEdit issueDate = grid_Price.FindEditFormTemplateControl("date_IssueDate") as ASPxDateEdit; bool isNew = false; //const string runType = "DOOUT"; string issueN = ""; if (whTrans == null) { whTrans = new WhTrans(); isNew = true; issueN = C2Setup.GetNextNo("", "SalePrice", issueDate.Date); whTrans.DoDate = issueDate.Date; } ASPxDateEdit doDate = grid_Price.FindEditFormTemplateControl("date_IssueDate") as ASPxDateEdit; whTrans.DoDate = doDate.Date; ASPxDateEdit txt_ExpectedDate = this.grid_Price.FindEditFormTemplateControl("txt_ExpectedDate") as ASPxDateEdit; whTrans.ExpectedDate = txt_ExpectedDate.Date; ASPxComboBox doStatus = grid_Price.FindEditFormTemplateControl("cmb_Status") as ASPxComboBox; whTrans.DoStatus = SafeValue.SafeString(doStatus.Value); //Main Info ASPxButtonEdit txt_PartyId = grid_Price.FindEditFormTemplateControl("txt_PartyId") as ASPxButtonEdit; whTrans.PartyId = txt_PartyId.Text; ASPxTextBox txt_PartyName = grid_Price.FindEditFormTemplateControl("txt_PartyName") as ASPxTextBox; whTrans.PartyName = txt_PartyName.Text; if (txt_PartyName.Text == "") { throw new Exception("Customer not be null!!!"); return; } ASPxMemo remark = grid_Price.FindEditFormTemplateControl("txt_Remark") as ASPxMemo; whTrans.Remark = remark.Text; string userId = HttpContext.Current.User.Identity.Name; if (isNew) { whTrans.StatusCode = "USE"; whTrans.CreateBy = userId; whTrans.CreateDateTime = DateTime.Now; whTrans.UpdateBy = userId; whTrans.UpdateDateTime = DateTime.Now; whTrans.DoType = "SQ"; whTrans.DoNo = issueN; Manager.ORManager.StartTracking(whTrans, Wilson.ORMapper.InitialState.Inserted); Manager.ORManager.PersistChanges(whTrans); C2Setup.SetNextNo("", "SalePrice", issueN, issueDate.Date); } else { whTrans.UpdateBy = userId; whTrans.UpdateDateTime = DateTime.Now; Manager.ORManager.StartTracking(whTrans, Wilson.ORMapper.InitialState.Updated); Manager.ORManager.PersistChanges(whTrans); } Session["PriceWhere"] = "DoNo='" + whTrans.DoNo + "'"; this.dsPrice.FilterExpression = Session["PriceWhere"].ToString(); if (this.grid_Price.GetRow(0) != null) { this.grid_Price.StartEdit(0); } } catch { } }
public static void Set_DDLORG_LV3_BY_LV1_2(ASPxComboBox ddl, string wh) { try { string sql = "select ORG_SERIAL,ORG_NAME,ORG_ABBR from vw_SMM_ORG_LEVEL3 where 1=1 "; if (wh != "76") { sql += " AND UPPER_ORG_SERIAL = " + wh; } sql += " Order by ORG_SERIAL"; SqlDataAdapter da = new SqlDataAdapter(sql, StaticDefaultConnectionString); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { ddl.Columns.Clear(); ddl.ValueField = "ORG_SERIAL"; ddl.TextField = "ORG_NAME"; ddl.DataSource = dt; ddl.DataBind(); } else { ddl.Columns.Clear(); ddl.ValueField = "ORG_SERIAL"; ddl.TextField = "ORG_NAME"; ddl.DataSource = dt; ddl.DataBind(); } } catch (Exception ex) { } }
protected void grdFinanceBudgetDet_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxGridView grid = sender as ASPxGridView; ASPxComboBox entCode = grdFinanceBudgetDet.FindEditRowCellTemplateControl((GridViewDataColumn)grdFinanceBudgetDet.Columns["EntityCodeDesc"], "Entity") as ASPxComboBox; ASPxCallbackPanel callBackPanel = grdFinanceBudgetDet.FindEditRowCellTemplateControl((GridViewDataColumn)grdFinanceBudgetDet.Columns["BUSSUCodeDesc"], "FinBUCallbackPanel") as ASPxCallbackPanel; ASPxComboBox buCode = callBackPanel.FindControl("BUSSU") as ASPxComboBox; string sLastModified = DateTime.Now.ToString(); SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); string sBUCode = ""; if (buCode.Value != null) { sBUCode = buCode.Value.ToString(); } string insert = "INSERT INTO tbl_System_FinanceBudget_Details ([MasterKey], [EntityCode], [BUSSUCode]) " + " VALUES (@MasterKey, @EntityCode, @BUSSUCode)"; SqlCommand cmd = new SqlCommand(insert, conn); cmd.Parameters.AddWithValue("@MasterKey", iMasterKey.ToString()); cmd.Parameters.AddWithValue("@EntityCode", entCode.Value.ToString()); cmd.Parameters.AddWithValue("@BUSSUCode", sBUCode); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); string updateMaster = "UPDATE tbl_System_FinanceBudget " + " SET [LastModified] = @LastModified " + " WHERE ([PK] = @PK)"; SqlCommand cmd1 = new SqlCommand(updateMaster, conn); cmd1.Parameters.AddWithValue("@PK", iMasterKey.ToString()); cmd1.Parameters.AddWithValue("@LastModified", sLastModified.ToString()); cmd1.CommandType = CommandType.Text; cmd1.ExecuteNonQuery(); e.Cancel = true; grid.CancelEdit(); BindFinanceBudgetDet(iMasterKey); int pk_latest = 0; string query_pk = "SELECT TOP 1 [PK] FROM tbl_System_FinanceBudget_Details ORDER BY [PK] DESC"; SqlCommand comm = new SqlCommand(query_pk, conn); SqlDataReader r = comm.ExecuteReader(); while (r.Read()) { pk_latest = Convert.ToInt32(r[0].ToString()); } conn.Close(); if (pk_latest > 0) { FocusThisRowGrid(grid, pk_latest); } }
protected override void AssignControllerValues() { ASPxTextBox tbSubject = (ASPxTextBox)FindControlByID("tbSubject"); ASPxTextBox tbLocation = (ASPxTextBox)FindControlByID("tbLocation"); ASPxMemo tbDescription = (ASPxMemo)FindControlByID("tbDescription"); ASPxDateEdit edtStartDate = (ASPxDateEdit)FindControlByID("edtStartDate"); ASPxDateEdit edtEndDate = (ASPxDateEdit)FindControlByID("edtEndDate"); ASPxCheckBox chkAllDay = (ASPxCheckBox)FindControlByID("chkAllDay"); ASPxComboBox edtShowTimeAs = (ASPxComboBox)FindControlByID("edtStatus"); ASPxComboBox edtLabel = (ASPxComboBox)FindControlByID("edtLabel"); ASPxCheckBox chkReminder = (ASPxCheckBox)FindControlByID("chkReminder"); ASPxComboBox cbReminder = (ASPxComboBox)FindControlByID("cbReminder"); Repeater rpResources = (Repeater)FindControlByID("rpResources"); DateTime clientStart = DateTime.MinValue; DateTime clientEnd = DateTime.MinValue; if (edtStartDate != null) { clientStart = FromClientTime(edtStartDate.Date); Controller.EditedAppointmentCopy.Start = clientStart; } if (edtEndDate != null) { clientEnd = FromClientTime(edtEndDate.Date); Controller.EditedAppointmentCopy.End = clientEnd; } if (tbSubject != null) { Controller.Subject = tbSubject.Text; } if (tbLocation != null) { Controller.Location = tbLocation.Text; } if (tbDescription != null) { Controller.Description = tbDescription.Text; } if (chkAllDay != null) { Controller.AllDay = chkAllDay.Checked; } if (edtShowTimeAs != null) { Controller.StatusId = Convert.ToInt32(edtShowTimeAs.Value); } if (edtLabel != null) { Controller.LabelId = Convert.ToInt32(edtLabel.Value); } if (chkReminder.Checked) { TimeSpan reminderTime = TimeSpan.Parse((string)cbReminder.Value); Controller.HasReminder = true; Controller.ReminderTimeBeforeStart = reminderTime; } Controller.ResourceIds.Clear(); foreach (RepeaterItem ri in rpResources.Items) { ASPxCheckBox chkResource = ri.FindControl("chkResource") as ASPxCheckBox; if (chkResource.Checked == true) { ASPxHiddenField field = ri.FindControl("hfResource") as ASPxHiddenField; object resourceIdObject = null; bool success = field.TryGet("resourceId", out resourceIdObject); if (!success) { continue; } string resourceIdString = resourceIdObject.ToString(); int resourceId = int.Parse(resourceIdString); Controller.ResourceIds.Add(resourceId); } } AssignControllerRecurrenceValues(clientStart); }
}//end update /// <summary> /// we don't actually need an insert sub as shipment/vessel data is part of the ordertable which must have /// been saved before we get to shipment/vessel /// </summary> protected void insert_shipment() { try { //use order id 303635 for testing purposes int _orderid = wwi_func.vint(wwi_security.DecryptString(get_token("pid"), "publiship")); if (_orderid > 0) { OrderTable _t = new OrderTable(_orderid); //dlls //dlls int? _intnull = null; ASPxComboBox _cb = (ASPxComboBox)this.fmvShipment.FindControl("dxcboVesselID"); if (_cb != null) { _t.VesselID = _cb.Value != null?wwi_func.vint(_cb.Value.ToString()) : _intnull; } _cb = (ASPxComboBox)this.fmvShipment.FindControl("dxcboPackageTypeID"); if (_cb != null) { _t.PackageTypeID = _cb.Value != null?wwi_func.vint(_cb.Value.ToString()) : _intnull; } //why are the LCL/FCL values set to lcl=1, fcl=2 when the db data type is a bit? this doesn't make any sense //disbable code until confirmation from dave //_cb = (ASPxComboBox)this.fmvShipment.FindControl("dxcboFCLLCL"); //if (_cb != null && _cb.Value != null) { // string _lclfcl = _cb.Value.ToString(); // _t.Fcllcl = _lclfcl == "-1" ? true : false : false; //0 or -1 //} ASPxTextBox _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtEstPallets"); if (_tx != null && _tx.Text != "") { _t.EstPallets = wwi_func.vint(_tx.Text.ToString()); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtEstCartons"); if (_tx != null && _tx.Text != "") { _t.EstCartons = wwi_func.vint(_tx.Text.ToString()); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtEstWeight"); if (_tx != null && _tx.Text != "") { _t.EstWeight = wwi_func.vint(_tx.Text.ToString()); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtEstVolume"); if (_tx != null && _tx.Text != "") { _t.EstVolume = wwi_func.vfloat(_tx.Text.ToString()); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtEstLCLWt"); if (_tx != null && _tx.Text != "") { _t.EstLCLWt = wwi_func.vint(_tx.Text.ToString()); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtEstLCLVol"); if (_tx != null && _tx.Text != "") { _t.EstLCLVol = wwi_func.vfloat(_tx.Text.ToString()); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtEst20"); if (_tx != null && _tx.Text != "") { _t.Est20 = wwi_func.vint(_tx.Text.ToString()); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtEst40"); if (_tx != null && _tx.Text != "") { _t.Est40 = wwi_func.vint(_tx.Text.ToString()); } //actuals _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtActualWeight"); if (_tx != null && _tx.Text != "") { _t.ActualWeight = wwi_func.vint(_tx.Text.ToString()); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtActualVolume"); if (_tx != null && _tx.Text != "") { _t.ActualVolume = wwi_func.vfloat(_tx.Text.ToString()); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtLCLWt"); if (_tx != null && _tx.Text != "") { _t.LCLWt = wwi_func.vint(_tx.Text.ToString()); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtLCLvol"); if (_tx != null && _tx.Text != "") { _t.LCLVol = wwi_func.vfloat(_tx.Text.ToString()); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtActual20"); if (_tx != null && _tx.Text != "") { _t.No20 = wwi_func.vint(_tx.Text.ToString()); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtActual40"); if (_tx != null && _tx.Text != "") { _t.No40 = wwi_func.vint(_tx.Text.ToString()); } //other _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtNumberOfPackages"); if (_tx != null && _tx.Text != "") { _t.NumberOfPackages = wwi_func.vint(_tx.Text.ToString()); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtHouseBLNUmber"); if (_tx != null && _tx.Text != "") { _t.HouseBLNUmber = _tx.Text.ToString(); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtJackets"); if (_tx != null && _tx.Text != "") { _t.Jackets = wwi_func.vint(_tx.Text.ToString()); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtConsolNumber"); if (_tx != null && _tx.Text != "") { _t.ConsolNumber = wwi_func.vint(_tx.Text.ToString()); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtConsolNumber"); if (_tx != null && _tx.Text != "") { _t.HodderPricePerCopy = wwi_func.vfloat(_tx.Text.ToString()); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtHCCompositeRef"); if (_tx != null && _tx.Text != "") { _t.HCCompositeRef = _tx.Text.ToString(); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtHCInvoiceAmount2"); if (_tx != null && _tx.Text != "") { _t.HCInvoiceAmount = wwi_func.vdecimal(_tx.Text.ToString()); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtInsuranceValue"); if (_tx != null && _tx.Text != "") { _t.InsuranceValue = wwi_func.vdecimal(_tx.Text.ToString()); } _tx = (ASPxTextBox)this.fmvShipment.FindControl("dxtxtImpression"); if (_tx != null && _tx.Text != "") { _t.Impression = _tx.Text.ToString(); } //datetimes DateTime? _dtnull = null; //default for nullable datetimes ASPxDateEdit _dt = (ASPxDateEdit)this.fmvShipment.FindControl("dxdtETS"); if (_dt != null) { _t.Ets = _dt.Value != null?wwi_func.vdatetime(_dt.Date.ToString()) : _dtnull; } _dt = (ASPxDateEdit)this.fmvShipment.FindControl("dxdtETA"); if (_dt != null) { _t.Eta = _dt.Value != null?wwi_func.vdatetime(_dt.Date.ToString()) : _dtnull; } _dt = (ASPxDateEdit)this.fmvShipment.FindControl("dxdtJobClosureDate"); if (_dt != null) { _t.JobClosureDate = _dt.Value != null?wwi_func.vdatetime(_dt.Date.ToString()) : _dtnull; } _dt = (ASPxDateEdit)this.fmvShipment.FindControl("dxdtWarehouseDate"); if (_dt != null) { _t.WarehouseDate = _dt.Value != null?wwi_func.vdatetime(_dt.Date.ToString()) : _dtnull; } //checkboxes ASPxCheckBox _ck = (ASPxCheckBox)this.fmvShipment.FindControl("dxckJobClosed"); if (_ck != null) { _t.JobClosed = _ck.Checked; } _ck = (ASPxCheckBox)this.fmvShipment.FindControl("dxckOnBoard"); if (_ck != null) { _t.ShippedOnBoard = _ck.Checked; } //update record _t.Save(); } } catch (Exception ex) { string _orderno = wwi_security.DecryptString(get_token("pno"), "publiship"); string _ex = ex.Message.ToString(); this.dxlblErr.Text = string.Format("Order # {0} NOT updated. Error: {1}", _orderno, _ex); this.dxpnlErr.ClientVisible = true; } }//end insert
protected void Combo_Load(object sender, EventArgs e) { ASPxComboBox s = sender as ASPxComboBox; s.Value = dg.SettingsPager.PageSize; }
/// <summary> /// update event for ETS grid /// check DATE. if it's been changed will need to update order table /// ordertable.ETS = new ETS, ordertable.VesselLastUpdated = now where ordertable.PortID = OriginPortID and ordertable.VesselID = VesselID /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void dxgrdETS_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxGridView _grd = (ASPxGridView)sender; int _voyageid = this.dxhfOrder.Contains("voyage") ? wwi_func.vint(this.dxhfOrder.Get("voyage").ToString()) : 0; int _vesselid = this.dxhfOrder.Contains("vessel") ? wwi_func.vint(this.dxhfOrder.Get("vessel").ToString()) : 0; //key for this record int _etsid = e.Keys["VoyageETSSubID"] != null?wwi_func.vint(e.Keys["VoyageETSSubID"].ToString()) : 0; //other required data int _portid = e.NewValues["OriginPortID"] != null?wwi_func.vint(e.NewValues["OriginPortID"].ToString()) : 0; DateTime?_dtets = e.NewValues["ETS"] != null?wwi_func.vdatetime(e.NewValues["ETS"].ToString()) : (DateTime?)null; ASPxComboBox _cbo = (ASPxComboBox)this.fmvVoyage.FindControl("dxcboVesselID"); if (_cbo != null && _cbo.Value != null) { _vesselid = wwi_func.vint(_cbo.Value.ToString()); } if (_etsid > 0) { VoyageETSSubTable _tbl = new VoyageETSSubTable(_etsid); _tbl.OriginPortID = _portid; _tbl.Ets = _dtets; _tbl.Save(); //***** for testing //_portid = 1; //_vesselid = 3246; //***** //update ordertable if _portid > 0 and _vesselid > 0 //use voayge id NOT vessel id //if (_portid > 0 && _vesselid > 0) //&& (e.NewValues["ETS"] != e.OldValues["ETS"])) if (_portid > 0 && _voyageid > 0) { //update_ordertable_ets(_portid, _vesselid, _dtets); update_ordertable_ets(_portid, _voyageid, _dtets); //also does not work! //string[] _cols = { "OrderID", "ETS", "VesselLastUpdated" }; //SqlQuery _qry = new Select(_cols).From(DAL.Logistics.Tables.OrderTable). // Where(OrderTable.PortIDColumn).IsEqualTo(_portid).And(OrderTable.VesselIDColumn).IsEqualTo(_vesselid); //DataTable _dt = new DataTable(); //DataColumn[] _col = { _dt.Columns["OrderID"] }; //need to define a primary key for update to work //_dt.PrimaryKey = _col; // //SqlDataAdapter _da = new SqlDataAdapter(); //SqlCommandBuilder _cb = new SqlCommandBuilder(_da); //ConnectionStringSettings _cs = ConfigurationManager.ConnectionStrings["PublishipSQLConnectionString"]; //using (SqlConnection _con = new SqlConnection(_cs.ConnectionString)) //using (SqlCommand _cmd = new SqlCommand()) //{ //_cmd.CommandText = "SELECT OrderID, ETS, VesselLastUpdated FROM OrderTable WHERE ((PortID=@idport) AND (VesselID=@idvessel));"; //_cmd.Parameters.AddWithValue("@idport", _portid); //_cmd.Parameters.AddWithValue("@idvessel", _vesselid); //_cmd.Connection = _con; //_da.SelectCommand = _cmd; //_da.Fill(_dt); //for (int _ix = 0; _ix < _dt.Rows.Count; _ix++) //{ // _dt.Rows[_ix]["ETS"] = Convert.ToDateTime(_dtets); // _dt.Rows[_ix]["VesselLastUpdated"] = Convert.ToDateTime(_now); //} // //int _result = _da.Update(_dt); //} //does not work //string _sql = "UPDATE OrderTable " + // "SET OrderTable.Ets=@etsdate, " + // "OrderTable.VesselLastUpdated=@now " + // "FROM OrderTable as o " + // "WHERE o.OrderID IN (SELECT DISTINCT OrderID FROM OrderTable WHERE ((o.PortID=@port) AND (o.VesselID=@vessel)));"; //ConnectionStringSettings _cs = ConfigurationManager.ConnectionStrings["PublishipSQLConnectionString"]; //using (SqlConnection _con = new SqlConnection(_cs.ConnectionString)) //using (SqlCommand _cmd = new SqlCommand()) //{ // _cmd.CommandText = _sql; // _cmd.Parameters.AddWithValue("@etsdate", Convert.ToDateTime(_dtets)); // _cmd.Parameters.AddWithValue("@now", Convert.ToDateTime(_now)); // _cmd.Parameters.AddWithValue("@port", _portid); // _cmd.Parameters.AddWithValue("@vessel", _vesselid); // _cmd.Connection = _con; // _con.Open(); // int _result = _cmd.ExecuteNonQuery(); //} //does not work //string[] _cols = { "OrderID" }; //SqlQuery _qry = new Select(_cols).From(DAL.Logistics.Tables.OrderTable). // Where(OrderTable.PortIDColumn).IsEqualTo(_portid).And(OrderTable.VesselIDColumn).IsEqualTo(_vesselid); // //IList<int> _orders = _qry.ExecuteTypedList<int>(); //if (_orders.Count > 0) //{ // SubSonic.Update _upd = new SubSonic.Update(DAL.Logistics.Schemas.OrderTable); // IList<int> _recordsaffected = _upd.Set(OrderTable.EtsColumn).EqualTo(Convert.ToDateTime(_dtets)). // Set(OrderTable.VesselLastUpdatedColumn).EqualTo(Convert.ToDateTime(_now)). // Where(OrderTable.OrderIDColumn).In(_orders).ExecuteTypedList<int>(); //} } //end if vesselid > 0 }//end if voyageetssubid > 0 //MUST call this after insert or error: Specified method is not supported e.Cancel = true; _grd.CancelEdit(); //rebind bind_ets_grid(_voyageid); }
protected void update_charges() { try { int _orderid = wwi_func.vint(wwi_security.DecryptString(get_token("pid"), "publiship")); //Int32 _orderid = this.dxhfOrder.Contains("pid") ? wwi_func.vint(this.dxhfOrder.Get("pid").ToString()) : 0; if (_orderid > 0) { OrderTable _ot = new OrderTable(_orderid); ASPxComboBox _cbo = (ASPxComboBox)this.fmvCharge.FindControl("dxcboClientsTerms"); if (_cbo != null) { _ot.ClientsTerms = _cbo.Text.ToString(); } _cbo = (ASPxComboBox)this.fmvCharge.FindControl("dxcboOriginTrucking"); if (_cbo != null) { _ot.OriginTrucking = _cbo.Text.ToString(); } _cbo = (ASPxComboBox)this.fmvCharge.FindControl("dxcboOrignTHC"); if (_cbo != null) { _ot.OrignTHC = _cbo.Text.ToString(); } _cbo = (ASPxComboBox)this.fmvCharge.FindControl("dxcboOriginDocs"); if (_cbo != null) { _ot.OriginDocs = _cbo.Text.ToString(); } _cbo = (ASPxComboBox)this.fmvCharge.FindControl("dxcboFreight"); if (_cbo != null) { _ot.Freight = _cbo.Text.ToString(); } _cbo = (ASPxComboBox)this.fmvCharge.FindControl("dxcboDestTHC"); if (_cbo != null) { _ot.DestTHC = _cbo.Text.ToString(); } _cbo = (ASPxComboBox)this.fmvCharge.FindControl("dxcboDestPalletisation"); if (_cbo != null) { _ot.DestPalletisation = _cbo.Text.ToString(); } _cbo = (ASPxComboBox)this.fmvCharge.FindControl("dxcboCustomsClearance"); if (_cbo != null) { _ot.CustomsClearance = _cbo.Text.ToString(); } _cbo = (ASPxComboBox)this.fmvCharge.FindControl("dxcboDeliveryCharges"); if (_cbo != null) { _ot.DeliveryCharges = _cbo.Text.ToString(); } ASPxMemo _mem = (ASPxMemo)this.fmvCharge.FindControl("dxmemCoLoaderComments"); if (_mem != null) { _ot.CoLoaderComments = _mem.Text.ToString(); } _ot.Save(); //confirm saved //string _msg = "Order " + this.dxlblOrderNo.Text.ToString() + " has been updated"; //this.dxlblInfo.Text = _msg; //this.dxpnlMsg.ClientVisible = true; } else { string _err = "Unable to update charges. Order number not found."; this.dxlblErr.Text = _err; this.dxpnlErr.ClientVisible = true; } } catch (Exception ex) { string _err = ex.Message.ToString(); this.dxlblErr.Text = _err; this.dxpnlErr.ClientVisible = true; } }
protected void gvENT_OnRowUpdating(object sender, ASPxDataUpdatingEventArgs e) { ASPxGridView gv = (ASPxGridView)sender; //Get and Process the list of selected records in order to populate the list of pkvals #region process selected records var selected_keys = gvENT.GetSelectedFieldValues("subjID"); ASPxCheckBox chkAllSelected = gv.FindEditFormLayoutItemTemplateControl("chkUpdateAllSelected") as ASPxCheckBox; bool updateALLSelected = chkAllSelected.Checked; List <int> pkvals = new List <int>(); foreach (object key in e.Keys.Values) { int ikey; bool isint = int.TryParse(key.ToString(), out ikey); if (isint) { pkvals.Add(ikey); } } //Add the other selected rows to the update if the user has selected the "Update All" checkbox if (selected_keys.Count > 0 && updateALLSelected) { foreach (object k in selected_keys) { int ikey; bool isint = int.TryParse(k.ToString(), out ikey); if (!pkvals.Contains(ikey)) { pkvals.Add(ikey); } } } #endregion //Custom: retrieve specific data from the grid //Get the data from the ComboBoxes ASPxComboBox cboSS = (ASPxComboBox)gvENT.FindEditFormLayoutItemTemplateControl("cboSS"); e.NewValues["ssID"] = cboSS.Value; ASPxComboBox cboSSD = (ASPxComboBox)gvENT.FindEditFormLayoutItemTemplateControl("cboSSD"); e.NewValues["ssdID"] = cboSSD.Value; ASPxMemo notes = (ASPxMemo)gvENT.FindEditFormLayoutItemTemplateControl("notesEditor"); e.NewValues["Notes"] = notes.Value; string result = dataops.dxGrid_UpdateData("subjID", pkvals, e.NewValues, "backend", "dbo", "tblSubject"); gvENTstatus.Text = result; gv.CancelEdit(); e.Cancel = true; ViewState["needBind"] = "true"; gvENT.DataBind(); }
protected void treelstToolUnits_NodeValidating(object sender, TreeListNodeValidationEventArgs e) { #region Init some objest ASPxTreeList treelst = sender as ASPxTreeList; ASPxComboBox cboCodeUnit = treelstToolUnits.FindEditCellTemplateControl(treelstToolUnits.Columns["Code"] as TreeListDataColumn, "cboCodeUnit") as ASPxComboBox; TreeListEditCellTemplateContainer templateContainer = (TreeListEditCellTemplateContainer)cboCodeUnit.NamingContainer; string selectedCode = cboCodeUnit.SelectedItem != null?cboCodeUnit.SelectedItem.Value.ToString() : selectedCode = null; //List<ViewToolUnitConstruction> table = ToolUnitConstruction.ToList<ViewToolUnitConstruction>(); //if (table == null) // table = new List<ViewToolUnitConstruction>(); #endregion #region Check Require NumberRequired //if (treelst.NewNodeParentKey != null) //{ // //if (this.toolBOL.isToolToolUnitRootId(Guid.Parse(treelst.NewNodeParentKey))) // //{ // // e.NodeError = String.Format("Không cho phép cập nhật đơn vị tính mặt định!"); // //return; // //} //} //else if (treelst.EditingNodeKey != null) //{ // if (this.toolBOL.isToolToolUnitRootId(Guid.Parse(treelst.EditingNodeKey))) // { // //e.NodeError = String.Format("Không cho phép cập nhật đơn vị tính mặt định!"); // //return; // } //} if (selectedCode == null || selectedCode == "") { e.NodeError = String.Format("Bắt buộc chọn đơn vị tính!"); return; } #endregion #region Check Require NumberRequired if (e.NewValues["NumRequired"] == null) { e.NodeError = String.Format("Bắt buộc nhập số lượng!"); return; } #endregion #region Check Exist ToolUnitCode ---- Mode Edit Node if (templateContainer.NodeKey != null) { TreeListNode node = templateContainer.TreeList.FindNodeByKeyValue(templateContainer.NodeKey); // ViewToolUnitConstruction dataItem = (ViewToolUnitConstruction)node.DataItem; //string oldCode = dataItem.Code; //Check Exist Code before //if (table.Count > 0 && treelst.IsEditing && selectedCode != oldCode) //{ // if (table.Find(items => items.Code == selectedCode) != null) // { // e.NodeError = String.Format("Đơn vị tính {0} đã được chọn! Vui lòng chọn cái khác", selectedCode); // } //} } #endregion #region Check Exist ToolUnitCode ---- Mode Add Node //else //{ //if (table.Count > 0 && treelst.IsEditing) //{ // if (table.Find(items => items.Code == selectedCode) != null) // { // e.NodeError = String.Format("Đơn vị tính {0} đã được chọn! Vui lòng chọn cái khác", selectedCode); // } //} //} #endregion }
//end update /// <summary> /// new record /// </summary> protected int insert_contact() { int _newid = 0; //original value for countryname string _oldvalue = this.dxhfOrder.Contains("oldvalue") ? this.dxhfOrder.Get("oldvalue").ToString() : ""; try { int?_intnull = null; //new instance of record EmployeesTable _tbl = new EmployeesTable(); //get values off insert form //check duplicate name ASPxTextBox _txt = (ASPxTextBox)this.fmvEmployee.FindControl("dxtxtEmployeeInsert"); if (_txt != null && _txt.Text != "") { string _newvalue = _txt.Text.Trim().ToString(); //country name bool _duplicate = _newvalue != _oldvalue?wwi_func.value_exists("Name", "EmployeesTable", _newvalue) : false; if (!_duplicate) { //name _tbl.Name = _txt.Text.ToString(); //email _txt = (ASPxTextBox)this.fmvEmployee.FindControl("dxtxtEmailInsert"); if (_txt != null) { _tbl.EmailAddress = _txt.Text.ToString(); } //office ASPxComboBox _cbo = (ASPxComboBox)this.fmvEmployee.FindControl("dxcboOfficeID"); if (_cbo != null) { _tbl.OfficeID = _cbo.Value != null?wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //department _cbo = (ASPxComboBox)this.fmvEmployee.FindControl("dxcboDepartmentID"); if (_cbo != null) { _tbl.DepartmentID = _cbo.Value != null?wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //live ASPxCheckBox _ck = (ASPxCheckBox)this.fmvEmployee.FindControl("dxckLiveInsert"); if (_ck != null) { _tbl.Live = _ck.Checked; } _tbl.Save(); //get new id _newid = (int)_tbl.GetPrimaryKeyValue(); }//end if else { string _ex = string.Format("{0} is already in database. This record will not be saved", _newvalue); this.dxlblErr.Text = _ex; this.dxpnlErr.ClientVisible = true; } //end if duplicate } //end if text } catch (Exception ex) { string _ex = ex.Message.ToString(); this.dxlblErr.Text = _ex; this.dxpnlErr.ClientVisible = true; } return(_newid); }
protected void FillSectionCombo(ASPxComboBox cmb, string country) { if (string.IsNullOrEmpty(country)) return; SectionObjectDS.SelectParameters[0].DefaultValue = country; cmb.DataBind(); }
public static void SetDDLChartType(ASPxComboBox ddl) { try { DataTable dt = new DataTable(); dt.Columns.Add("ID"); dt.Columns.Add("name"); DataRow dr; dr = dt.NewRow(); dr["id"] = "1"; dr["name"] = "กราฟแท่ง"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["id"] = "2"; dr["name"] = "กราฟเส้น"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["id"] = "3"; dr["name"] = "กราฟวงกลม"; dt.Rows.Add(dr); if (dt.Rows.Count > 0) { ddl.ValueField = "ID"; ddl.TextField = "name"; ddl.DataSource = dt; ddl.DataBind(); ddl.SelectedIndex = 0; } } catch (Exception ex) { } }
protected void SaveJob() { try { ASPxGridView g = this.grid_Transport; ASPxTextBox houseId = g.FindEditFormTemplateControl("txt_Id") as ASPxTextBox; int Id = SafeValue.SafeInt(houseId.Text, 0); ASPxTextBox docNo = g.FindEditFormTemplateControl("txt_DocNo") as ASPxTextBox; Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(ContAsset), "Id='" + Id + "'"); ContAsset contA = C2.Manager.ORManager.GetObject(query) as ContAsset; bool isNew = false; if (Id == 0) { isNew = true; contA = new ContAsset(); contA.DocNo = C2Setup.GetNextNo("StoringOrder"); contA.DocType = "SO"; } ASPxTextBox jobNo = g.FindEditFormTemplateControl("txt_JobNo") as ASPxTextBox; contA.JobNo = jobNo.Text; ASPxComboBox depotCode = g.FindEditFormTemplateControl("cmb_DepotCode") as ASPxComboBox; contA.DepotCode = depotCode.Text; ASPxTextBox shipVessel = g.FindEditFormTemplateControl("txt_ShipVessel") as ASPxTextBox; contA.ShipVessel = shipVessel.Text; ASPxTextBox shipVoyage = g.FindEditFormTemplateControl("txt_ShipVoyage") as ASPxTextBox; contA.ShipVoyage = shipVoyage.Text; ASPxDateEdit shipEta = g.FindEditFormTemplateControl("date_ShipEta") as ASPxDateEdit; contA.ShipEta = shipEta.Date; ASPxDateEdit shipEtd = g.FindEditFormTemplateControl("date_ShipEtd") as ASPxDateEdit; contA.ShipEtd = shipEtd.Date; ASPxButtonEdit shipPol = g.FindEditFormTemplateControl("btn_ShipPol") as ASPxButtonEdit; contA.ShipPol = shipPol.Text; ASPxButtonEdit shipPod = g.FindEditFormTemplateControl("btn_ShipPod") as ASPxButtonEdit; contA.ShipPod = shipPod.Text; ASPxMemo shipNote = g.FindEditFormTemplateControl("txt_ShipNote") as ASPxMemo; contA.ShipNote = shipNote.Text; ASPxButtonEdit shipCarrierCode = g.FindEditFormTemplateControl("btn_ShipCarrierCode") as ASPxButtonEdit; contA.ShipCarrierCode = shipCarrierCode.Text; ASPxTextBox shipCarrierRef = g.FindEditFormTemplateControl("txt_ShipCarrierRef") as ASPxTextBox; contA.ShipCarrierRef = shipCarrierRef.Text; ASPxTextBox demurrageRef = g.FindEditFormTemplateControl("txt_DemurrageRef") as ASPxTextBox; contA.DemurrageRef = demurrageRef.Text; ASPxSpinEdit demurrageFreeDay = g.FindEditFormTemplateControl("spin_DemurrageFreeDay") as ASPxSpinEdit; contA.DemurrageFreeDay = SafeValue.SafeInt(demurrageFreeDay.Text, 0); ASPxDateEdit demurrageStartDate = g.FindEditFormTemplateControl("date_DemurrageStartDate") as ASPxDateEdit; contA.DemurrageStartDate = demurrageStartDate.Date; ASPxTextBox detentionRef = g.FindEditFormTemplateControl("txt_DetentionRef") as ASPxTextBox; contA.DetentionRef = detentionRef.Text; ASPxSpinEdit detentionFreeDay = g.FindEditFormTemplateControl("spin_DetentionFreeDay") as ASPxSpinEdit; contA.DetentionFreeDay = SafeValue.SafeInt(detentionFreeDay.Text, 0); ASPxDateEdit detentionStartDate = g.FindEditFormTemplateControl("date_DetentionStartDate") as ASPxDateEdit; contA.DetentionStartDate = detentionStartDate.Date; ASPxComboBox returnType = g.FindEditFormTemplateControl("cmb_ReturnType") as ASPxComboBox; contA.ReturnType = returnType.Text; ASPxButtonEdit shipperCode = g.FindEditFormTemplateControl("btn_ShipperCode") as ASPxButtonEdit; contA.ShipperCode = shipperCode.Text; ASPxTextBox shipperName = g.FindEditFormTemplateControl("txt_ShipperName") as ASPxTextBox; contA.ShipperName = shipperName.Text; ASPxButtonEdit consigneeCode = g.FindEditFormTemplateControl("btn_ConsigneeCode") as ASPxButtonEdit; contA.ConsigneeCode = consigneeCode.Text; ASPxTextBox consigneeName = g.FindEditFormTemplateControl("txt_ConsigneeName") as ASPxTextBox; contA.ConsigneeName = consigneeName.Text; ASPxButtonEdit haulierCode = g.FindEditFormTemplateControl("btn_HaulierCode") as ASPxButtonEdit; contA.HaulierCode = haulierCode.Text; ASPxDateEdit haulierCompleteDate = g.FindEditFormTemplateControl("date_HaulierCompleteDate") as ASPxDateEdit; contA.HaulierCompleteDate = haulierCompleteDate.Date; ASPxTextBox instruction = g.FindEditFormTemplateControl("txt_Instruction") as ASPxTextBox; contA.Instruction = instruction.Text; if (isNew) { contA.CreateBy = EzshipHelper.GetUserName(); contA.CreateDateTime = DateTime.Now; C2.Manager.ORManager.StartTracking(contA, Wilson.ORMapper.InitialState.Inserted); C2.Manager.ORManager.PersistChanges(contA); C2Setup.SetNextNo("StoringOrder", contA.DocNo); houseId.Text = contA.Id.ToString(); //this.txt_JobNo.Text = tpt1.JobNo; docNo.Text = contA.DocNo; Session["ExpWhere"] = "Id='" + contA.Id + "'"; this.dsTransport.FilterExpression = Session["ExpWhere"].ToString(); if (this.grid_Transport.GetRow(0) != null) { this.grid_Transport.StartEdit(0); } } else { contA.UpdateBy = EzshipHelper.GetUserName(); contA.UpdateDateTime = DateTime.Now; C2.Manager.ORManager.StartTracking(contA, Wilson.ORMapper.InitialState.Updated); C2.Manager.ORManager.PersistChanges(contA); string sql = "update cont_assetEvent set pod='" + shipPod.Text + "',pol='" + shipPol.Text + "' where docNo='" + docNo.Text + "' "; C2.Manager.ORManager.ExecuteCommand(sql); } } catch (Exception ex) { throw new Exception(ex.Message + ex.StackTrace); } }
protected void grid_CellEditorInitialize(object sender, DevExpress.Web.ASPxGridViewEditorEventArgs e) { if (e.Column.FieldName == "Modulo") { ASPxComboBox cmb = e.Editor as ASPxComboBox; cmb.Items.Add("Comercial", "Comercial"); cmb.Items.Add("Riesgo", "Riesgo"); cmb.Items.Add("Fiscalia", "Fiscalia"); cmb.Items.Add("Operaciones", "Operaciones"); cmb.Items.Add("Contabilidad", "Contabilidad"); cmb.Items.Add("Seguimiento", "Seguimiento"); cmb.Items.Add("Posicion", "Posicion"); cmb.Items.Add("Configuracion", "Configuracion"); hdn_modulo["hdn_modulo"] = cmb.Text; } if (e.Column.FieldName == "Tipo Opcion") { var auxItem = ""; ASPxComboBox cmb = e.Editor as ASPxComboBox; SqlCommand command = new SqlCommand("sp_tipoOpciones", connection); command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@modulo", hdn_modulo["hdn_modulo"]); if (connection.State != ConnectionState.Open) { connection.Open(); } SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { if (reader["TipoOpcion"].ToString() != auxItem) { cmb.Items.Add(reader["TipoOpcion"].ToString(), reader["TipoOpcion"].ToString()); } auxItem = reader["TipoOpcion"].ToString(); } reader.Close(); selTipoOpcion = cmb.Text; } if (e.Column.FieldName == "Opciones") { ASPxComboBox cmb = e.Editor as ASPxComboBox; SqlCommand command = new SqlCommand("sp_tipoOpciones", connection); command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@modulo", hdn_modulo["hdn_modulo"]); if (connection.State != ConnectionState.Open) { connection.Open(); } SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { //if (reader["TipoOpcion"].ToString() == selTipoOpcion) cmb.Items.Add(reader["Opcion"].ToString().Trim(), reader["Opcion"].ToString()); } reader.Close(); selOpcion = cmb.Text; } if (e.Column.FieldName == "Permiso") { ASPxComboBox cmb = e.Editor as ASPxComboBox; SqlCommand command = new SqlCommand("sp_permisos", connection); command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@modulo", hdn_modulo["hdn_modulo"]); command.Parameters.AddWithValue("@opcion", selOpcion); if (connection.State != ConnectionState.Open) { connection.Open(); } SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { cmb.Items.Add(reader["Permiso"].ToString(), reader["Permiso"].ToString()); } reader.Close(); } if (e.Column.FieldName == "Perfil") { ASPxTextBox txt = e.Editor as ASPxTextBox; if (hdn_update["hdn_update"].ToString() == "1") { if (txtPerfil.Value != "") { txt.Text = txtPerfil.Value; } } } }
/// <summary> /// 作者:Tony 2011-02-23 /// 功能:设置ASPxComboBox的None显示值,一般在ASPxComboBox的DataBound事件中进行调用 /// </summary> /// <param name="cb"></param> /// <param name="noneDisplayText"></param> protected void SetASPxComboBoxNullItem(ASPxComboBox cb, string noneDisplayText) { if (string.IsNullOrEmpty(noneDisplayText)) noneDisplayText = "(none)"; if (cb != null) { ListEditItem item = new ListEditItem("noneDisplayText", ""); cb.Items.Insert(0, item); cb.SelectedItem = item; } }
protected void AddOrUpdate() { try { ASPxPageControl pageControl = this.grid.FindEditFormTemplateControl("pageControl") as ASPxPageControl; ASPxTextBox txt_Id = this.grid.FindEditFormTemplateControl("txt_Id") as ASPxTextBox; ASPxTextBox txt_Name = grid.FindEditFormTemplateControl("txt_Name") as ASPxTextBox; ASPxTextBox txtIcNo = pageControl.FindControl("txtIcNo") as ASPxTextBox; string Id = SafeValue.SafeString(txt_Id.Text, ""); string name = txt_Name.Text; //throw new Exception(name); Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(HrPerson), "Id='" + Id + "'"); HrPerson person = C2.Manager.ORManager.GetObject(query) as HrPerson; bool action = false; if (SafeValue.SafeString(txt_Name.Text, "") == "") { throw new Exception("Name not be null!!!"); return; } //if (SafeValue.SafeString(txtIcNo.Text,"") == "") //{ // throw new Exception("Ic No not be null!!!"); // return; //} string sql = string.Format(@"select count(*) from Hr_Person where IcNo='{0}' and Id<>{1}", SafeValue.SafeString(txtIcNo.Text, ""), SafeValue.SafeString(txt_Id.Text, "0")); //string sql=string.Format(@"select count(*) from Hr_Person where Id={0}",SafeValue.SafeString(txt_Id.Text,""),SafeValue.SafeString(txt_Name.Text,"")); //throw new Exception(sql); int cnt = SafeValue.SafeInt(C2.Manager.ORManager.ExecuteScalar(sql), 0); if (cnt > 0) { throw new Exception("Please enter another value of the Ic No again!"); return; } if (person == null || person.Id == 0) { action = true; person = new HrPerson(); } //throw new Exception(name); person.Name = name; ASPxTextBox interviewId = this.grid.FindEditFormTemplateControl("txt_InterviewId") as ASPxTextBox; person.InterviewId = SafeValue.SafeString(interviewId.Text, ""); ASPxTextBox recruitId = this.grid.FindEditFormTemplateControl("txt_RecruitId") as ASPxTextBox; person.RecruitId = SafeValue.SafeString(recruitId.Text, ""); ASPxComboBox gender = pageControl.FindControl("cbo_Gender") as ASPxComboBox; person.Gender = gender.Text; ASPxTextBox icno = pageControl.FindControl("txtIcNo") as ASPxTextBox; person.IcNo = icno.Text; ASPxDateEdit birthday = pageControl.FindControl("date_Birthday") as ASPxDateEdit; person.BirthDay = birthday.Date; ASPxTextBox ss1 = pageControl.FindControl("txt_s1") as ASPxTextBox; person.Status1 = S.Text(ss1.Text); ASPxTextBox ss2 = pageControl.FindControl("txt_s2") as ASPxTextBox; person.Status2 = S.Text(ss2.Text); ASPxDateEdit dd1 = pageControl.FindControl("date_d1") as ASPxDateEdit; person.Date1 = S.Date(dd1.Date); ASPxDateEdit dd2 = pageControl.FindControl("date_d2") as ASPxDateEdit; person.Date2 = S.Date(dd2.Date); ASPxButtonEdit country = pageControl.FindControl("txt_Country") as ASPxButtonEdit; person.Country = country.Text; ASPxTextBox race = pageControl.FindControl("txt_Race") as ASPxTextBox; person.Race = race.Text; ASPxTextBox religion = pageControl.FindControl("txt_Religion") as ASPxTextBox; person.Religion = religion.Text; ASPxCheckBox married = pageControl.FindControl("ckb_Married") as ASPxCheckBox; if (married.Checked) { person.Married = "Y"; } else { person.Married = "N"; } ASPxTextBox telephone = pageControl.FindControl("txt_Telephone") as ASPxTextBox; person.Telephone = telephone.Text; ASPxTextBox email = pageControl.FindControl("txt_Email") as ASPxTextBox; person.Email = email.Text; ASPxComboBox hrGroup = pageControl.FindControl("cmb_HrGroup") as ASPxComboBox; person.HrGroup = hrGroup.Text; ASPxComboBox department = pageControl.FindControl("cmb_Department") as ASPxComboBox; person.Department = department.Text; ASPxComboBox hrRole = pageControl.FindControl("cmb_Role") as ASPxComboBox; person.HrRole = hrRole.Text; ASPxMemo address = pageControl.FindControl("memo_Address") as ASPxMemo; person.Address = address.Text; ASPxMemo remark = pageControl.FindControl("memo_Remark") as ASPxMemo; person.Remark = remark.Text; ASPxMemo remark1 = pageControl.FindControl("memo_Profile") as ASPxMemo; person.Remark1 = remark1.Text; ASPxMemo remark2 = pageControl.FindControl("memo_Work") as ASPxMemo; person.Remark2 = remark2.Text; ASPxMemo remark3 = pageControl.FindControl("memo_Education") as ASPxMemo; person.Remark3 = remark3.Text; ASPxMemo remark4 = pageControl.FindControl("memo_Family") as ASPxMemo; person.Remark4 = remark4.Text; ASPxMemo remark5 = pageControl.FindControl("memo_Emergency") as ASPxMemo; person.Remark5 = remark5.Text; ASPxSpinEdit spin_Amount1 = pageControl.FindControl("spin_Amount1") as ASPxSpinEdit; person.Amount1 = SafeValue.SafeDecimal(spin_Amount1.Value); ASPxSpinEdit spin_Amount2 = pageControl.FindControl("spin_Amount2") as ASPxSpinEdit; person.Amount2 = SafeValue.SafeDecimal(spin_Amount2.Value); ASPxSpinEdit spin_Amount3 = pageControl.FindControl("spin_Amount3") as ASPxSpinEdit; person.Amount3 = SafeValue.SafeDecimal(spin_Amount3.Value); //throw new Exception(person.Name); if (action) { person.Status = txt_Status.Text; person.CreateBy = HttpContext.Current.User.Identity.Name; person.CreateDateTime = DateTime.Now; Manager.ORManager.StartTracking(person, Wilson.ORMapper.InitialState.Inserted); Manager.ORManager.PersistChanges(person); } else { ASPxComboBox newStatus = grid.FindEditFormTemplateControl("cmb_Type") as ASPxComboBox; person.Status = newStatus.Text; string oldStatus = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(string.Format("select Status from Hr_Person where Id={0}", Id))); if (oldStatus != SafeValue.SafeString(newStatus.Text)) { this.grid.CancelEdit(); } //this.Response.Write("<script>if(confirm('Confirm change this'+txt_Status.GetText()+' To'+cmb_Type.GetText()+'?')){alert('Sucess!');};</script>"); person.UpdateBy = HttpContext.Current.User.Identity.Name; person.UpdateDateTime = DateTime.Now; Manager.ORManager.StartTracking(person, Wilson.ORMapper.InitialState.Updated); Manager.ORManager.PersistChanges(person); } Session["PersonWhere" + txt_Status.Text] = "Id='" + person.Id + "' and Status='" + txt_Status.Text + "'"; this.dsPerson.FilterExpression = Session["PersonWhere" + txt_Status.Text].ToString(); if (this.grid.GetRow(0) != null) { this.grid.StartEdit(0); } else { Session["PersonWhere" + txt_Status.Text] = "Id>0 and Status='" + txt_Status.Text + "'"; this.dsPerson.FilterExpression = Session["PersonWhere" + txt_Status.Text].ToString(); } } catch (Exception ex) { throw new Exception(ex.Message + ex.StackTrace); } }
public static void SetDDLBudgetYear(ASPxComboBox ddl) { try { DataTable dt = new DataTable(); dt.Columns.Add("budget_year_value"); dt.Columns.Add("budget_year_display"); int startYear = DateTime.Now.AddYears(-10).Year; for (int i = startYear; i <= (DateTime.Now.Year + 1); i++) { DataRow dr = dt.NewRow(); dr["budget_year_value"] = (i + 543).ToString(); dr["budget_year_display"] = (i + 543).ToString(); dt.Rows.Add(dr); } if (dt.Rows.Count > 0) { ddl.ValueField = "budget_year_value"; ddl.TextField = "budget_year_display"; ddl.DataSource = dt; ddl.DataBind(); ddl.Value = setBudgetYear(DateTime.Now); } } catch (Exception ex) { } }
private string job_save() { string res = ""; try { ASPxPageControl pageControl = this.grid_job.FindEditFormTemplateControl("pageControl") as ASPxPageControl; ASPxTextBox txt_JobNo = this.grid_job.FindEditFormTemplateControl("txt_JobNo") as ASPxTextBox; string jobNo = SafeValue.SafeString(txt_JobNo.Text, ""); Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJob), "JobNo='" + jobNo + "'"); C2.CtmJob ctmJob = C2.Manager.ORManager.GetObject(query) as C2.CtmJob; ASPxDateEdit jobDate = this.grid_job.FindEditFormTemplateControl("txt_JobDate") as ASPxDateEdit; bool isNew = false; if (ctmJob == null) { isNew = true; ctmJob = new C2.CtmJob(); ctmJob.JobNo = C2Setup.GetNextNo("", "CTM_Job", jobDate.Date); } ASPxComboBox cbb_JobType = this.grid_job.FindEditFormTemplateControl("cbb_JobType") as ASPxComboBox; ASPxButtonEdit btn_ClientId = this.grid_job.FindEditFormTemplateControl("btn_ClientId") as ASPxButtonEdit; ASPxTextBox txt_ClientRefNo = this.grid_job.FindEditFormTemplateControl("txt_ClientRefNo") as ASPxTextBox; ASPxTextBox txt_notifiEmail = this.grid_job.FindEditFormTemplateControl("txt_notifiEmail") as ASPxTextBox; ASPxButtonEdit btn_SubClientId = this.grid_job.FindEditFormTemplateControl("btn_SubClientId") as ASPxButtonEdit; ASPxButtonEdit txt_WareHouseId = this.grid_job.FindEditFormTemplateControl("txt_WareHouseId") as ASPxButtonEdit; ASPxTextBox txt_ClientContact = this.grid_job.FindEditFormTemplateControl("txt_ClientContact") as ASPxTextBox; ctmJob.ClientContact = SafeValue.SafeString(txt_ClientContact.Text); ctmJob.JobDate = SafeValue.SafeDate(jobDate.Date, new DateTime(1753, 1, 1)); ctmJob.JobType = cbb_JobType.Text; ctmJob.ClientId = btn_ClientId.Text; ctmJob.ClientRefNo = txt_ClientRefNo.Text; ctmJob.EmailAddress = txt_notifiEmail.Text; ctmJob.SubClientId = btn_SubClientId.Text; if (txt_WareHouseId != null) { ctmJob.WareHouseCode = txt_WareHouseId.Text; } string userId = HttpContext.Current.User.Identity.Name; if (isNew) { ctmJob.StatusCode = "USE"; ctmJob.CreateBy = userId; ctmJob.CreateDateTime = DateTime.Now; ctmJob.UpdateBy = userId; ctmJob.UpdateDateTime = DateTime.Now; C2.Manager.ORManager.StartTracking(ctmJob, Wilson.ORMapper.InitialState.Inserted); C2.Manager.ORManager.PersistChanges(ctmJob); } else { ctmJob.UpdateBy = userId; ctmJob.UpdateDateTime = DateTime.Now; C2.Manager.ORManager.StartTracking(ctmJob, Wilson.ORMapper.InitialState.Updated); C2.Manager.ORManager.PersistChanges(ctmJob); C2.CtmJobEventLog elog = new C2.CtmJobEventLog(); elog.Platform_isWeb(); elog.Controller = userId; elog.ActionLevel_isJOB(ctmJob.Id); elog.Remark = "Job Update"; elog.log(); } if (isNew) { txt_JobNo.Text = ctmJob.JobNo; //txt_search_JobNo.Text = txt_JobNo.Text; C2Setup.SetNextNo("", "CTM_Job", ctmJob.JobNo, jobDate.Date); } //res = Job_Check_JobLevel(ctmJob.JobNo); Session["CTM_Job_" + txt_search_JobNo.Text] = "JobNo='" + ctmJob.JobNo + "'"; this.dsJob.FilterExpression = Session["CTM_Job_" + txt_search_JobNo.Text].ToString(); if (this.grid_job.GetRow(0) != null) { this.grid_job.StartEdit(0); } } catch { } return(res); }
public static void SetDDLJDEVALITEM(ASPxComboBox ddl, int TypeID) { try { string sql = "select * from SMM_JD_EVAL_ITEM where TYPE_ID=" + TypeID; SqlDataAdapter da = new SqlDataAdapter(sql, StaticDefaultConnectionString); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { ddl.ValueField = "ITEM_ID"; ddl.TextField = "ITEM_NAME"; ddl.DataSource = dt; ddl.DataBind(); } } catch (Exception ex) { } }
protected void ASPxGridView2_CellEditorInitialize(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditorEventArgs e) { ASPxGridView aspx1 = sender as ASPxGridView; //aspx1.KeyFieldName = "LJDM1"; if (ASPxGridView2.IsEditing) { string rowid1 = ""; try { rowid1 = (string)ASPxGridView2.GetRowValuesByKeyValue(e.KeyValue, "ROWID"); } catch { } string LJDM1 = ""; try { LJDM1 = dc.GetValue("select ljdm1 from SJBOMSOTHMUTI where so='" + Request["so"].ToString() + "' and jhdm='" + Request["planCode"].ToString() + "' and rowid='" + rowid1 + "' "); //LJDM1 = (string)ASPxGridView2.GetRowValuesByKeyValue(e.KeyValue, "LJDM1"); } catch { } if (e.Column.FieldName == "GWMC") { ASPxComboBox combo = e.Editor as ASPxComboBox; string sql = "select location_code from data_plan_standard_Bom where plan_code='" + Request["planCode"].ToString() + "' and item_code='" + LJDM1 + "' order by location_code"; DataTable dt = dc.GetTable(sql); combo.Items.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { combo.Items.Add(dt.Rows[i]["location_code"].ToString(), dt.Rows[i]["location_code"].ToString()); } } if (e.Column.FieldName == "GWMC1") { ASPxComboBox combo = e.Editor as ASPxComboBox; string sql = "select distinct location_code from data_plan_standard_Bom where plan_code='" + Request["planCode"].ToString() + "' order by location_code "; DataTable dt = dc.GetTable(sql); combo.Items.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { combo.Items.Add(dt.Rows[i]["location_code"].ToString(), dt.Rows[i]["location_code"].ToString()); } } if (e.Column.FieldName == "GXMC1") { ASPxComboBox combo = e.Editor as ASPxComboBox; string GWMC1 = ""; GWMC1 = dc.GetValue("select gwmc1 from SJBOMSOTHMUTI where so='" + Request["so"].ToString() + "' and jhdm='" + Request["planCode"].ToString() + "' and rowid='" + rowid1 + "' "); string sql = "select distinct process_code from data_plan_standard_Bom where plan_code='" + Request["planCode"].ToString() + "' and location_code='" + GWMC1 + "' order by process_code"; dc.setTheSql(sql); DataTable dt = dc.GetTable(); combo.Items.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { combo.Items.Add(dt.Rows[i]["process_code"].ToString(), dt.Rows[i]["process_code"].ToString()); } combo.Callback += new CallbackEventHandlerBase(cmbGXMC1_OnCallback); } } }
public static void SetDDLJDSUBGROP34(ASPxComboBox ddl,int GroupID) { try { string sql = "SELECT SUB_GROUP_ID,SUB_GROUP_NAME FROM SMM_JD_SUB_GROUP34 WHERE GROUP_ID="+ GroupID ; SqlDataAdapter da = new SqlDataAdapter(sql, StaticDefaultConnectionString); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { ddl.ValueField = "SUB_GROUP_ID"; ddl.TextField = "SUB_GROUP_NAME"; ddl.DataSource = dt; ddl.DataBind(); } } catch (Exception ex) { } }
protected void grid_CustomDataCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomDataCallbackEventArgs e) { string paras = e.Parameters; string[] ar = paras.Split('_'); //if (paras == "OK") //{ // #region // e.Result = create_house(list.Count, -1); // #endregion //} if (paras == "NewOne") { #region e.Result = create_house("one"); #endregion } if (paras == "NewAll") { #region e.Result = create_house("all"); #endregion } if (paras == "SaveAll") { #region if (list.Count > 0) { for (int i = 0; i < list.Count; i++) { int id = list[i].id; DateTime deliveryDate = list[i].deliveryDate; object qty = (object)list[i].qty; object weight = (object)list[i].weight; object volume = (object)list[i].volume; object sendMode = (object)list[i].sendMode; e.Result = update_house(id, deliveryDate, qty, weight, volume, sendMode); } } else { e.Result = "Pls Select at least one"; } #endregion } if (ar.Length >= 2) { if (ar[0].Equals("CargoListline")) { #region ASPxGridView grid = sender as ASPxGridView; int rowIndex = SafeValue.SafeInt(ar[1], -1); ASPxTextBox txt_Id = grid.FindRowCellTemplateControl(rowIndex, null, "txt_Id") as ASPxTextBox; e.Result = txt_Id.Text; #endregion } if (ar[0].Equals("Saveline")) { #region ASPxGridView grid = sender as ASPxGridView; int rowIndex = SafeValue.SafeInt(ar[1], -1); ASPxLabel Id = this.grid.FindRowCellTemplateControl(rowIndex, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Id"], "lbl_Id") as ASPxLabel; ASPxDateEdit date_DeliveryDate = this.grid.FindRowCellTemplateControl(rowIndex, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["DeliveryDate"], "date_DeliveryDate") as ASPxDateEdit; ASPxComboBox cbb_SendMode = this.grid.FindRowCellTemplateControl(rowIndex, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["SendMode"], "cbb_SendMode") as ASPxComboBox; ASPxSpinEdit spin_Qty = this.grid.FindRowCellTemplateControl(rowIndex, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["QtyOrig"], "spin_Qty") as ASPxSpinEdit; ASPxSpinEdit spin_Weight = this.grid.FindRowCellTemplateControl(rowIndex, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["WeightOrig"], "spin_Weight") as ASPxSpinEdit; ASPxSpinEdit spin_Volume = this.grid.FindRowCellTemplateControl(rowIndex, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["VolumeOrig"], "spin_Volume") as ASPxSpinEdit; e.Result = update_house(SafeValue.SafeInt(Id.Text, 0), date_DeliveryDate.Date, spin_Qty.Value, spin_Weight.Value, spin_Volume.Value, cbb_SendMode.Value); #endregion } } }
public static void SetDDLORGL3(ASPxComboBox ddl) { try { string sql = "SELECT ORG_SERIAL,ORG_NAME,ORG_ABBR FROM vw_SMM_ORG WHERE ORG_LEVEL IN(3) order by ORG_NAME"; SqlDataAdapter da = new SqlDataAdapter(sql, StaticDefaultConnectionString); DataTable dt = new DataTable(); da.Fill(dt); DataRow row; row = dt.NewRow(); //row["ORG_SERIAL"] = "0"; //row["ORG_NAME"] = "--ALL--"; //row["ORG_ABBR"] = ""; //dt.Rows.InsertAt(row, 0); if (dt.Rows.Count > 0) { ddl.Columns.Clear(); ddl.Columns.Add("ORG_NAME", "ชื่อหน่วยงาน"); //ddl.Columns.Add("ORG_ABBR", "ชื่อย่อ"); ddl.ValueField = "ORG_SERIAL"; ddl.TextField = "ORG_NAME"; ddl.DataSource = dt; ddl.DataBind(); } } catch (Exception ex) { } }
protected void AddOrUpdate() { ASPxTextBox txt_pId = this.ASPxGridView1.FindEditFormTemplateControl("txt_Id") as ASPxTextBox; ASPxTextBox txtCode = ASPxGridView1.FindEditFormTemplateControl("txt_ProductCode") as ASPxTextBox; string pId = SafeValue.SafeString(txt_pId.Text, ""); Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(RefProduct), "Id='" + pId + "'"); RefProduct product = C2.Manager.ORManager.GetObject(query) as RefProduct; bool action = false; string code = ""; if (product == null) { action = true; product = new RefProduct(); string sql = "select Code from ref_product"; DataTable dt = C2.Manager.ORManager.GetDataSet(sql).Tables[0]; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { code = dt.Rows[i]["Code"].ToString(); if (txtCode.Text.ToUpper() == code.ToUpper()) { throw new Exception("Please enter another value of the Code again!"); } } } } if (txtCode.Text == "") { code = C2Setup.GetNextNo("", "Product", DateTime.Now); } else { code = txtCode.Text; } product.Code = code; ASPxTextBox txtName = ASPxGridView1.FindEditFormTemplateControl("txt_Name") as ASPxTextBox; string name = txtName.Text.Trim(); if (txtName.Text == "") { throw new Exception("Full Name not be null!!!"); } product.Name = name; ASPxButtonEdit txt_PartyId = ASPxGridView1.FindEditFormTemplateControl("btnParty") as ASPxButtonEdit; product.PartyId = txt_PartyId.Text; ASPxComboBox cbProductClass = ASPxGridView1.FindEditFormTemplateControl("cbProductClass") as ASPxComboBox; product.ProductClass = cbProductClass.Text.Trim(); //ASPxComboBox cbCountry = grid.FindEditFormTemplateControl("cbCountry") as ASPxComboBox; //product.Country= cbCountry.Text; ASPxTextBox txt_BrandName = ASPxGridView1.FindEditFormTemplateControl("txt_BrandName") as ASPxTextBox; product.BrandName = txt_BrandName.Text; ASPxSpinEdit txt_QtyPackingWhole = ASPxGridView1.FindEditFormTemplateControl("txt_QtyPackingWhole") as ASPxSpinEdit; product.QtyPackingWhole = SafeValue.SafeInt(txt_QtyPackingWhole.Text, 0); ASPxMemo txt_Description = ASPxGridView1.FindEditFormTemplateControl("txt_Description") as ASPxMemo; product.Description = txt_Description.Text; ASPxSpinEdit txt_QtyWholeLoose = ASPxGridView1.FindEditFormTemplateControl("txt_QtyWholeLoose") as ASPxSpinEdit; product.QtyWholeLoose = SafeValue.SafeInt(txt_QtyWholeLoose.Text, 0); ASPxSpinEdit spin_LengthPacking = ASPxGridView1.FindEditFormTemplateControl("spin_LengthPacking") as ASPxSpinEdit; product.LengthPacking = SafeValue.SafeDecimal(spin_LengthPacking.Text); ASPxSpinEdit spin_WidthPacking = ASPxGridView1.FindEditFormTemplateControl("spin_WidthPacking") as ASPxSpinEdit; product.WidthPacking = SafeValue.SafeDecimal(spin_WidthPacking.Text); ASPxSpinEdit spin_HeightPacking = ASPxGridView1.FindEditFormTemplateControl("spin_HeightPacking") as ASPxSpinEdit; product.HeightPacking = SafeValue.SafeDecimal(spin_HeightPacking.Text); ASPxSpinEdit spin_VolumePacking = ASPxGridView1.FindEditFormTemplateControl("spin_VolumePacking") as ASPxSpinEdit; product.VolumePacking = SafeValue.SafeDecimal(spin_VolumePacking.Text); ASPxButtonEdit spin_UomPacking = ASPxGridView1.FindEditFormTemplateControl("spin_UomPacking") as ASPxButtonEdit; product.UomPacking = spin_UomPacking.Text; ASPxSpinEdit spin_LengthWhole = ASPxGridView1.FindEditFormTemplateControl("spin_LengthWhole") as ASPxSpinEdit; product.LengthWhole = SafeValue.SafeDecimal(spin_LengthWhole.Text); ASPxSpinEdit spin_WidthWhole = ASPxGridView1.FindEditFormTemplateControl("spin_WidthWhole") as ASPxSpinEdit; product.WidthWhole = SafeValue.SafeDecimal(spin_WidthWhole.Text); ASPxSpinEdit spin_HeightWhole = ASPxGridView1.FindEditFormTemplateControl("spin_HeightWhole") as ASPxSpinEdit; product.HeightWhole = SafeValue.SafeDecimal(spin_HeightWhole.Text); ASPxSpinEdit spin_VolumeWhole = ASPxGridView1.FindEditFormTemplateControl("spin_VolumeWhole") as ASPxSpinEdit; product.VolumeWhole = SafeValue.SafeDecimal(spin_VolumeWhole.Text); ASPxButtonEdit spin_UomWhole = ASPxGridView1.FindEditFormTemplateControl("spin_UomWhole") as ASPxButtonEdit; product.UomWhole = spin_UomWhole.Text; ASPxSpinEdit spin_VolumeLoose = ASPxGridView1.FindEditFormTemplateControl("spin_VolumeLoose") as ASPxSpinEdit; product.VolumeLoose = SafeValue.SafeDecimal(spin_VolumeLoose.Text); ASPxSpinEdit spin_LengthLoose = ASPxGridView1.FindEditFormTemplateControl("spin_LengthLoose") as ASPxSpinEdit; product.LengthLoose = SafeValue.SafeDecimal(spin_LengthLoose.Text); ASPxSpinEdit spin_WidthLoose = ASPxGridView1.FindEditFormTemplateControl("spin_WidthLoose") as ASPxSpinEdit; product.WidthLoose = SafeValue.SafeDecimal(spin_WidthLoose.Text); ASPxSpinEdit spin_HeightLoose = ASPxGridView1.FindEditFormTemplateControl("spin_HeightLoose") as ASPxSpinEdit; product.HeightLoose = SafeValue.SafeDecimal(spin_HeightLoose.Text); ASPxButtonEdit spin_UomLoose = ASPxGridView1.FindEditFormTemplateControl("spin_UomLoose") as ASPxButtonEdit; product.UomLoose = spin_UomLoose.Text; ASPxSpinEdit spin_CostPrice = ASPxGridView1.FindEditFormTemplateControl("spin_CostPrice") as ASPxSpinEdit; product.CostPrice = SafeValue.SafeDecimal(spin_CostPrice.Text); ASPxSpinEdit spin_Saleprice = ASPxGridView1.FindEditFormTemplateControl("spin_Saleprice") as ASPxSpinEdit; product.Saleprice = SafeValue.SafeDecimal(spin_Saleprice.Text); product.CreateBy = HttpContext.Current.User.Identity.Name; ASPxTextBox hsCode = ASPxGridView1.FindEditFormTemplateControl("txt_HsCode") as ASPxTextBox; product.HsCode = hsCode.Text; ASPxSpinEdit QtyLooseBase = ASPxGridView1.FindEditFormTemplateControl("txt_QtyLooseBase") as ASPxSpinEdit; product.QtyLooseBase = SafeValue.SafeInt(QtyLooseBase.Text, 0); ASPxButtonEdit txt_UomBase = ASPxGridView1.FindEditFormTemplateControl("txt_UomBase") as ASPxButtonEdit; product.UomBase = txt_UomBase.Text; product.CreateDateTime = DateTime.Now; ASPxComboBox cb_Att1 = ASPxGridView1.FindEditFormTemplateControl("cb_Att1") as ASPxComboBox; product.Att4 = SafeValue.SafeString(cb_Att1.Text); ASPxComboBox cb_Att2 = ASPxGridView1.FindEditFormTemplateControl("cb_Att2") as ASPxComboBox; product.Att5 = SafeValue.SafeString(cb_Att2.Text); ASPxComboBox cb_Att3 = ASPxGridView1.FindEditFormTemplateControl("cb_Att3") as ASPxComboBox; product.Att6 = SafeValue.SafeString(cb_Att3.Text); ASPxComboBox cb_Att4 = ASPxGridView1.FindEditFormTemplateControl("cb_Att4") as ASPxComboBox; product.Att7 = SafeValue.SafeString(cb_Att4.Text); ASPxComboBox cb_Att5 = ASPxGridView1.FindEditFormTemplateControl("cb_Att5") as ASPxComboBox; product.Att8 = SafeValue.SafeString(cb_Att5.Text); ASPxComboBox cb_Att6 = ASPxGridView1.FindEditFormTemplateControl("cb_Att6") as ASPxComboBox; product.Att9 = SafeValue.SafeString(cb_Att6.Text); ASPxTextBox txt_ArCode = ASPxGridView1.FindEditFormTemplateControl("txt_ArCode") as ASPxTextBox; product.ArCode = SafeValue.SafeString(txt_ArCode.Text.Trim()); ASPxTextBox txt_ApCode = ASPxGridView1.FindEditFormTemplateControl("txt_ApCode") as ASPxTextBox; product.ApCode = SafeValue.SafeString(txt_ApCode.Text.Trim()); if (txt_ArCode.Text.Trim() == "") { product.ArCode = System.Configuration.ConfigurationManager.AppSettings["ItemArCode"]; } if (txt_ApCode.Text.Trim() == "") { product.ApCode = System.Configuration.ConfigurationManager.AppSettings["ItemApCode"]; } ASPxSpinEdit MinOrderQty = ASPxGridView1.FindEditFormTemplateControl("spin_MinOrderQty") as ASPxSpinEdit; product.MinOrderQty = SafeValue.SafeInt(MinOrderQty.Text, 0); ASPxSpinEdit NewOrderQty = ASPxGridView1.FindEditFormTemplateControl("spin_NewOrderQty") as ASPxSpinEdit; product.NewOrderQty = SafeValue.SafeInt(NewOrderQty.Text, 0); //ASPxComboBox cb_Att7 = grid.FindEditFormTemplateControl("cb_Att7") as ASPxComboBox; //product.Att10 = SafeValue.SafeString(cb_Att7.Text); //ASPxComboBox cb_Att8 = grid.FindEditFormTemplateControl("cb_Att8") as ASPxComboBox; //product.Att11 = SafeValue.SafeString(cb_Att8.Text); //ASPxComboBox cb_Att9 = grid.FindEditFormTemplateControl("cb_Att9") as ASPxComboBox; //product.Att12 = SafeValue.SafeString(cb_Att9.Text); //ASPxComboBox cb_Att10 = grid.FindEditFormTemplateControl("cb_Att10") as ASPxComboBox; //product.Att13 = SafeValue.SafeString(cb_Att10.Text); product.Att1 = "1" + product.UomPacking; if (product.QtyPackingWhole > 0 && product.UomWhole.Length > 0) { product.Att1 += string.Format("x{0}{1}", product.QtyPackingWhole, product.UomWhole); } if (product.QtyWholeLoose > 0 && product.UomLoose.Length > 0) { product.Att1 += string.Format("x{0}{1}", product.QtyWholeLoose, product.UomLoose); } if (product.QtyLooseBase > 0 && product.UomBase.Length > 0) { product.Att1 += string.Format("x{0}{1}", product.QtyLooseBase, product.UomBase); } ASPxComboBox cmb_OptionType = ASPxGridView1.FindEditFormTemplateControl("cmb_OptionType") as ASPxComboBox; product.OptionType = SafeValue.SafeString(cmb_OptionType.Value); product.Att4 = SafeValue.SafeString(cb_Att1.Text); if (txt_UomBase.Text == "Packing") { product.Att3 = spin_UomPacking.Text; } else if (txt_UomBase.Text == "Whole") { product.Att3 = spin_UomWhole.Text; } else { product.Att3 = spin_UomLoose.Text; } if (cbProductClass.Text == "CIGR") { product.UomPacking = "PKG"; product.UomWhole = "BOX"; product.UomLoose = "PKT"; product.UomBase = "STK"; } if (action) { product.StatusCode = "USE"; product.CreateBy = EzshipHelper.GetUserName(); product.CreateDateTime = DateTime.Now; Manager.ORManager.StartTracking(product, Wilson.ORMapper.InitialState.Inserted); Manager.ORManager.PersistChanges(product); txt_pId.Text = product.Id.ToString(); C2Setup.SetNextNo("", "Product", code, DateTime.Now); } else { product.UpdateBy = EzshipHelper.GetUserName(); product.UpdateDateTime = DateTime.Now; Manager.ORManager.StartTracking(product, Wilson.ORMapper.InitialState.Updated); Manager.ORManager.PersistChanges(product); } Session["ProductWhere"] = "Code='" + product.Code + "'"; this.dsProduct.FilterExpression = Session["ProductWhere"].ToString(); if (this.ASPxGridView1.GetRow(0) != null) { this.ASPxGridView1.StartEdit(0); } }
public static void SetDDLPerType(ASPxComboBox ddl) { try { //string sql = "select PER_TYPE,PER_TYPE_NAME from PSST_PER_TYPE where ORDER_SEQ is not null order by PER_TYPE"; string sql = " SELECT SP.PER_TYPE ,PT.PER_TYPE_NAME"+Environment.NewLine; sql += " FROM SMM_PER_TYPE SP"+Environment.NewLine; sql += " INNER JOIN PSST_PER_TYPE PT ON SP.PER_TYPE=PT.PER_TYPE"+Environment.NewLine; SqlDataAdapter da = new SqlDataAdapter(sql, StaticDefaultConnectionString); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { ddl.ValueField = "PER_TYPE"; ddl.TextField = "PER_TYPE_NAME"; ddl.DataSource = dt; ddl.DataBind(); } } catch (Exception ex) { } }
protected void grid_CustomDataCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomDataCallbackEventArgs e) { if (Request.QueryString["wh"] != null && Request.QueryString["no"] != null) { int start = 0; // int end = 10000; // int qty = 0; for (int a = start; a < end; a++) { string sql = ""; ASPxTextBox txt_Id = this.grid.FindRowTemplateControl(a, "txt_Id") as ASPxTextBox; ASPxCheckBox isPay = this.grid.FindRowTemplateControl(a, "ack_IsPay") as ASPxCheckBox; if (isPay != null && isPay.Checked) { int invId = SafeValue.SafeInt(Request.QueryString["id"], 0); string no = SafeValue.SafeString(Request.QueryString["no"]); string s = e.Parameters; if (s == "OK") { #region SO Det try { sql = string.Format("select Id,Code from ref_product where Id={0}", SafeValue.SafeInt(txt_Id.Text, 0)); DataTable tab = ConnectSql.GetTab(sql); WhSoDet det = null; for (int i = 0; i < tab.Rows.Count; i++) { string product = tab.Rows[i]["Code"].ToString(); ASPxSpinEdit spin_Qty = this.grid.FindRowTemplateControl(a, "spin_Qty") as ASPxSpinEdit; ASPxSpinEdit spin_Price = this.grid.FindRowTemplateControl(a, "spin_Price") as ASPxSpinEdit; ASPxSpinEdit spin_ExRate = this.grid.FindRowTemplateControl(a, "spin_ExRate") as ASPxSpinEdit; ASPxSpinEdit spin_GstP = this.grid.FindRowTemplateControl(a, "spin_GstP") as ASPxSpinEdit; ASPxTextBox txt_Currency = this.grid.FindRowTemplateControl(a, "txt_Currency") as ASPxTextBox; ASPxComboBox cmb_GstType = this.grid.FindRowTemplateControl(a, "cmb_GstType") as ASPxComboBox; decimal price = SafeValue.SafeDecimal(spin_Price.Value, 0); string currency = SafeValue.SafeString(txt_Currency.Text); decimal exRate = SafeValue.SafeDecimal(spin_ExRate.Value, 0); decimal gst = SafeValue.SafeDecimal(spin_GstP.Value, 0); string gstType = SafeValue.SafeString(cmb_GstType.Text); qty = SafeValue.SafeInt(spin_Qty.Value, 0); det = new WhSoDet(); det.Product = product; det.Currency = currency; det.ExRate = exRate; det.Price = price; det.Qty = qty; det.SoNo = no; det.Gst = gst; det.BalQty = qty; det.GstType = gstType; if (gstType == "S") { gst = SafeValue.SafeDecimal(0.07, 0); } decimal amt = SafeValue.ChinaRound(qty * price, 2); decimal gstAmt = SafeValue.ChinaRound(amt * gst, 2); decimal docAmt = amt + gstAmt; decimal locAmt = SafeValue.ChinaRound(docAmt * exRate, 2); det.GstAmt = gstAmt; det.DocAmt = docAmt; det.LocAmt = locAmt; C2.Manager.ORManager.StartTracking(det, Wilson.ORMapper.InitialState.Inserted); C2.Manager.ORManager.PersistChanges(det); } } catch (Exception ex) { } #endregion } } } } else { e.Result = "Error, Pls refresh your Det"; } }
public static void SetDDLPosition(ASPxComboBox ddl) { try { string sql = "select POS_ID,POS_NAME + '(' + POS_ID + ')' POS_NAME from vw_CMN_POSITION "; SqlDataAdapter da = new SqlDataAdapter(sql, StaticDefaultConnectionString); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { ddl.ValueField = "POS_ID"; ddl.TextField = "POS_NAME"; ddl.DataSource = dt; ddl.DataBind(); ddl.SelectedIndex = 0; } } catch (Exception ex) { } }
private void Save() { try { ASPxPageControl pageControl = this.grid_WhPoR.FindEditFormTemplateControl("pageControl") as ASPxPageControl; ASPxTextBox txtId = pageControl.FindControl("txt_Id") as ASPxTextBox; string id = SafeValue.SafeString(txtId.Text, ""); Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(WhPOReceipt), "Id='" + id + "'"); WhPOReceipt whPOR = C2.Manager.ORManager.GetObject(query) as WhPOReceipt; bool isNew = false; string porNo = ""; if (whPOR == null) { whPOR = new WhPOReceipt(); isNew = true; porNo = C2Setup.GetNextNo("PurchaseOrdersReceipt"); } ASPxTextBox txt_PartyRefNo = pageControl.FindControl("txt_PartyRefNo") as ASPxTextBox; whPOR.PartyRefNo = txt_PartyRefNo.Text; ASPxButtonEdit txt_PartyId = pageControl.FindControl("txt_PartyId") as ASPxButtonEdit; whPOR.PartyId = txt_PartyId.Text; ASPxDateEdit de_ReceiptDate = pageControl.FindControl("de_ReceiptDate") as ASPxDateEdit; whPOR.ReceiptDate = de_ReceiptDate.Date; ASPxComboBox cbo_ReceiptType = pageControl.FindControl("cbo_ReceiptType") as ASPxComboBox; whPOR.ReceiptType = SafeValue.SafeString(cbo_ReceiptType.Value); ASPxButtonEdit txt_WarehouseId = pageControl.FindControl("txt_WarehouseId") as ASPxButtonEdit; whPOR.WarehouseId = txt_WarehouseId.Text; ASPxButtonEdit txt_SalesmanId = pageControl.FindControl("txt_SalesmanId") as ASPxButtonEdit; whPOR.SalesmanId = txt_SalesmanId.Text; ASPxButtonEdit txt_Currency = pageControl.FindControl("txt_Currency") as ASPxButtonEdit; whPOR.Currency = txt_Currency.Text; ASPxSpinEdit spin_ExRate = pageControl.FindControl("spin_ExRate") as ASPxSpinEdit; whPOR.ExRate = SafeValue.SafeDecimal(spin_ExRate.Value, 1); ASPxMemo txt_Remark = pageControl.FindControl("txt_Remark") as ASPxMemo; whPOR.Remark = txt_Remark.Text; string userId = HttpContext.Current.User.Identity.Name; if (isNew) { whPOR.CreateBy = userId; whPOR.CreateDateTime = DateTime.Now; whPOR.ReceiptNo = porNo.ToString(); whPOR.StatusCode = "USE"; Manager.ORManager.StartTracking(whPOR, Wilson.ORMapper.InitialState.Inserted); Manager.ORManager.PersistChanges(whPOR); C2Setup.SetNextNo("PurchaseOrdersReceipt", porNo); } else { whPOR.UpdateBy = userId; whPOR.UpdateDateTime = DateTime.Now; Manager.ORManager.StartTracking(whPOR, Wilson.ORMapper.InitialState.Updated); Manager.ORManager.PersistChanges(whPOR); } Session["PORWhere"] = "ReceiptNo='" + whPOR.ReceiptNo + "'"; this.dsWhPOReceipt.FilterExpression = Session["PORWhere"].ToString(); if (this.grid_WhPoR.GetRow(0) != null) { this.grid_WhPoR.StartEdit(0); } } catch { } }
public static void Set_DDLORG_LV1_2(ASPxComboBox ddl) { try { string sql = "select * from (select 'A' as Group1 , ORG_SERIAL,ORG_NAME,ORG_ABBR from vw_SMM_ORG_LEVEL1 union " + Environment.NewLine; sql += "select 'B' as Group1 ,ORG_SERIAL,ORG_NAME,ORG_ABBR from vw_SMM_ORG_LEVEL2 ) as TB where 1=1" + Environment.NewLine; sql += "order by Group1,ORG_SERIAL"; SqlDataAdapter da = new SqlDataAdapter(sql, StaticDefaultConnectionString); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { ddl.Columns.Clear(); ddl.ValueField = "ORG_SERIAL"; ddl.TextField = "ORG_NAME"; ddl.DataSource = dt; ddl.DataBind(); } } catch (Exception ex) { } }
protected void gridScorecard_BeforePerformDataSelect(object sender, EventArgs e) { ASPxPageControl pc = gridArea.FindControl("ASPxPageControlArea") as ASPxPageControl; ASPxComboBox cb = gridArea.FindDetailRowTemplateControl(3, "ddlScorecard") as ASPxComboBox; ASPxGridView gridScorecard = (ASPxGridView)sender; String ItemKey = Session["ItemKey"].ToString(); Guid projectID = Guid.Parse(Session["projectID"].ToString()); if (CurrentCard != null) { //Bind Grid gridScorecard.DataSource = rc_services.GetScores((String)Session["ProjectID"], ItemKey, ScorecardKey); //Get ScoreCard Info //Prep the COlumns //Get the Score COlumns GridViewColumn Score1 = gridScorecard.Columns["ScoreCol1"]; GridViewColumn Score2 = gridScorecard.Columns["ScoreCol2"]; GridViewColumn Score3 = gridScorecard.Columns["ScoreCol3"]; GridViewColumn Score4 = gridScorecard.Columns["ScoreCol4"]; GridViewColumn Score5 = gridScorecard.Columns["ScoreCol5"]; ////now check which score columns are enabled, and set their visibility Score1.Visible = CurrentCard.EnabledCol1; //ComboHeader1.Visible = Col1Visible; Score2.Visible = CurrentCard.EnabledCol2; //ComboHeader2.Visible = Col2Visible; Score3.Visible = CurrentCard.EnabledCol3; //ComboHeader3.Visible = Col3Visible; Score4.Visible = CurrentCard.EnabledCol4; //ComboHeader4.Visible = Col4Visible; Score5.Visible = CurrentCard.EnabledCol5; //ComboHeader5.Visible = Col5Visible; ////Set Their captions Score1.Caption = CurrentCard.CardCol1; Score2.Caption = CurrentCard.CardCol2; Score3.Caption = CurrentCard.CardCol3; Score4.Caption = CurrentCard.CardCol4; Score5.Caption = CurrentCard.CardCol5; ////Check if measure are enabled, if so, set their visibility and captions (if that score column is visible) ////Get Measure Columns GridViewColumn Measure1 = gridScorecard.Columns["Measure1"]; GridViewColumn Measure2 = gridScorecard.Columns["Measure2"]; GridViewColumn Measure3 = gridScorecard.Columns["Measure3"]; GridViewColumn Measure4 = gridScorecard.Columns["Measure4"]; GridViewColumn Measure5 = gridScorecard.Columns["Measure5"]; if (CurrentCard.MeasuredEnabled == true) { Measure1.Visible = CurrentCard.EnabledCol1; Measure2.Visible = CurrentCard.EnabledCol2; Measure3.Visible = CurrentCard.EnabledCol3; Measure4.Visible = CurrentCard.EnabledCol4; Measure5.Visible = CurrentCard.EnabledCol5; } else { Measure1.Visible = false; Measure2.Visible = false; Measure3.Visible = false; Measure4.Visible = false; Measure5.Visible = false; } } }
protected override System.Web.UI.WebControls.WebControl CreateEditModeControlCore() { _control = CreateDurationEditor(); _control.ValueChanged += EditValueChangedHandler; return _control; }
}//end menu names loop #endregion #region company crud operations protected void fmvAddressBook_ItemInserting(object sender, FormViewInsertEventArgs e) { int _user = Page.Session["user"] != null ? (int)((UserClass)Page.Session["user"]).UserId : 0; int?_intnull = null; //this.objdsAddressBook.InsertParameters["DateRecordAdded"].DefaultValue = DateTime.Now.ToShortDateString(); //this.objdsAddressBook.InsertParameters["RecordAddedBY"].DefaultValue = _username; FormView _f = (FormView)this.FindControl("fmvAddressBook"); if (_f != null) { NameAndAddressBook _n = new NameAndAddressBook(); _n.DateRecordAdded = DateTime.Now; _n.RecordAddedBY = _user; ASPxTextBox _tx = (ASPxTextBox)_f.FindControl("dxtxtname"); if (_tx != null) { _n.CompanyName = _tx.Text != null?_tx.Text.ToString() : ""; } _tx = (ASPxTextBox)_f.FindControl("dxtxtAddress1"); if (_tx != null) { _n.Address1 = _tx.Text != null?_tx.Text.ToString() : ""; } _tx = (ASPxTextBox)_f.FindControl("dxtxtAddress2"); if (_tx != null) { _n.Address2 = _tx.Text != null?_tx.Text.ToString() : ""; } _tx = (ASPxTextBox)_f.FindControl("dxtxtAddress3"); if (_tx != null) { _n.Address3 = _tx.Text != null?_tx.Text.ToString() : ""; } ASPxComboBox _cb = (ASPxComboBox)_f.FindControl("dxcboCountry"); if (_cb != null) { _n.CountryID = _cb.Value != null?wwi_func.vint(_cb.Value.ToString()) : _intnull; } _tx = (ASPxTextBox)_f.FindControl("dxtxtPostCode"); if (_tx != null) { _n.PostCode = _tx.Text != null?_tx.Text.ToString() : ""; } _tx = (ASPxTextBox)_f.FindControl("dxtxtTelNo"); if (_tx != null) { _n.TelNo = _tx.Text != null?_tx.Text.ToString() : ""; } _tx = (ASPxTextBox)_f.FindControl("dxtxtFax"); if (_tx != null) { _n.FaxNo = _tx.Text != null?_tx.Text.ToString() : ""; } _tx = (ASPxTextBox)_f.FindControl("dxtxtEmail"); if (_tx != null) { _n.MainEmail = _tx.Text != null?_tx.Text.ToString() : ""; } _cb = (ASPxComboBox)_f.FindControl("dxcboCompanyType"); if (_cb != null) { _n.TypeID = _cb.Value != null?wwi_func.vint(_cb.Value.ToString()) : _intnull; } ASPxMemo _m = (ASPxMemo)_f.FindControl("dxmemoDelivery"); if (_m != null) { _n.SpecialDeliveryInstructions = _m.Text != null?_m.Text.ToString() : ""; } _tx = (ASPxTextBox)_f.FindControl("dxtxtPalletSpec"); if (_tx != null) { _n.PalletDims = _tx.Text != null?_tx.Text.ToString() : ""; } _tx = (ASPxTextBox)_f.FindControl("dxtxtMaxWeight"); //check for nullable int if (_tx != null) { int?_v = 0; if (!string.IsNullOrEmpty(_tx.Text.ToString())) { _v = wwi_func.vint(_tx.Text.ToString()); } _n.MaxPalletWeight = _v.Value; } _tx = (ASPxTextBox)_f.FindControl("dxtxtMaxHeight"); //check for nullable int if (_tx != null) { int?_v = 0; if (!string.IsNullOrEmpty(_tx.Text.ToString())) { _v = wwi_func.vint(_tx.Text.ToString()); } _n.MaxPalletHeight = _v.Value; } ASPxCheckBox _ck = (ASPxCheckBox)_f.FindControl("dxckExporter"); if (_ck != null) { _n.Exporter = _ck.Checked; } _ck = (ASPxCheckBox)_f.FindControl("dxckCustomer"); if (_ck != null) { _n.Customer = _ck.Checked; } _ck = (ASPxCheckBox)_f.FindControl("dxckConsignee"); if (_ck != null) { _n.Consignee = _ck.Checked; } _ck = (ASPxCheckBox)_f.FindControl("dxckInsurance"); if (_ck != null) { _n.Insurance = _ck.Checked; } _ck = (ASPxCheckBox)_f.FindControl("dxckSalesTarget"); if (_ck != null) { _n.SalesModule = _ck.Checked; } _n.Save(); //return new company id int _newid = (Int32)_n.GetPrimaryKeyValue(); //add to hidden field as we won't be able to retrive this from page request if (this.dxhfOrder.Contains("pid")) { this.dxhfOrder.Remove("pid"); } this.dxhfOrder.Add("pid", _newid); ///update id label ASPxLabel _lb = (ASPxLabel)_f.FindControl("dxlblCompanyID"); if (_lb != null) { _lb.Text = _newid.ToString(); } } }
protected void CheckValue(ASPxComboBox a) { string Str = a.Text.Trim(); double Num; bool isNum = double.TryParse(Str, out Num); if (isNum) { GenerateScript("alert('OK')"); } else GenerateScript("alert('Fail')"); ; }
//end formview inserting /// <summary> /// by binding in code behind we can avoid objectdatasource not updating nullable values correctly /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void fmvAddressBook_ItemUpdating(object sender, FormViewUpdateEventArgs e) { int _id = wwi_func.vint(get_token("pid")); int?_intnull = null; if (_id > 0) { FormView _f = (FormView)this.FindControl("fmvAddressBook"); if (_f != null) { //ASPxLabel _lb = (ASPxLabel)_f.FindControl("dxlblCompanyID"); //if (_lb != null) { _id = _lb.Text.ToString(); } NameAndAddressBook _n = new NameAndAddressBook(_id); ASPxTextBox _tx = (ASPxTextBox)_f.FindControl("dxtxtName"); if (_tx != null) { _n.CompanyName = _tx.Text != null?_tx.Text.ToString() : ""; } _tx = (ASPxTextBox)_f.FindControl("dxtxtAddress1"); if (_tx != null) { _n.Address1 = _tx.Text != null?_tx.Text.ToString() : ""; } _tx = (ASPxTextBox)_f.FindControl("dxtxtAddress2"); if (_tx != null) { _n.Address2 = _tx.Text != null?_tx.Text.ToString() : ""; } _tx = (ASPxTextBox)_f.FindControl("dxtxtAddress3"); if (_tx != null) { _n.Address3 = _tx.Text != null?_tx.Text.ToString() : ""; } ASPxComboBox _cb = (ASPxComboBox)_f.FindControl("dxcboCountry"); if (_cb != null) { _n.CountryID = wwi_func.vint(_cb.Value.ToString()); } _tx = (ASPxTextBox)_f.FindControl("dxtxtPostCode"); if (_tx != null) { _n.PostCode = _tx.Text != null?_tx.Text.ToString() : ""; } _tx = (ASPxTextBox)_f.FindControl("dxtxtTelNo"); if (_tx != null) { _n.TelNo = _tx.Text != null?_tx.Text.ToString() : ""; } _tx = (ASPxTextBox)_f.FindControl("dxtxtFax"); if (_tx != null) { _n.FaxNo = _tx.Text != null?_tx.Text.ToString() : ""; } _tx = (ASPxTextBox)_f.FindControl("dxtxtEmail"); if (_tx != null) { _n.MainEmail = _tx.Text != null?_tx.Text.ToString() : ""; } _cb = (ASPxComboBox)_f.FindControl("dxcboCompanyType"); if (_cb != null) { _n.TypeID = _cb.Value != null?wwi_func.vint(_cb.Value.ToString()) : _intnull; } ASPxMemo _m = (ASPxMemo)_f.FindControl("dxmemoDelivery"); if (_m != null) { _n.SpecialDeliveryInstructions = _m.Text != null?_m.Text.ToString() : ""; } _tx = (ASPxTextBox)_f.FindControl("dxtxtPalletSpec"); if (_tx != null) { _n.PalletDims = _tx.Text != null?_tx.Text.ToString() : ""; } _tx = (ASPxTextBox)_f.FindControl("dxtxtMaxWeight"); //check for nullable int if (_tx != null) { int?_v = 0; if (!string.IsNullOrEmpty(_tx.Text.ToString())) { _v = wwi_func.vint(_tx.Text.ToString()); } _n.MaxPalletWeight = _v; } _tx = (ASPxTextBox)_f.FindControl("dxtxtMaxHeight"); //check for nullable int if (_tx != null) { int?_v = 0; if (!string.IsNullOrEmpty(_tx.Text.ToString())) { _v = wwi_func.vint(_tx.Text.ToString()); } _n.MaxPalletHeight = _v; } ASPxCheckBox _ck = (ASPxCheckBox)_f.FindControl("dxckExporter"); if (_ck != null) { _n.Exporter = _ck.Checked; } _ck = (ASPxCheckBox)_f.FindControl("dxckCustomer"); if (_ck != null) { _n.Customer = _ck.Checked; } _ck = (ASPxCheckBox)_f.FindControl("dxckConsignee"); if (_ck != null) { _n.Consignee = _ck.Checked; } _ck = (ASPxCheckBox)_f.FindControl("dxckInsurance"); if (_ck != null) { _n.Insurance = _ck.Checked; } _ck = (ASPxCheckBox)_f.FindControl("dxckSalesTarget"); if (_ck != null) { _n.SalesModule = _ck.Checked; } _n.Save(); } //end formview updating } }