protected void grid_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e) { string s = e.Parameters; if (s == "OK") { ASPxComboBox cmb_JobType = ASPxPopupControl1.FindControl("cmb_JobType") as ASPxComboBox; ASPxButtonEdit txt_CustomerId = ASPxPopupControl1.FindControl("txt_CustomerId") as ASPxButtonEdit; ASPxDateEdit issueDate = ASPxPopupControl1.FindControl("date_IssueDate") as ASPxDateEdit; if (txt_CustomerId.Text.Trim() == "" && txt_CustomerName.Text.Trim() == "") { e.Result = "Fail! Please enter the Customer"; return; } if (cmb_JobType.Text.Trim() == "") { e.Result = "Fail! Please enter the JobType"; return; } else { e.Result = SaveNewJob(); } } }
protected void grid_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxTextBox txtLuongCB = grid.FindEditFormTemplateControl("txtLuongCB") as ASPxTextBox; ASPxDateEdit txtThoiDiem = grid.FindEditFormTemplateControl("txtThoiDiem") as ASPxDateEdit; ASPxHiddenField HiddentfileKem = grid.FindEditFormTemplateControl("HiddentfileKem") as ASPxHiddenField; ASPxTextBox txtfilekem = grid.FindEditFormTemplateControl("txtfilekem") as ASPxTextBox; ASPxTextBox txtQuyetDinh = grid.FindEditFormTemplateControl("txtQuyetDinh") as ASPxTextBox; this.luongcb = objBaoHiem.GetLuongCBId(Int32.Parse(e.Keys[grid.KeyFieldName].ToString())); if (this.luongcb != null) { this.luongcb.luongcb = Convert.ToDecimal(txtLuongCB.Text.Trim()); this.luongcb.thoidiem = txtThoiDiem.Date; this.luongcb.soqd = txtQuyetDinh.Text.Trim(); if (HiddentfileKem.Count > 0) { this.luongcb.fileKem = "LCB" + DateTime.Now.ToShortDateString().Replace("/", "_") + "_" + HiddentfileKem.Get("filekem").ToString(); } else { this.luongcb.fileKem = "LCB" + DateTime.Now.ToShortDateString().Replace("/", "_") + "_" + txtfilekem.Text.Trim(); } this.objBaoHiem.UpdateLuongCB(luongcb); } grid.CancelEdit(); e.Cancel = true; this.grid.DataSource = objBaoHiem.GetLuongCBs(); this.grid.DataBind(); }
//新增 protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxComboBox ljdm = ASPxGridView1.FindEditFormTemplateControl("comboLJDM") as ASPxComboBox; ASPxDateEdit begindate1 = ASPxGridView1.FindEditFormTemplateControl("dateStart") as ASPxDateEdit; ASPxDateEdit enddate1 = ASPxGridView1.FindEditFormTemplateControl("dateEnd") as ASPxDateEdit; string ljmc = ""; string sqlC = "select PT_DESC2 from COPY_PT_MSTR where pt_part='" + ljdm.Value.ToString() + "'"; DataTable dt = dc.GetTable(sqlC); if (dt.Rows.Count > 0) { ljmc = dt.Rows[0]["PT_DESC2"].ToString(); } string Sql = "INSERT INTO ATPUBOMKZB (ABOM_COMP,ZDRQ,RQBEGIN,RQEND,LJMC) " + " VALUES ( '" + ljdm.Value.ToString() + "',sysdate,to_date('" + begindate1.Text.Trim() + "','yyyy-MM-dd'),to_date('" + enddate1.Text.Trim() + "','yyyy-MM-dd'),'" + ljmc + "')"; dc.ExeSql(Sql); //记录操作start string logSql = "insert into atpubomkzb_log(abom_comp,zdrq,rqbegin,rqend,rqsj,yhmc,czms)" + " select abom_comp,zdrq,rqbegin,rqend,sysdate,'" + theUserName + "','增加了新的零件' " + " from atpubomkzb where abom_comp='" + ljdm.Value.ToString() + "'"; dc.ExeSql(logSql); //记录操作end e.Cancel = true; ASPxGridView1.CancelEdit(); setCondition1(); }
protected void Date_Validation(object sender, ValidationEventArgs e) { DateTime date1 = (DateTime)e.Value; ASPxDateEdit de = sender as ASPxDateEdit; int visibleIndex = ((GridViewDataItemTemplateContainer)de.NamingContainer).VisibleIndex; if (de.ID.Contains("HireDate")) { DateTime birthDate = CheckDateEdit("BirthDate", visibleIndex); if (birthDate != DateTime.MinValue) { CheckYears(e, date1, birthDate); } else { e.IsValid = false; } } else { DateTime hireDate = CheckDateEdit("HireDate", visibleIndex); if (hireDate != DateTime.MinValue) { CheckYears(e, hireDate, date1); } else { e.IsValid = false; } } }
private decimal Get_Incentive(string name) { ASPxDateEdit txt_FromDate = ASPxGridView1.FindEditFormTemplateControl("txt_FromDate") as ASPxDateEdit; ASPxDateEdit txt_ToDate = ASPxGridView1.FindEditFormTemplateControl("txt_ToDate") as ASPxDateEdit; string dateFrom = txt_FromDate.Date.ToString("yyyy-MM-dd"); string dateTo = txt_ToDate.Date.ToString("yyyy-MM-dd"); string sql = string.Format(@"with pri as (select * from ctm_MastData where [Type]='tripcode'),tb1 as ( select det2.JobNo,det2.ContainerNo, (select isnull(sum(isnull(Qty*Price,0)),0) from job_cost where TripNo=det2.Id and LineType='DP' and ChgCode='Trip') as Incentive1, (select isnull(sum(isnull(Qty*Price,0)),0) from job_cost where TripNo=det2.Id and LineType='DP' and ChgCode='OverTime') as Incentive2, (select isnull(sum(isnull(Qty*Price,0)),0) from job_cost where TripNo=det2.Id and LineType='DP' and ChgCode='Standby') as Incentive3, (select isnull(sum(isnull(Qty*Price,0)),0) from job_cost where TripNo=det2.Id and LineType='DP' and ChgCode='PSA') as Incentive4 from CTM_JobDet2 as det2 left outer join CTM_JobDet1 as det1 on det2.Det1Id=det1.Id left outer join CTM_Job as job on job.jobNo=det2.JobNo left outer join CTM_Driver as dri on dri.Code=det2.DriverCode "); string sql_part1 = string.Format(@") select *,isnull(Incentive1,0)+isnull(Incentive2,0)+isnull(Incentive3,0)+isnull(Incentive4,0) as TotalIncentive from tb1"); string where = string.Format(@" where det2.Statuscode='C' and DATEDIFF(d,det2.ToDate,'{0}')<=0 and DATEDIFF(d,det2.ToDate,'{1}')>=0", dateFrom, dateTo); where += string.Format(@" and det2.DriverCode='{0}'", name); DataTable dt_incentive = ConnectSql.GetTab(sql + where + sql_part1); decimal amt = 0; for (int j = 0; j < dt_incentive.Rows.Count; j++) { amt += SafeValue.SafeDecimal(dt_incentive.Rows[0]["TotalIncentive"]); } return(amt); }
protected void grid_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxTextBox txtQuyetDinh = gridKhenThuong.FindEditFormTemplateControl("txtQuyetDinh") as ASPxTextBox; ASPxDateEdit dateNgayQuyetDinh = gridKhenThuong.FindEditFormTemplateControl("dateNgayQuyetDinh") as ASPxDateEdit; ASPxTextBox txtNguoiKy = gridKhenThuong.FindEditFormTemplateControl("txtNguoiKy") as ASPxTextBox; ASPxTextBox txtGhiChu = gridKhenThuong.FindEditFormTemplateControl("txtGhiChu") as ASPxTextBox; ASPxComboBox cmbNamThiDua = gridKhenThuong.FindEditFormTemplateControl("cmbNamThiDua") as ASPxComboBox; ASPxComboBox cmbThanhTich = gridKhenThuong.FindEditFormTemplateControl("cmbThanhTich") as ASPxComboBox; ASPxComboBox cmbDanhHieuThiDua = gridKhenThuong.FindEditFormTemplateControl("cmbDanhHieuThiDua") as ASPxComboBox; ASPxComboBox cmb_capkhenthuong = gridKhenThuong.FindEditFormTemplateControl("cmb_capkhenthuong") as ASPxComboBox; string fileqd = ""; if (Session["fileKhenThuong"] != null) { fileqd = Session["fileKhenThuong"].ToString(); } int n = SqlHelper.ExecuteNonQuery(strconn, "[HRM_KhenThuong_UI]", Int32.Parse(e.Keys[gridKhenThuong.KeyFieldName].ToString()), 14, 0, 1, txtGhiChu.Text, txtQuyetDinh.Text, dateNgayQuyetDinh.Date.ToString("dd/MM/yyyy"), "", 0, fileqd, Int32.Parse(cmbDanhHieuThiDua.Value.ToString()), 0, Convert.ToInt32(cmbNamThiDua.Value.ToString()), txtNguoiKy.Text, 0, 0, cmb_capkhenthuong.Value, 1); gridKhenThuong.CancelEdit(); e.Cancel = true; LoadDanhHieuThiDuaKhenThuong(Int32.Parse(cmbNam.Value.ToString()), 0); }
protected void grdApproval_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxGridView grid = sender as ASPxGridView; ASPxDateEdit effectDate = grdApproval.FindEditRowCellTemplateControl((GridViewDataColumn)grdApproval.Columns["EffectDate"], "EffectDate") as ASPxDateEdit; ASPxTextBox Remarks = grdApproval.FindEditRowCellTemplateControl((GridViewDataColumn)grdApproval.Columns["Remarks"], "ASPxRemarksTextBox") as ASPxTextBox; string sLastModified = DateTime.Now.ToString(); string PK = e.Keys[0].ToString(); SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); string update_MRP = "UPDATE tbl_System_Approval " + " SET [EffectDate] = @EffectDate, " + " [Remarks]= @Remarks, " + " [LastModified] = @LastModified " + " WHERE [PK] = @PK"; SqlCommand cmd = new SqlCommand(update_MRP, conn); cmd.Parameters.AddWithValue("@PK", PK); cmd.Parameters.AddWithValue("@EffectDate", effectDate.Value.ToString()); cmd.Parameters.AddWithValue("@Remarks", Remarks.Value.ToString()); cmd.Parameters.AddWithValue("@LastModified", sLastModified); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); conn.Close(); BindApproval(); e.Cancel = true; grid.CancelEdit(); }
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { if (txtPCode.Text.Trim() == "") { return; } else { ASPxTextBox uPSo = ASPxGridView1.FindEditFormTemplateControl("txtPSo") as ASPxTextBox; //ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox; ASPxTextBox uPNum = ASPxGridView1.FindEditFormTemplateControl("txtPNum") as ASPxTextBox; ASPxComboBox uPlanCode = ASPxGridView1.FindEditFormTemplateControl("txtPlanCode") as ASPxComboBox; ASPxComboBox uOnLocation = ASPxGridView1.FindEditFormTemplateControl("txtOnLocation") as ASPxComboBox; ASPxDateEdit uOnlinetime = ASPxGridView1.FindEditFormTemplateControl("DateOnlinetime") as ASPxDateEdit; string strPSo = uPSo.Text.Trim(); string strPCode = txtPCode.Value.ToString(); string strPNum = uPNum.Text.Trim(); string strPlanCode = uPlanCode.Value.ToString(); string strOnLocation = uOnLocation.Value.ToString(); string strOnlinetime = uOnlinetime.Text.Trim(); string Sql = "INSERT INTO MS_SINGLE_PLAN(PLAN_CODE,PLAN_SO,PLAN_NUM,ONLINE_LOCATION,ONLINE_TIME,FLAG,ADD_TIME,GZDD)" + "VALUES('" + strPlanCode + "','" + strPSo + "','" + strPNum + "','" + strOnLocation + "',to_date('" + uOnlinetime.Value + "','yyyy-mm-dd hh24:mi:ss'),'N',sysdate,'" + strPCode + "')"; dc.ExeSql(Sql); e.Cancel = true; ASPxGridView1.CancelEdit(); setCondition(); } }
protected void txt_search_dateFrom_Init(object sender, EventArgs e) { ASPxDateEdit date = sender as ASPxDateEdit; GridViewDataItemTemplateContainer container = date.NamingContainer as GridViewDataItemTemplateContainer; date.Value = DateTime.Today; }
protected void grid_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxTextBox txtTitle = grid.FindEditFormTemplateControl("txtTitle") as ASPxTextBox; ASPxTextBox txtCoefficient = grid.FindEditFormTemplateControl("txtCoefficient") as ASPxTextBox; ASPxTextBox textId = grid.FindEditFormTemplateControl("txtId") as ASPxTextBox; ASPxDateEdit txtDateEffectted = grid.FindEditFormTemplateControl("txtDateEffectted") as ASPxDateEdit; ASPxComboBox cboPositionGroup = grid.FindEditFormTemplateControl("cboPositionGroup") as ASPxComboBox; this.salary.id = -1; this.salary.title = txtTitle.Text; if (hiddenIDBacLuong.Value != null) { this.salary.parentid = Convert.ToInt32(hiddenIDBacLuong.Value); this.salary.level = objSalary.GetSalaryType(Convert.ToInt32(hiddenIDBacLuong.Value)).level.Trim(); } this.salary.coefficient = txtCoefficient.Text; this.salary.code = ""; this.salary.dateeffectted = txtDateEffectted.Date; this.objSalary.AddSalaryType(salary); grid.CancelEdit(); e.Cancel = true; if (hiddenIDBacLuong.Value != null) { this.grid.DataSource = objSalary.GetACoefficientByParentId(Int32.Parse(hiddenIDBacLuong.Value), Convert.ToDateTime("01/01/1900"), 0); this.grid.DataBind(); } else { if (Session["id"] != null) { this.grid.DataSource = objSalary.GetACoefficientByParentId(Int32.Parse(Session["id"].ToString()), Convert.ToDateTime("01/01/1900"), 0); this.grid.DataBind(); } } }
protected override void AssignControllerValues() { ASPxTextBox tbSubject = (ASPxTextBox)FindControlByID("tbSubject"); ASPxTextBox tbLocation = (ASPxTextBox)FindControlByID("tbLocation"); ASPxTextBox tbPrice = (ASPxTextBox)FindControlByID("tbPrice"); ASPxDateEdit edtStartDate = (ASPxDateEdit)FindControlByID("edtStartDate"); ASPxDateEdit edtEndDate = (ASPxDateEdit)FindControlByID("edtEndDate"); ASPxMemo memDescription = (ASPxMemo)FindControlByID("memDescription"); ASPxMemo memContacts = (ASPxMemo)FindControlByID("memContacts"); ASPxComboBox cbResource = (ASPxComboBox)FindControlByID("edtResource"); Controller.Subject = tbSubject.Text; Controller.Location = tbLocation.Text; Controller.Description = memDescription.Text; Controller.Start = edtStartDate.Date; Controller.End = edtEndDate.Date; // custom fields Controller.ContactInfo = memContacts.Text; Controller.Price = Convert.ToDouble(tbPrice.Text); if (cbResource.SelectedItem != null) { Controller.ResourceId = cbResource.SelectedItem.Value; } DateTime clientStart = FromClientTime(Controller.Start); AssignControllerRecurrenceValues(clientStart); }
protected void gridKhoaDaoTao_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxTextBox txt_madaotao = gridKhoaDaoTao.FindEditFormTemplateControl("txt_madaotao") as ASPxTextBox; ASPxDateEdit date_tungay = gridKhoaDaoTao.FindEditFormTemplateControl("date_tungay") as ASPxDateEdit; ASPxDateEdit date_denngay = gridKhoaDaoTao.FindEditFormTemplateControl("date_denngay") as ASPxDateEdit; ASPxMemo memo_noidung = gridKhoaDaoTao.FindEditFormTemplateControl("memo_noidung") as ASPxMemo; ASPxMemo memo_ghichu = gridKhoaDaoTao.FindEditFormTemplateControl("memo_ghichu") as ASPxMemo; ASPxListBox lbChoosen = gridKhoaDaoTao.FindEditFormTemplateControl("lbChoosen") as ASPxListBox; string filename = string.Empty; if (Session["file"] != null) { filename = Session["file"].ToString(); Session.Remove("file"); } object idkhoadaotao = SqlHelper.ExecuteScalar(strconn, "[HRM_ANTOANVESINHLAODONG_UI]", 0, txt_madaotao.Text, date_tungay.Value, date_denngay.Value, memo_noidung.Text, filename, memo_ghichu.Text, 0); foreach (ListEditItem item in lbChoosen.SelectedItems) { SqlHelper.ExecuteNonQuery(strconn, "[HRM_ANTOANVESINHLAODONG_KETQUA_UI]", 0, idkhoadaotao, item.Value, null, 0, null, 0); } gridKhoaDaoTao.CancelEdit(); e.Cancel = true; load_data_grid(); }
// 主表修改 protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { //ASPxLabel billId = ASPxGridView1.FindEditFormTemplateControl("LabBillId") as ASPxLabel; ASPxTextBox assetcode = ASPxGridView1.FindEditFormTemplateControl("txtAssetCode") as ASPxTextBox; ASPxTextBox srlno = ASPxGridView1.FindEditFormTemplateControl("txtSrlNo") as ASPxTextBox; ASPxGridLookup lkpVendor = ASPxGridView1.FindEditFormTemplateControl("GridLookupVendor") as ASPxGridLookup; ASPxGridLookup lkpManuf = ASPxGridView1.FindEditFormTemplateControl("GridLookupManuf") as ASPxGridLookup; ASPxGridLookup lkpDept = ASPxGridView1.FindEditFormTemplateControl("GridLookupDept") as ASPxGridLookup; ASPxDateEdit dtePurchDate = ASPxGridView1.FindEditFormTemplateControl("CalPCDate") as ASPxDateEdit; ASPxTextBox txtPurchCost = ASPxGridView1.FindEditFormTemplateControl("txtPrice") as ASPxTextBox; ASPxDateEdit wrtStartDate = ASPxGridView1.FindEditFormTemplateControl("CalWRTStartDate") as ASPxDateEdit; ASPxDateEdit wrtEndDate = ASPxGridView1.FindEditFormTemplateControl("CalWRTEndDate") as ASPxDateEdit; ASPxTextBox txtAssetColor = ASPxGridView1.FindEditFormTemplateControl("txtColor") as ASPxTextBox; ASPxTextBox txtBarCode = ASPxGridView1.FindEditFormTemplateControl("txtBarCode") as ASPxTextBox; ASPxGridLookup lkpRspPerson = ASPxGridView1.FindEditFormTemplateControl("lkpResponsePerson") as ASPxGridLookup; ASPxCheckBox chkActiveFlag = ASPxGridView1.FindEditFormTemplateControl("chkActiveFlag") as ASPxCheckBox; ASPxMemo assetRemark = ASPxGridView1.FindEditFormTemplateControl("txtRemark") as ASPxMemo; string deptCode = "", vendorCode = "", manufCode = "", rspPerson = ""; ASPxGridLookup gridLookupVendor = ASPxGridView1.FindEditFormTemplateControl("GridLookupVendor") as ASPxGridLookup; ASPxTextBox txtSVendor = ASPxGridView1.FindEditFormTemplateControl("txtSVendor") as ASPxTextBox; if (lkpDept.Value != null) { deptCode = lkpDept.Value.ToString(); } if (lkpManuf.Value != null) { manufCode = lkpManuf.Value.ToString(); } if (lkpVendor.Value != null) { vendorCode = lkpVendor.Value.ToString(); } if (lkpRspPerson.Value != null) { rspPerson = lkpRspPerson.Value.ToString(); } string activeflag = chkActiveFlag.Checked ? "Y":"N"; string upSql = "UPDATE data_asset_detail SET vendor_code='" + vendorCode + "',manufacturer_code='" + lkpManuf.Value + "'," + "response_dept_code='" + deptCode + "',purchase_date=to_date('" + dtePurchDate.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss'),purchase_cost=" + txtPurchCost.Text + "," + "warranty_start_date=to_date('" + wrtStartDate.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss'),warranty_end_date=to_date('" + wrtEndDate.Value.ToString() + "','yyyy-mm-dd hh24:mi:ss')," + "response_person_code='" + lkpRspPerson.Value.ToString() + "',asset_color='" + txtAssetColor.Text + "',asset_remark='" + assetRemark.Text + "',active_flag='" + activeflag + "' " + " WHERE COMPANY_CODE = '" + theCompanyCode + "' AND serial_number='" + srlno.Text + "'"; theDc.ExeSql(upSql); e.Cancel = true; ASPxGridView1.CancelEdit(); queryFunction(); }
private void contCfsStatusChange(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomDataCallbackEventArgs e, int rowIndex, string CfsStatus) { if (rowIndex < 0) { e.Result = "Save Error"; return; } ASPxLabel lb_id = this.grid_Transport.FindRowCellTemplateControl(rowIndex, null, "lb_Id") as ASPxLabel; ASPxDateEdit txt_search_dateFrom = this.grid_Transport.FindRowCellTemplateControl(rowIndex, null, "txt_search_dateFrom") as ASPxDateEdit; ASPxTextBox date_ScheduleStartTime = this.grid_Transport.FindRowCellTemplateControl(rowIndex, null, "date_ScheduleStartTime") as ASPxTextBox; string res = "Save Error"; if (lb_id != null) { string sql0 = ""; string sql = string.Format(@"update CTM_JobDet2 set BookingDate=@BookingDate where Id=@Oid", sql0); List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>(); list.Add(new ConnectSql_mb.cmdParameters("@Oid", lb_id.Text, SqlDbType.Int)); list.Add(new ConnectSql_mb.cmdParameters("@BookingDate", txt_search_dateFrom.Date.ToString("yyyy-MM-dd"), SqlDbType.DateTime)); if (ConnectSql_mb.ExecuteNonQuery(sql, list).status) { res = "Save successful!"; //C2.CtmJobDet1.contWarehouseStatusChanged(SafeValue.SafeInt(lb_id.Text, 0)); } } e.Result = res; }
protected void grid_HtmlEditFormCreated(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewEditFormEventArgs e) { if (this.grid.EditingRowVisibleIndex > -1) { ASPxPageControl pageControl = this.grid.FindEditFormTemplateControl("pageControl") as ASPxPageControl; ASPxTextBox partyName = pageControl.FindControl("txt_PartyName") as ASPxTextBox; ASPxTextBox whName = pageControl.FindControl("txt_WhName") as ASPxTextBox; ASPxDateEdit txt_Date = pageControl.FindControl("txt_Date") as ASPxDateEdit; txt_Date.Enabled = false; partyName.Text = EzshipHelper.GetPartyName(this.grid.GetRowValues(this.grid.EditingRowVisibleIndex, new string[] { "PartyId" })); whName.Text = EzshipHelper.GetWarehouse(this.grid.GetRowValues(this.grid.EditingRowVisibleIndex, new string[] { "WhCode" })); string oid = SafeValue.SafeString(this.grid.GetRowValues(this.grid.EditingRowVisibleIndex, new string[] { "Id" })); if (oid.Length > 0) { string sql = string.Format("select StatusCode from wh_Contract where Id='{0}'", oid); string closeInd = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), "USE");// ASPxButton btn = this.grid.FindEditFormTemplateControl("btn_CloseJob") as ASPxButton; ASPxButton btn_VoidMaster = this.grid.FindEditFormTemplateControl("btn_Void") as ASPxButton; if (closeInd == "CLS") { btn.Text = "Open Job"; } if (closeInd == "CNL") { btn_VoidMaster.Text = "Unvoid"; } else { btn.Text = "Close"; } } } }
protected void gridKhoaDaoTao_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxTextBox txt_madaotao = gridKhoaDaoTao.FindEditFormTemplateControl("txt_madaotao") as ASPxTextBox; ASPxDateEdit date_tungay = gridKhoaDaoTao.FindEditFormTemplateControl("date_tungay") as ASPxDateEdit; ASPxDateEdit date_denngay = gridKhoaDaoTao.FindEditFormTemplateControl("date_denngay") as ASPxDateEdit; ASPxMemo memo_noidung = gridKhoaDaoTao.FindEditFormTemplateControl("memo_noidung") as ASPxMemo; ASPxMemo memo_ghichu = gridKhoaDaoTao.FindEditFormTemplateControl("memo_ghichu") as ASPxMemo; ASPxListBox lbChoosen = gridKhoaDaoTao.FindEditFormTemplateControl("lbChoosen") as ASPxListBox; string filename = string.Empty; if (Session["file"] != null) { filename = Session["file"].ToString(); Session.Remove("file"); string url = String.Format("{0}/images/FileQD/{1}", DotNetNuke.Common.Globals.ApplicationPath, gridKhoaDaoTao.GetRowValues(gridKhoaDaoTao.FocusedRowIndex, "quyetdinh")); string file = Server.MapPath(url); if (File.Exists(file)) { File.Delete(file); } } object idkhoadaotao = SqlHelper.ExecuteNonQuery(strconn, "[HRM_ANTOANVESINHLAODONG_UI]", e.Keys["id"], txt_madaotao.Text, date_tungay.Value, date_denngay.Value, memo_noidung.Text, filename, memo_ghichu.Text, 1); foreach (ListEditItem item in lbChoosen.SelectedItems) { SqlHelper.ExecuteNonQuery(strconn, "[HRM_ANTOANVESINHLAODONG_KETQUA_UI]", 0, e.Keys["id"], item.Value, null, 0, null, 0); } gridKhoaDaoTao.CancelEdit(); e.Cancel = true; load_data_grid(); }
//修改 protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { if (txtPCode.Text.Trim() == "") { return; } else { ASPxTextBox uPSo = ASPxGridView1.FindEditFormTemplateControl("txtPSo") as ASPxTextBox; //ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox; ASPxTextBox uPNum = ASPxGridView1.FindEditFormTemplateControl("txtPNum") as ASPxTextBox; ASPxComboBox uPlanCode = ASPxGridView1.FindEditFormTemplateControl("txtPlanCode") as ASPxComboBox; ASPxComboBox uOnLocation = ASPxGridView1.FindEditFormTemplateControl("txtOnLocation") as ASPxComboBox; ASPxDateEdit uOnlinetime = ASPxGridView1.FindEditFormTemplateControl("DateOnlinetime") as ASPxDateEdit; string strPSo = uPSo.Text.Trim(); string strPCode = txtPCode.Value.ToString(); string strPNum = uPNum.Text.Trim(); string strPlanCode = uPlanCode.Value.ToString(); string strOnLocation = uOnLocation.Value.ToString(); string strOnlinetime = uOnlinetime.Text.Trim(); string Sql = "update ms_single_plan set PLAN_NUM='" + strPNum + "',online_location='" + strOnLocation + "',online_time=to_date('" + uOnlinetime.Value + "','yyyy-mm-dd hh24:mi:ss')" + "where PLAN_CODE='" + strPlanCode + "' and FLAG='N' and gzdd='" + strPCode + "'"; dc.ExeSql(Sql); e.Cancel = true; ASPxGridView1.CancelEdit(); setCondition(); } }
private void OnLoad(string t) { int start = 0; // this.ASPxGridView1.PageIndex * ASPxGridView1.SettingsPager.PageSize; int end = 10000; // (ASPxGridView1.PageIndex + 1) * ASPxGridView1.SettingsPager.PageSize; for (int i = start; i < end; i++) { ASPxCheckBox isPay = this.grid_Transport.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_Transport.Columns[0], "ack_IsPay") as ASPxCheckBox; //ASPxButtonEdit driver = this.grid_Transport.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn)this.grid_Transport.Columns["Driver"], "btn_DriverCode") as ASPxButtonEdit; ASPxComboBox driver = this.grid_Transport.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_Transport.Columns["Driver"], "btn_DriverCode") as ASPxComboBox; //ASPxButtonEdit towhead = this.grid_Transport.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn)this.grid_Transport.Columns["VehicleNo"], "btn_vehicle") as ASPxButtonEdit; ASPxTextBox Id = this.grid_Transport.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_Transport.Columns["Driver"], "lb_Id") as ASPxTextBox; ASPxTextBox lb_progress = this.grid_Transport.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_Transport.Columns["Driver"], "lb_progress") as ASPxTextBox; ASPxComboBox cbb_JobProgress = this.grid_Transport.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_Transport.Columns["JobProgress"], "cbb_JobProgress") as ASPxComboBox; //ASPxTextEdit txt_DeliveryIndex = this.grid_Transport.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn)this.grid_Transport.Columns["DeliveryIndex"], "txt_DeliveryIndex") as ASPxTextEdit; ASPxTextBox txt_TptTime = this.grid_Transport.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_Transport.Columns["TptTime"], "txt_TptTime") as ASPxTextBox; ASPxDateEdit date_TptDate = this.grid_Transport.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_Transport.Columns["TptDate"], "date_TptDate") as ASPxDateEdit; if (Id != null && driver != null & lb_progress != null && isPay != null && isPay.Checked) { Record r = new Record(Id.Text, SafeValue.SafeString(driver.Value), lb_progress.Text, 0); r.TptTime = SafeValue.SafeString(txt_TptTime.Text, "00:00"); r.TptDate = SafeValue.SafeDate(date_TptDate.Date, new DateTime(1900, 1, 1)).ToString("yyyyMMdd"); r.progress_new = SafeValue.SafeString(cbb_JobProgress.Value); list.Add(r); } else { if (Id == null) { break; } } } }
private void OnLoad() { int start = 0; int end = 200; for (int i = start; i < end; i++) { ASPxCheckBox isPay = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Id"], "ack_IsPay") as ASPxCheckBox; ASPxTextBox partyId = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["PartyId"], "txt_PartyId") as ASPxTextBox; ASPxTextBox sku = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Product"], "txt_Product") as ASPxTextBox; ASPxTextBox des = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Description"], "txt_Description") as ASPxTextBox; ASPxSpinEdit price1 = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["Price1"], "spin_Price1") as ASPxSpinEdit; ASPxDateEdit fromDate = this.ASPxGridView1.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.ASPxGridView1.Columns["FromDate"], "txt_FromDate") as ASPxDateEdit; if (partyId != null && sku != null && des != null && price1 != null && fromDate != null && isPay != null && isPay.Checked) { list.Add(new Record(partyId.Text, sku.Text, des.Text, SafeValue.SafeDecimal(price1.Value, 0), fromDate.Date )); } else if (sku == null) { break; } ; } }
protected void grd_Do_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e) { if (this.grd_Do.EditingRowVisibleIndex > -1) { ASPxPageControl pageControl = this.grd_Do.FindEditFormTemplateControl("pageControl") as ASPxPageControl; //ASPxTextBox partyName = grd_Do.FindEditFormTemplateControl("txt_PartyName") as ASPxTextBox; ASPxTextBox txt_DoNo = this.grd_Do.FindEditFormTemplateControl("txt_DoNo") as ASPxTextBox; //partyName.Text = EzshipHelper.GetPartyName(this.grd_Do.GetRowValues(this.grd_Do.EditingRowVisibleIndex, new string[] { "PartyId" })); string oid = SafeValue.SafeString(this.grd_Do.GetRowValues(this.grd_Do.EditingRowVisibleIndex, new string[] { "Id" })); if (oid.Length > 0) { ASPxDateEdit txt_Date = this.grd_Do.FindEditFormTemplateControl("txt_Date") as ASPxDateEdit; txt_Date.BackColor = ((DevExpress.Web.ASPxEditors.ASPxTextBox)(this.grd_Do.FindEditFormTemplateControl("txt_DoNo"))).BackColor; txt_Date.ReadOnly = true; string sql = string.Format("select DoStatus from wh_Trans where Id='{0}'", oid); string closeInd = SafeValue.SafeString(C2.Manager.ORManager.ExecuteScalar(sql), "USE");// ASPxButton btn = this.grd_Do.FindEditFormTemplateControl("btn_CloseJob") as ASPxButton; //ASPxButton btn_Void = this.grd_Do.FindEditFormTemplateControl("btn_Void") as ASPxButton; if (closeInd == "Closed") { btn.Text = "Open Job"; } //if (closeInd == "CNL") // { // btn_Void.Text = "Unvoid"; // } } } }
private void OnLoad() { int start = 0; // this.ASPxGridView1.PageIndex * ASPxGridView1.SettingsPager.PageSize; int end = 1000; // (ASPxGridView1.PageIndex + 1) * ASPxGridView1.SettingsPager.PageSize; for (int i = start; i < end; i++) { ASPxCheckBox isPay = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Id"], "ack_IsPay") as ASPxCheckBox; ASPxLabel Id = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["Id"], "lbl_Id") as ASPxLabel; ASPxDateEdit date_ShipDate = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ShipDate"], "date_ShipDate") as ASPxDateEdit; ASPxTextBox txt_ShipIndex = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ShipIndex"], "txt_ShipIndex") as ASPxTextBox; ASPxTextBox txt_ShipPortCode = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ShipPortCode"], "txt_ShipPortCode") as ASPxTextBox; ASPxComboBox cbb_ContIndex = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ContIndex"], "cbb_ContIndex") as ASPxComboBox; ASPxSpinEdit spin_Qty = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["QtyOrig"], "spin_Qty") as ASPxSpinEdit; ASPxSpinEdit spin_Weight = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["WeightOrig"], "spin_Weight") as ASPxSpinEdit; ASPxSpinEdit spin_Volume = this.grid.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["VolumeOrig"], "spin_Volume") as ASPxSpinEdit; if (Id != null && isPay != null && isPay.Checked) { list.Add(new Record(SafeValue.SafeInt(Id.Text, 0), SafeValue.SafeInt(txt_ShipIndex.Value, 0), date_ShipDate.Date, txt_ShipPortCode.Text, SafeValue.SafeString(cbb_ContIndex.Value), SafeValue.SafeDecimal(spin_Qty.Value), SafeValue.SafeDecimal(spin_Weight.Value), SafeValue.SafeDecimal(spin_Volume.Value))); } else { if (Id == null) { break; } } } }
public List<WebControl> RenderControl(System.Xml.XmlNode xmlControl) { base.Initialize(xmlControl); ASPxDateEdit aspxDateEdit = new ASPxDateEdit { ID = _PropertyMapper.GetID(), NullText = "Ingrese Fecha", MinDate = _PropertyMapper.GetMinDate(), MaxDate = _PropertyMapper.GetMaxDate(), }; aspxDateEdit.ValidationSettings.SetFocusOnError = true; aspxDateEdit.ValidationSettings.RequiredField.IsRequired = _PropertyMapper.Required(); aspxDateEdit.ValidationSettings.RequiredField.ErrorText = "Campo Requerido"; aspxDateEdit.ValidationSettings.ValidationGroup = "InputValidation"; try { if (xmlControl.GetAttribute("CCONTROLASOC") != null) { aspxDateEdit.ValidationSettings.CausesValidation = true; aspxDateEdit.ErrorText = "Error de Rango - Fecha Inicial debe ser menor a Fecha Final"; aspxDateEdit.ClientSideEvents.Validation = "function(s,e){e.isValid = CheckDifference(" + _PropertyMapper.GetID() + ", " + xmlControl.GetAttribute("CCONTROLASOC") + "); }"; } } catch (Exception) { } _Controls.Add(aspxDateEdit); return _Controls; }
protected void grid_CustomDataCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomDataCallbackEventArgs e) { string paras = e.Parameters; string[] ar = paras.Split('_'); if (ar.Length >= 2) { if (ar[0].Equals("Saveline")) { #region ASPxGridView grid = sender as ASPxGridView; int rowIndex = SafeValue.SafeInt(ar[1], -1); ASPxLabel lbl_Id = this.grid.FindRowCellTemplateControl(rowIndex, null, "lbl_Id") as ASPxLabel; ASPxLabel lbl_JobNo = this.grid.FindRowCellTemplateControl(rowIndex, null, "lbl_JobNo") as ASPxLabel; ASPxComboBox txt_ContNo = this.grid.FindRowCellTemplateControl(rowIndex, null, "cbbContainer") as ASPxComboBox; ASPxLabel lbl_ContIndex = this.grid.FindRowCellTemplateControl(rowIndex, null, "lbl_ContIndex") as ASPxLabel; ASPxDateEdit date_ScheduleDate = this.grid.FindRowCellTemplateControl(rowIndex, null, "date_ScheduleDate") as ASPxDateEdit; ASPxTextBox txt_SealNo = this.grid.FindRowCellTemplateControl(rowIndex, null, "txt_SealNo") as ASPxTextBox; ASPxComboBox cbbContType = this.grid.FindRowCellTemplateControl(rowIndex, null, "cbbContType") as ASPxComboBox; ASPxDateEdit date_CustomsClearDate = this.grid.FindRowCellTemplateControl(rowIndex, null, "date_CustomsClearDate") as ASPxDateEdit; ASPxComboBox cmb_CustomsClearStatus = this.grid.FindRowCellTemplateControl(rowIndex, null, "cmb_CustomsClearStatus") as ASPxComboBox; ASPxComboBox cmb_CustomsVerifyInd = this.grid.FindRowCellTemplateControl(rowIndex, null, "cmb_CustomsVerifyInd") as ASPxComboBox; ASPxDateEdit date_CustomsVerifyDate = this.grid.FindRowCellTemplateControl(rowIndex, null, "date_CustomsVerifyDate") as ASPxDateEdit; ASPxMemo memo_CustomsRemark = this.grid.FindRowCellTemplateControl(rowIndex, null, "memo_CustomsRemark") as ASPxMemo; ASPxDateEdit date_ValiDate = this.grid.FindRowCellTemplateControl(rowIndex, null, "date_ValiDate") as ASPxDateEdit; ASPxDateEdit date_ScheduleStartDate = this.grid.FindRowCellTemplateControl(rowIndex, null, "date_ScheduleStartDate") as ASPxDateEdit; ASPxDateEdit date_BillingDate = this.grid.FindRowCellTemplateControl(rowIndex, null, "date_BillingDate") as ASPxDateEdit; ASPxDateEdit date_DispatchDate = this.grid.FindRowCellTemplateControl(rowIndex, null, "date_DispatchDate") as ASPxDateEdit; ASPxDateEdit date_EtaDate = this.grid.FindRowCellTemplateControl(rowIndex, null, "date_EtaDate") as ASPxDateEdit; e.Result = update_cont(SafeValue.SafeInt(lbl_Id.Text, 0), lbl_JobNo.Text, txt_ContNo.Text, txt_SealNo.Text, cbbContType.Text, date_ScheduleDate.Date, lbl_ContIndex.Text, cmb_CustomsClearStatus.Text, date_CustomsClearDate.Date, cmb_CustomsVerifyInd.Text, date_CustomsVerifyDate.Date, memo_CustomsRemark.Text, date_ValiDate.Date, date_ScheduleStartDate.Date, date_BillingDate.Date, date_DispatchDate.Date, date_EtaDate.Date); #endregion } if (ar[0].Equals("Ediline")) { #region ASPxGridView grid = sender as ASPxGridView; int rowIndex = SafeValue.SafeInt(ar[1], -1); ASPxLabel lbl_JobId = this.grid.FindRowCellTemplateControl(rowIndex, null, "lbl_JobId") as ASPxLabel; ASPxComboBox cmb_CustomsClearStatus = this.grid.FindRowCellTemplateControl(rowIndex, null, "cmb_CustomsClearStatus") as ASPxComboBox; ASPxComboBox cmb_CustomsVerifyInd = this.grid.FindRowCellTemplateControl(rowIndex, null, "cmb_CustomsVerifyInd") as ASPxComboBox; if (SafeValue.SafeString(cmb_CustomsClearStatus.Value) == "Y") { e.Result = C2.Edi_Freight.DoOne(lbl_JobId.Text); DateTime now = DateTime.Now; string userId = HttpContext.Current.User.Identity.Name; Session["Export_" + now.ToString("yyyyMMdd") + userId] = null; } else { e.Result = "Edi Error! Pls confirm the Customs Clear Status"; } #endregion } } }
public void InstantiateIn(Control container) { ASPxLabel lbl = new ASPxLabel(); lbl.ID = "lblFrom"; lbl.Text = "From:"; container.Controls.Add(lbl); ASPxDateEdit dateFrom = new ASPxDateEdit(); dateFrom.ID = "dateFrom"; dateFrom.ClientInstanceName = "dFrom"; dateFrom.Date = new DateTime(1950, 1, 1); container.Controls.Add(dateFrom); lbl = new ASPxLabel(); lbl.ID = "lblTo"; lbl.Text = "To:"; container.Controls.Add(lbl); ASPxDateEdit dateTo = new ASPxDateEdit(); dateTo.ID = "dateTo"; dateTo.ClientInstanceName = "dTo"; dateTo.Date = new DateTime(1960, 11, 30); container.Controls.Add(dateTo); ASPxButton btn = new ASPxButton(); btn.ID = "btnApply"; btn.Text = "Apply"; btn.AutoPostBack = false; btn.ClientSideEvents.Click = "function (s, e) { ApplyFilter( dFrom, dTo ); }"; container.Controls.Add(btn); }
//修改 protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox; ASPxTextBox uMCode = ASPxGridView1.FindEditFormTemplateControl("txtMCode") as ASPxTextBox; ASPxTextBox uMName = ASPxGridView1.FindEditFormTemplateControl("txtMName") as ASPxTextBox; ASPxTextBox uGCode = ASPxGridView1.FindEditFormTemplateControl("txtGCode") as ASPxTextBox; ASPxTextBox uGName = ASPxGridView1.FindEditFormTemplateControl("txtGName") as ASPxTextBox; ASPxComboBox uQSite = ASPxGridView1.FindEditFormTemplateControl("txtQSite") as ASPxComboBox; ASPxTextBox uMNum = ASPxGridView1.FindEditFormTemplateControl("txtMNum") as ASPxTextBox; ASPxDateEdit uOnTime = ASPxGridView1.FindEditFormTemplateControl("txtOnTime") as ASPxDateEdit; ASPxComboBox uLocation = ASPxGridView1.FindEditFormTemplateControl("txtLocation") as ASPxComboBox; string strPCode = uPCode.Value.ToString(); string strQSite = uQSite.Value.ToString(); string strMCode = uMCode.Text.Trim(); string strMName = uMName.Text.Trim(); string strGName = uGName.Text.Trim(); string strGCode = uGCode.Text.Trim(); string strMNum = uMNum.Text.Trim(); string locationCode = uLocation.Text.Trim(); string Sql = "update ms_single_mat_inner set material_num='" + strMNum + "',online_time=to_date('" + uOnTime.Value + "','yyyy-mm-dd hh24:mi:ss') " + " where material_code='" + strMCode + "' and gzdd='" + strPCode + "' and gys_code='" + strGCode + "' and online_location='" + locationCode + "' and qadsite='" + strQSite + "' and flag='N'"; dc.ExeSql(Sql); e.Cancel = true; ASPxGridView1.CancelEdit(); setCondition(); }
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxComboBox uPCode = ASPxGridView1.FindEditFormTemplateControl("txtPCode") as ASPxComboBox; ASPxTextBox uMCode = ASPxGridView1.FindEditFormTemplateControl("txtMCode") as ASPxTextBox; ASPxTextBox uMName = ASPxGridView1.FindEditFormTemplateControl("txtMName") as ASPxTextBox; ASPxTextBox uGCode = ASPxGridView1.FindEditFormTemplateControl("txtGCode") as ASPxTextBox; ASPxTextBox uGName = ASPxGridView1.FindEditFormTemplateControl("txtGName") as ASPxTextBox; ASPxComboBox uLocation = ASPxGridView1.FindEditFormTemplateControl("txtLocation") as ASPxComboBox; ASPxComboBox uQSite = ASPxGridView1.FindEditFormTemplateControl("txtQSite") as ASPxComboBox; ASPxTextBox uMNum = ASPxGridView1.FindEditFormTemplateControl("txtMNum") as ASPxTextBox; ASPxDateEdit uOnTime = ASPxGridView1.FindEditFormTemplateControl("txtOnTime") as ASPxDateEdit; string strPCode = uPCode.Value.ToString(); string strQSite = uQSite.Value.ToString(); string strMCode = uMCode.Text.Trim(); string strMName = uMName.Text.Trim(); string strGName = uGName.Text.Trim(); string strGCode = uGCode.Text.Trim(); string strMNum = uMNum.Text.Trim(); string locationCode = uLocation.Text.Trim(); string Sql = "insert into ms_single_mat_inner(material_code,material_num,online_time,online_location,add_time,flag,gzdd,gys_code,qadsite)" + "VALUES('" + strMCode + "','" + strMNum + "',to_date('" + uOnTime.Value + "','yyyy-mm-dd hh24:mi:ss'),'" + locationCode + "'," + "sysdate ,'N','" + strPCode + "','" + strGCode + "','" + strQSite + "')"; dc.ExeSql(Sql); e.Cancel = true; ASPxGridView1.CancelEdit(); setCondition(); }
private void OnLoad(string t) { int start = 0; // this.ASPxGridView1.PageIndex * ASPxGridView1.SettingsPager.PageSize; int end = 10000; // (ASPxGridView1.PageIndex + 1) * ASPxGridView1.SettingsPager.PageSize; for (int i = start; i < end; i++) { ASPxCheckBox isPay = this.grid_Transport.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_Transport.Columns[0], "ack_IsPay") as ASPxCheckBox; ASPxTextBox Id = this.grid_Transport.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_Transport.Columns["Driver"], "lb_Id") as ASPxTextBox; ASPxButtonEdit driver = this.grid_Transport.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_Transport.Columns["Driver"], "btn_DriverCode") as ASPxButtonEdit; ASPxButtonEdit towhead = this.grid_Transport.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_Transport.Columns["VehicleNo"], "btn_vehicle") as ASPxButtonEdit; ASPxDateEdit bkgDate = this.grid_Transport.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_Transport.Columns["BkgDate"], "txt_BkgDate") as ASPxDateEdit; ASPxTextBox bkgTime = this.grid_Transport.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_Transport.Columns["BkgTime"], "txt_BkgTime") as ASPxTextBox; ASPxComboBox trip = this.grid_Transport.FindRowCellTemplateControl(i, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid_Transport.Columns["TripCode"], "cbb_Trip_TripCode") as ASPxComboBox; if (Id != null && isPay != null && isPay.Checked) { list.Add(new Record(Id.Text, driver.Text, towhead.Text, bkgDate.Date, bkgTime.Text, SafeValue.SafeString(trip.Value))); } else if (Id == null) { break; } } }
private string create_house(int count, int index, string jobNo) { string result = ""; DateTime now = DateTime.Now; string refNo = ""; bool action = false; string userId = HttpContext.Current.User.Identity.Name; if (count > 0 || index > -1) { #region 处理逻辑 for (int i = 0; i < count; i++) { int id = list[i].id; int shipIndex = list[i].shipIndex; DateTime shipDate = list[i].shipDate; string postCode = list[i].postCode; string contIndex = list[i].contIndex; decimal qty = list[i].qty; decimal weight = list[i].weight; decimal volume = list[i].volume; insert_data(jobNo, refNo, id, shipIndex, shipDate, postCode, contIndex, qty, weight, volume); } if (index > -1) { #region ASPxTextBox txt_Id = grid.FindRowCellTemplateControl(index, null, "txt_Id") as ASPxTextBox; ASPxDateEdit date_ShipDate = this.grid.FindRowCellTemplateControl(index, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ShipDate"], "date_ShipDate") as ASPxDateEdit; ASPxTextBox txt_ShipIndex = this.grid.FindRowCellTemplateControl(index, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ShipIndex"], "txt_ShipIndex") as ASPxTextBox; ASPxTextBox txt_ShipPortCode = this.grid.FindRowCellTemplateControl(index, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ShipPortCode"], "txt_ShipPortCode") as ASPxTextBox; ASPxComboBox cbb_ContIndex = this.grid.FindRowCellTemplateControl(index, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["ContIndex"], "cbb_ContIndex") as ASPxComboBox; ASPxSpinEdit spin_Qty = this.grid.FindRowCellTemplateControl(index, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["QtyOrig"], "spin_Qty") as ASPxSpinEdit; ASPxSpinEdit spin_Weight = this.grid.FindRowCellTemplateControl(index, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["WeightOrig"], "spin_Weight") as ASPxSpinEdit; ASPxSpinEdit spin_Volume = this.grid.FindRowCellTemplateControl(index, (DevExpress.Web.ASPxGridView.GridViewDataColumn) this.grid.Columns["VolumeOrig"], "spin_Volume") as ASPxSpinEdit; int id = SafeValue.SafeInt(txt_Id.Text, 0); int shipIndex = SafeValue.SafeInt(txt_ShipIndex.Text, 0); DateTime shipDate = date_ShipDate.Date; string postCode = txt_ShipPortCode.Text; string contIndex = SafeValue.SafeString(cbb_ContIndex.Value); decimal qty = SafeValue.SafeDecimal(spin_Qty.Value); decimal weight = SafeValue.SafeDecimal(spin_Weight.Value); decimal volume = SafeValue.SafeDecimal(spin_Volume.Value); insert_data(jobNo, refNo, id, shipIndex, shipDate, postCode, contIndex, qty, weight, volume); #endregion } #endregion } else { result = "Pls Select at least one"; } return(result); }
protected void grdCreator_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxGridView grid = sender as ASPxGridView; ASPxHiddenField masterKey = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["MasterKey"], "ASPxCreatorMasterKeyHiddenField") as ASPxHiddenField; ASPxDateEdit effectDate = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["EffectDate"], "CreatorEffectDate") as ASPxDateEdit; ASPxComboBox sCreator = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["UserCompleteName"], "Creator") as ASPxComboBox; ASPxComboBox sCreatorStat = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["StatusDesc"], "CreatorStatus") as ASPxComboBox; SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); string sLastModified = DateTime.Now.ToString(); string insert = "INSERT INTO tbl_System_BusinessUnit_Creator (MasterKey, UserKey, EffectDate, StatusKey) VALUES (@MasterKey, @UserKey, @EffectDate, @StatusKey)"; SqlCommand cmd = new SqlCommand(insert, conn); cmd.Parameters.AddWithValue("@MasterKey", iBUSSUMasterKey.ToString()); cmd.Parameters.AddWithValue("@UserKey", sCreator.Value.ToString()); cmd.Parameters.AddWithValue("@EffectDate", effectDate.Value.ToString()); cmd.Parameters.AddWithValue("@StatusKey", sCreatorStat.Value.ToString()); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); string updateMaster = "UPDATE tbl_System_BusinessUnit SET [LastModified] = @LastModified WHERE ([PK] = @PK)"; SqlCommand cmd1 = new SqlCommand(updateMaster, conn); cmd1.Parameters.AddWithValue("@PK", iBUSSUMasterKey.ToString()); cmd1.Parameters.AddWithValue("@LastModified", sLastModified.ToString()); cmd1.CommandType = CommandType.Text; cmd1.ExecuteNonQuery(); e.Cancel = true; grid.CancelEdit(); //BindSCMProcOff_Details(Convert.ToInt32(sMasterKey.Value)); //BindSCMProcOff_Details(iProcOffMaster); BindBUSSUListCreator(iBUSSUMasterKey); grdBUSSU.Enabled = true; int pk_latest = 0; string query_pk = "SELECT TOP 1 [PK] FROM tbl_System_BusinessUnit_Creator 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); } }
public static void SetDateEditValue(ASPxDateEdit de, object objects) { try { if (objects != null) de.Value = DateTime.Parse(objects.ToString()); } catch (Exception ex) { SiAuto.Main.LogString("Lỗi SetDateEditValue:", ex.ToString()); } }
public List<HtmlTableCell> BuildDatetimePicker(string fieldtext, string id, string helptext, string SkinID, bool isReadOnly, string controlValue) { List<HtmlTableCell> c = new List<HtmlTableCell>(); try { HtmlTableCell cell = new HtmlTableCell(); cell.Attributes.Add("class", "tblFormViewtdLabel"); cell.Style.Add("Width", "20%"); ASPxLabel lb = new ASPxLabel() { Text = fieldtext }; cell.Controls.Add(lb); HtmlTableCell celledit = new HtmlTableCell(); celledit.Attributes.Add("class", "tblFormViewtdValue"); celledit.Style.Add("Width", "30%"); ASPxDateEdit date = new ASPxDateEdit(); date.SkinID = SkinID; date.ID = id; date.NullText = helptext; date.Value = controlValue; date.DisplayFormatString = "dd/MM/yyyy"; //de.Enabled = alowEdit; date.Theme = "DevEx"; date.AutoPostBack = false; date.Width = Unit.Percentage(99); date.ReadOnly = isReadOnly; celledit.Controls.Add(date); c.Add(cell); c.Add(celledit); cot += 2; } catch (Exception) { ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), Guid.NewGuid().ToString(), "<script> alert('buildDatetimePicker fieldname" + id + "'); </script>", false); } return c; }
public static string GetDateEditValueForCompare(ASPxDateEdit de) { string result = ""; try { result = DateTime.Parse(de.Value.ToString()).ToString("yyyy-MM-dd"); } catch (Exception ex) { SiAuto.Main.LogString("Lỗi GetDateEditValueForCompare:", ex.ToString()); } return result; }