protected void grdBookingDetail_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxGridView grdBookingDetail = (ASPxGridView)sender; CriteriaOperator filter = new BinaryOperator("PurchaseInvoiceInventoryTransactionId", Guid.Parse(Session["InventoryTransactionId"].ToString()), BinaryOperatorType.Equal); XPCollection <PurchaseInvoiceInventoryAccountingTransaction> purchaseInvoiceTransaction = new XPCollection <PurchaseInvoiceInventoryAccountingTransaction>(session, filter); if (purchaseInvoiceTransaction.Count > 0) { foreach (PurchaseInvoiceInventoryAccountingTransaction item in purchaseInvoiceTransaction) { if (item.RowStatus == ROW_NOT_DELETE) { grdBookingDetail.CancelEdit(); return; } } } ASPxSpinEdit c = (ASPxSpinEdit)grdBookingDetail.FindEditRowCellTemplateControl((GridViewDataColumn)grdBookingDetail.Columns["Credit"], "colBookingDetailCredit"); e.NewValues["Credit"] = c.Value.ToString(); c = (ASPxSpinEdit)grdBookingDetail.FindEditRowCellTemplateControl((GridViewDataColumn)grdBookingDetail.Columns["Debit"], "colBookingDetailDebit"); e.NewValues["Debit"] = c.Value.ToString(); }
protected void DMGrid_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxGridView grid = sender as ASPxGridView; ASPxTextBox qty = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["EdittedQty"], "InvEdittedQty") as ASPxTextBox; ASPxTextBox cost = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["EdittedCost"], "InvEdittedCost") as ASPxTextBox; ASPxTextBox total = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["EdittiedTotalCost"], "InvEdittiedTotalCost") as ASPxTextBox; string PK = e.Keys[0].ToString(); Double qty_float = 0, cost_float = 0, total_float = 0; if (qty.Value != null) { qty_float = Convert.ToDouble(qty.Value.ToString()); } if (cost.Value != null) { cost_float = Convert.ToDouble(cost.Value.ToString()); } if (total.Value != null) { total_float = Convert.ToDouble(total.Value.ToString()); } //Double qty_float = Convert.ToDouble(qty.Value.ToString()); //Double cost_float = Convert.ToDouble(cost.Value.ToString()); //Double total_float = Convert.ToDouble(total.Value.ToString()); SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); //string update = "UPDATE " + MRPClass.DirectMatTable() + // " SET [EdittedQty] = @QTY, [EdittedCost] = @COST, [EdittiedTotalCost] = @TOTAL, " + // " [ApprovedQty] = @QTY, [ApprovedCost] = @COST, [ApprovedTotalCost] = @TOTAL " + // " WHERE [PK] = @PK"; //SqlCommand cmd = new SqlCommand(update, conn); //cmd.Parameters.AddWithValue("@PK", PK); //cmd.Parameters.AddWithValue("@QTY", qty_float); //cmd.Parameters.AddWithValue("@COST", cost_float); //cmd.Parameters.AddWithValue("@TOTAL", total_float); //cmd.CommandType = CommandType.Text; //int result = cmd.ExecuteNonQuery(); int result = QuerySPClass.InsertUpdateDirectMaterials(wrkflwln, 2, Convert.ToInt32(PK), docnumber, 1, "", "", "", "", "", "", "", qty_float, cost_float, total_float); if (result > 0) { MRPClass.UpdateLastModified(conn, docnumber); string remarks = MRPClass.directmaterials_logs + "-" + MRPClass.edit_logs; MRPClass.AddLogsMOPList(conn, mrp_key, remarks); } conn.Close(); e.Cancel = true; grid.CancelEdit(); bindDM = true; BindDirectMaterials(docnumber); }
protected void grdBookingDetail_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxGridView grdBookingDetail = (ASPxGridView)sender; CriteriaOperator filter = new BinaryOperator("SalesInvoiceId", Guid.Parse(Session["SaleBillId"].ToString()), BinaryOperatorType.Equal); XPCollection <SaleInvoiceTransaction> saleInvoiceTransaction = new XPCollection <SaleInvoiceTransaction>(session, filter); if (saleInvoiceTransaction.Count > 0) { foreach (SaleInvoiceTransaction item in saleInvoiceTransaction) { if (item.RowStatus == ROW_NOT_DELETE) { grdBookingDetail.CancelEdit(); return; } } } e.NewValues["TransactionId!Key"] = ((ASPxGridView)sender).GetMasterRowKeyValue(); e.NewValues["GeneralJournalId"] = Guid.NewGuid(); ASPxSpinEdit c = (ASPxSpinEdit)grdBookingDetail.FindEditRowCellTemplateControl((GridViewDataColumn)grdBookingDetail.Columns["Credit"], "colBookingDetailCredit"); e.NewValues["Credit"] = c.Value.ToString(); c = (ASPxSpinEdit)grdBookingDetail.FindEditRowCellTemplateControl((GridViewDataColumn)grdBookingDetail.Columns["Debit"], "colBookingDetailDebit"); e.NewValues["Debit"] = c.Value.ToString(); }
public static void ValidateLength(string fieldname, int length, object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e) { ASPxGridView grid = (ASPxGridView)sender; if (fieldname == "ArrivalActual") { GridViewDataColumn col1 = grid.Columns["ArrivalActual"] as GridViewDataColumn; ASPxCheckBoxList chkListArrival = grid.FindEditRowCellTemplateControl(col1, "ASPxCheckBoxListArrival") as ASPxCheckBoxList; if (chkListArrival.SelectedItem == null) { e.RowError = "Fill all the fields"; } } if (fieldname == "DepartureActual") { GridViewDataColumn col1 = grid.Columns["DepartureActual"] as GridViewDataColumn; ASPxCheckBoxList chkListDeparture = grid.FindEditRowCellTemplateControl(col1, "ASPxCheckBoxListDeparture") as ASPxCheckBoxList; if (chkListDeparture.SelectedItem == null) { e.RowError = "Fill all the fields"; } } if (e.NewValues[fieldname] == null) { AddError(e.Errors, grid.Columns[fieldname], fieldname + " cannot be null."); } if (e.NewValues[fieldname] != null && e.NewValues[fieldname].ToString().Length < length) { AddError(e.Errors, grid.Columns[fieldname], fieldname + " must be at least " + length + " characters long."); } }
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 SetTextBoxValue(this ASPxGridView grid, string columnName, string id, string value) { var box = grid.FindEditRowCellTemplateControl <ASPxTextBox>(columnName, id); grid.FindEditRowCellTemplateControl <ASPxTextBox>(columnName, id).Value = value; }
protected void ASPxGridView1_CustomCallback(object sender, DevExpress.Web.ASPxGridViewCustomCallbackEventArgs e) { ASPxGridView grid = (ASPxGridView)sender; ASPxSpinEdit unitPriceEditor = (ASPxSpinEdit)grid.FindEditRowCellTemplateControl(((GridViewDataColumn)grid.Columns["UnitPrice"]), "UnitPriceEditor"); ASPxSpinEdit unitsInStockEditor = (ASPxSpinEdit)grid.FindEditRowCellTemplateControl(((GridViewDataColumn)grid.Columns["UnitsInStock"]), "UnitsInStockEditor"); ASPxTextBox totalEditor = (ASPxTextBox)grid.FindEditRowCellTemplateControl(((GridViewDataColumn)grid.Columns["Total"]), "TotalEditor"); totalEditor.Value = Convert.ToDecimal(unitPriceEditor.Value) * Convert.ToDecimal(unitsInStockEditor.Value); }
protected void grid_DoDet_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { e.NewValues["Qty1"] = SafeValue.SafeDecimal(e.NewValues["Qty1"]); e.NewValues["Price"] = SafeValue.SafeDecimal(e.NewValues["Price"], 0); e.NewValues["QtyPackWhole"] = SafeValue.SafeInt(e.NewValues["QtyPackWhole"], 0); e.NewValues["QtyWholeLoose"] = SafeValue.SafeInt(e.NewValues["QtyWholeLoose"], 0); e.NewValues["QtyLooseBase"] = SafeValue.SafeInt(e.NewValues["QtyLooseBase"], 0); e.NewValues["LotNo"] = SafeValue.SafeString(e.NewValues["LotNo"]); e.NewValues["Uom1"] = SafeValue.SafeString(e.NewValues["Uom1"]); e.NewValues["Uom2"] = SafeValue.SafeString(e.NewValues["Uom2"]); e.NewValues["Uom3"] = SafeValue.SafeString(e.NewValues["Uom3"]); e.NewValues["Uom4"] = SafeValue.SafeString(e.NewValues["Uom4"]); ASPxGridView grid = (sender as ASPxGridView) as ASPxGridView; ASPxComboBox cb_Att1 = grid.FindEditRowCellTemplateControl(null, "cb_Att1") as ASPxComboBox; ASPxComboBox cb_Att2 = grid.FindEditRowCellTemplateControl(null, "cb_Att2") as ASPxComboBox; ASPxComboBox cb_Att3 = grid.FindEditRowCellTemplateControl(null, "cb_Att3") as ASPxComboBox; e.NewValues["Att1"] = SafeValue.SafeString(cb_Att1.Text); e.NewValues["Att2"] = SafeValue.SafeString(cb_Att2.Text); e.NewValues["Att3"] = SafeValue.SafeString(cb_Att3.Text); ; //e.NewValues["Att7"] = SafeValue.SafeString(e.NewValues["Att7"]); //e.NewValues["Att8"] = SafeValue.SafeString(e.NewValues["Att8"]); //e.NewValues["Att9"] = SafeValue.SafeString(e.NewValues["Att9"]); //e.NewValues["Att10"] = SafeValue.SafeString(e.NewValues["Att10"]); e.NewValues["Des1"] = SafeValue.SafeString(e.NewValues["Des1"]); e.NewValues["Currency"] = SafeValue.SafeString(e.NewValues["Currency"]); e.NewValues["ExRate"] = SafeValue.SafeDecimal(e.NewValues["ExRate"], 0); e.NewValues["Gst"] = SafeValue.SafeDecimal(e.NewValues["Gst"], 0); e.NewValues["ExpiredDate"] = SafeValue.SafeDate(e.NewValues["ExpiredDate"], DateTime.Today); string packing = "1" + SafeValue.SafeString(e.NewValues["Uom1"]);; if (SafeValue.SafeInt(e.NewValues["QtyPackWhole"], 0) > 0 && SafeValue.SafeString(e.NewValues["Uom2"]).Length > 0) { packing += string.Format("x{0}{1}", SafeValue.SafeInt(e.NewValues["QtyPackWhole"], 0), SafeValue.SafeString(e.NewValues["Uom2"])); } if (SafeValue.SafeInt(e.NewValues["QtyWholeLoose"], 0) > 0 && SafeValue.SafeString(e.NewValues["Uom3"]).Length > 0) { packing += string.Format("x{0}{1}", SafeValue.SafeInt(e.NewValues["QtyWholeLoose"], 0), SafeValue.SafeString(e.NewValues["Uom3"])); } if (SafeValue.SafeInt(e.NewValues["QtyLooseBase"], 0) > 0 && SafeValue.SafeString(e.NewValues["Uom4"]).Length > 0) { packing += string.Format("x{0}{1}", SafeValue.SafeInt(e.NewValues["QtyLooseBase"], 0), SafeValue.SafeString(e.NewValues["Uom4"])); } e.NewValues["Packing"] = packing; e.NewValues["DocAmt"] = SafeValue.SafeDecimal(SafeValue.SafeInt(e.NewValues["Qty1"], 0) * SafeValue.SafeDecimal(e.NewValues["Price"], 0)); }
protected void POCreateGrid_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxGridView grid = sender as ASPxGridView; ASPxComboBox POUOM = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["POUOM"], "POUOM") as ASPxComboBox; ASPxTextBox POQty = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["POQty"], "POQty") as ASPxTextBox; ASPxTextBox POCost = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["POCost"], "POCost") as ASPxTextBox; ASPxTextBox TotalPOCost = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["TotalPOCost"], "TotalPOCost") as ASPxTextBox; ASPxTextBox POCostwVAT = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["POCostwVAT"], "POCostwVAT") as ASPxTextBox; ASPxTextBox TotalPOCostwVAT = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["TotalPOCostwVAT"], "TotalPOCostwVAT") as ASPxTextBox; ASPxComboBox TaxGroup = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["TaxGroup"], "TaxGroup") as ASPxComboBox; ASPxComboBox TaxItemGroup = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["TaxItemGroup"], "TaxItemGroup") as ASPxComboBox; ASPxCheckBox wVAT = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["wVAT"], "CheckwVAT") as ASPxCheckBox; string PK = e.Keys[0].ToString(); int iVAT = 0; if (Convert.ToBoolean(wVAT.Value)) { iVAT = 1; } string update = "UPDATE dbo.tbl_POCreation_Tmp SET [TaxGroup] = @TaxGroup, [TaxItemGroup] = @TaxItemGroup,[POUOM] = @POUOM, [POQty] = @POQty, [POCost] = @POCost, [wVAT] = @wVAT, [POCostwVAT] = @POCostwVAT WHERE [PK] = @PK"; string pouom = POUOM.Value.ToString(); string qty = POQty.Value.ToString(); string cost = POCost.Value.ToString(); string costwVAT = POCostwVAT.Value.ToString(); //string total = TotalPOCost.Value.ToString(); string tax_group = TaxGroup.Text.ToString(); string tax_item_group = TaxItemGroup.Text.ToString(); SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); SqlCommand cmd = new SqlCommand(update, conn); cmd.Parameters.AddWithValue("@POQty", Convert.ToDouble(qty)); cmd.Parameters.AddWithValue("@POUOM", pouom); cmd.Parameters.AddWithValue("@POCost", Convert.ToDouble(cost)); //cmd.Parameters.AddWithValue("@POTotalCost", total); cmd.Parameters.AddWithValue("@TaxGroup", tax_group); cmd.Parameters.AddWithValue("@TaxItemGroup", tax_item_group); cmd.Parameters.AddWithValue("@wVAT", iVAT); cmd.Parameters.AddWithValue("@POCostwVAT", Convert.ToDouble(costwVAT)); cmd.Parameters.AddWithValue("@PK", PK); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); BindGrid(Session["CreatorKey"].ToString()); grid.CancelEdit(); e.Cancel = true; }
protected void InfoGrid_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxGridView grid = sender as ASPxGridView; ASPxComboBox code = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["Code"], "Code") as ASPxComboBox; ASPxTextBox prefix = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["Prefix"], "Prefix") as ASPxTextBox; ASPxTextBox series = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["BeforeSeries"], "BeforeSeries") as ASPxTextBox; ASPxTextBox max = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["MaxNumber"], "MaxNumber") as ASPxTextBox; ASPxTextBox last = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["LastNumber"], "LastNumber") as ASPxTextBox; SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); string PK = e.Keys[0].ToString(); string update = "UPDATE [dbo].[tbl_PONumber] SET [EntityCode] = @EntityCode, [Prefix] = @Prefix, [BeforeSeries] = @BeforeSeries, [MaxNumber] = @MaxNumber, [LastNumber] = @LastNumber WHERE [PK] = @PK"; double max_number = Convert.ToDouble(max.Text); double last_number = Convert.ToDouble(last.Text); string[] arr = code.Text.ToString().Split(';'); string entity_string = arr[0]; SqlCommand cmd = new SqlCommand(update, conn); cmd.Parameters.AddWithValue("@EntityCode", entity_string); cmd.Parameters.AddWithValue("@Prefix", prefix.Text); cmd.Parameters.AddWithValue("@BeforeSeries", series.Text); cmd.Parameters.AddWithValue("@MaxNumber", max_number); cmd.Parameters.AddWithValue("@LastNumber", last_number); cmd.Parameters.AddWithValue("@PK", PK); cmd.CommandType = CommandType.Text; MRPClass.PrintString(code.Text); try { cmd.ExecuteNonQuery(); } catch (SqlException exc) { MRPClass.PrintString(exc.Message); } conn.Close(); grid.CancelEdit(); e.Cancel = true; BindInfo(); }
protected void CAPEXCIP_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxGridView grid = sender as ASPxGridView; //ASPxTextBox CIP = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["CIPSIPNumber"], "CIPSIPNumber") as ASPxTextBox; ASPxComboBox cipID = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["CIPSIPNumber"], "FixedAssetID") as ASPxComboBox; string PK = e.Keys[0].ToString(); string cip_text = cipID.Value.ToString(); if (!string.IsNullOrEmpty(cip_text)) { //MRPClass.PrintString(cip_text + " " + PK ); string update = "UPDATE [dbo].[tbl_MRP_List_CAPEX] SET [CIPSIPNumber] = '" + cip_text + "' WHERE [PK] = '" + PK + "'"; //MRPClass.PrintString(update); SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); SqlCommand cmd = new SqlCommand(update, conn); int result = cmd.ExecuteNonQuery(); //MRPClass.PrintString(result.ToString()); conn.Close(); } grid.CancelEdit(); e.Cancel = true; BindCapex(month, year, entitycode, bucode); }
protected void Grid1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxGridView grid = (sender as ASPxGridView) as ASPxGridView; ASPxComboBox txt_ChgCode = grid.FindEditRowCellTemplateControl(null, "txt_ChgCode") as ASPxComboBox; e.NewValues["JobNo"] = "-1"; e.NewValues["ChgCode"] = SafeValue.SafeString(txt_ChgCode.Value); string sql = string.Format(@"select ChgcodeDes from XXChgCode where ChgcodeId='{0}'", SafeValue.SafeString(txt_ChgCode.Value)); string chgcodeDes = SafeValue.SafeString(ConnectSql.ExecuteScalar(sql)); e.NewValues["LineStatus"] = Helper.Safe.SafeString(e.NewValues["LineStatus"]).Trim(); e.NewValues["Unit"] = Helper.Safe.SafeString(e.NewValues["Unit"]).Trim(); e.NewValues["ContSize"] = Helper.Safe.SafeString(e.NewValues["ContSize"]).Trim(); e.NewValues["ContType"] = Helper.Safe.SafeString(e.NewValues["ContType"]).Trim(); e.NewValues["Remark"] = Helper.Safe.SafeString(e.NewValues["Remark"]).Trim(); e.NewValues["BillScope"] = Helper.Safe.SafeString(e.NewValues["BillScope"]).Trim(); e.NewValues["BillType"] = Helper.Safe.SafeString(e.NewValues["BillType"]).Trim(); e.NewValues["BillClass"] = Helper.Safe.SafeString(e.NewValues["BillClass"]).Trim(); e.NewValues["RowCreateUser"] = HttpContext.Current.User.Identity.Name; e.NewValues["RowCreateTime"] = DateTime.Now; e.NewValues["RowUpdateUser"] = HttpContext.Current.User.Identity.Name; e.NewValues["RowUpdateTime"] = DateTime.Now; if (SafeValue.SafeString(e.NewValues["ChgCodeDe"]) == "") { e.NewValues["ChgCodeDe"] = chgcodeDes; } btn_search_Click(null, null); }
protected void ASPxGridView1_RowUpdating(object sender, ASPxDataUpdatingEventArgs e) { ASPxGridView grid = (ASPxGridView)sender; DataType dataType = (DataType)grid.GetRowValuesByKeyValue(e.Keys[0], "Type"); string editorID = string.Empty; switch (dataType) { case DataType.Text: editorID = "txt"; break; case DataType.DateTime: editorID = "date"; break; case DataType.Dictionary1: editorID = "dict"; break; case DataType.Dictionary2: editorID = "dict"; break; } ASPxEdit editor = (ASPxEdit)grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["DataValue"], editorID); e.NewValues["DataValue"] = editor.Value.ToString(); }
protected void grdataBuyingToolCategory_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxGridView grdToolOnCategory = sender as ASPxGridView; ASPxComboBox cboCode = grdToolOnCategory.FindEditRowCellTemplateControl(this.grdataBuyingToolCategory.Columns["Code"] as GridViewDataColumn , "cboCodeCategory") as ASPxComboBox; //List<ToolBuyingToolCategoryEntity> table = CategoryEntityList; //if (table == null) // table = new List<ToolBuyingToolCategoryEntity>(); //string selectedCode = cboCode.SelectedItem.Value.ToString(); //ToolBuyingToolCategoryEntity category = new ToolBuyingToolCategoryEntity(); //if (this.Action != "new") //{ // category = this.toolBOL.getCategoriesOnTool(selectedCode, this.toolKey); //} //else //{ // category = toolBOL.getCategoryByCode(selectedCode); //} //table.Add(new ToolBuyingToolCategoryEntity( // category.ToolBuyingToolCategoryId, // category.ToolId, // category.BuyingToolCategoryId, // selectedCode, // category.Name //)); //CategoryEntityList = table; //this.grdataBuyingToolCategory.DataSource = table; grdataBuyingToolCategory.DataBind(); e.Cancel = true; grdataBuyingToolCategory.CancelEdit(); }
protected void grdSCMProcurementOffDetails_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxGridView grid = sender as ASPxGridView; ASPxHiddenField masterKey = grdSCMProcurementOffDetails.FindEditRowCellTemplateControl((GridViewDataColumn)grdSCMProcurementOffDetails.Columns["MasterKey"], "ASPxMasterKeyHiddenField") as ASPxHiddenField; ASPxComboBox scmProfCat = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["ProcCatDesc"], "ProcurementCat") as ASPxComboBox; SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); string sLastModified = DateTime.Now.ToString(); string insert = "INSERT INTO tbl_System_SCMProcurementOfficer_Details ([MasterKey], [ProcCat]) " + " VALUES (@MasterKey, @ProcCat)"; SqlCommand cmd = new SqlCommand(insert, conn); //cmd.Parameters.AddWithValue("@MasterKey", sMasterKey.Value.ToString()); cmd.Parameters.AddWithValue("@MasterKey", iProcOffMaster.ToString()); cmd.Parameters.AddWithValue("@ProcCat", scmProfCat.Value.ToString()); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); string updateMaster = "UPDATE tbl_System_SCMProcurementOfficer " + " SET [LastModified] = @LastModified " + " WHERE ([PK] = @PK)"; SqlCommand cmd1 = new SqlCommand(updateMaster, conn); cmd1.Parameters.AddWithValue("@PK", iProcOffMaster.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); //grdSCMProcurementOff.Enabled = true; int pk_latest = 0; string query_pk = "SELECT TOP 1 [PK] FROM tbl_System_SCMProcurementOfficer_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 void dGridItemTarefa_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxGridView Grid = sender as ASPxGridView; PeopleEditor objppp = (PeopleEditor)Grid.FindEditRowCellTemplateControl((GridViewDataColumn)Grid.Columns[6], "pppAdd"); if (objppp != null) { e.NewValues["Responsavel"] = objppp.CommaSeparatedAccounts; } }
protected void gv_RowUpdating(object sender, ASPxDataUpdatingEventArgs e) { ASPxGridView gridView = sender as ASPxGridView; GridViewDataColumn columnRftContent = gridView.Columns["RtfContent"] as GridViewDataColumn; ASPxHtmlEditor htmlEditor = gridView.FindEditRowCellTemplateControl(columnRftContent, "he") as ASPxHtmlEditor; e.NewValues["RtfContent"] = GetRtfTextFromASPxHtmlEditor(htmlEditor); throw new InvalidOperationException("Data modifications are not allowed in online demos"); //Note that data modifications are not allowed in online demos. To allow editing in local/offline mode, download the example and comment out the "throw..." operation in the ASPxGridView.RowUpdating event handler. }
protected void CapexGridApproval_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxGridView grid = sender as ASPxGridView; ASPxTextBox qty = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["ApprovedQty"], "ApprovedQtyCapex") as ASPxTextBox; ASPxTextBox cost = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["ApprovedCost"], "ApprovedCostCapex") as ASPxTextBox; ASPxTextBox total = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["ApprovedTotalCost"], "ApprovedTotalCostCapex") as ASPxTextBox; string PK = e.Keys[0].ToString(); Double qty_float = Convert.ToDouble(qty.Value.ToString()); Double cost_float = Convert.ToDouble(cost.Value.ToString()); Double total_float = Convert.ToDouble(total.Value.ToString()); SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); string update = "UPDATE " + MRPClass.CapexTable() + " SET [ApprovedQty] = @QTY, [ApprovedCost] = @COST, [ApprovedTotalCost] = @TOTAL WHERE [PK] = @PK"; SqlCommand cmd = new SqlCommand(update, conn); cmd.Parameters.AddWithValue("@PK", PK); cmd.Parameters.AddWithValue("@QTY", qty_float); cmd.Parameters.AddWithValue("@COST", cost_float); cmd.Parameters.AddWithValue("@TOTAL", total_float); cmd.CommandType = CommandType.Text; int result = cmd.ExecuteNonQuery(); if (result > 0) { MRPClass.UpdateLastModified(conn, docnumber); string remarks = MRPClass.capex_logs + "-" + MRPClass.edit_logs; MRPClass.AddLogsMOPList(conn, mrp_key, remarks); } conn.Close(); e.Cancel = true; grid.CancelEdit(); bindCapex = true; BindCapex(docnumber); }
protected void InfoGrid_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxGridView grid = sender as ASPxGridView; ASPxComboBox code = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["Code"], "Code") as ASPxComboBox; ASPxHiddenField errorvalue = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["Code"], "ErrorHiddenValue") as ASPxHiddenField; ASPxTextBox prefix = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["Prefix"], "Prefix") as ASPxTextBox; ASPxTextBox series = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["BeforeSeries"], "BeforeSeries") as ASPxTextBox; ASPxTextBox max = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["MaxNumber"], "MaxNumber") as ASPxTextBox; ASPxTextBox last = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["LastNumber"], "LastNumber") as ASPxTextBox; SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); string insert = "INSERT INTO [dbo].[tbl_PONumber] ([EntityCode], [Prefix], [BeforeSeries], [MaxNumber], [LastNumber]) VALUES (@EntityCode, @Prefix, @BeforeSeries, @MaxNumber, @LastNumber)"; double max_number = Convert.ToDouble(max.Text); double last_number = Convert.ToDouble(last.Text); SqlCommand cmd = new SqlCommand(insert, conn); cmd.Parameters.AddWithValue("@EntityCode", code.Text); cmd.Parameters.AddWithValue("@Prefix", prefix.Text); cmd.Parameters.AddWithValue("@BeforeSeries", series.Text); cmd.Parameters.AddWithValue("@MaxNumber", max_number); cmd.Parameters.AddWithValue("@LastNumber", last_number); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); conn.Close(); grid.CancelEdit(); e.Cancel = true; BindInfo(); }
protected void dGridItemTarefa_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxGridView Grid = sender as ASPxGridView; PeopleEditor objppp = (PeopleEditor)Grid.FindEditRowCellTemplateControl((GridViewDataColumn)Grid.Columns[6], "pppAdd"); int ID_TAREFA = Convert.ToInt32((sender as ASPxGridView).GetMasterRowKeyValue()); e.NewValues["ID_TAREFA"] = ID_TAREFA; if (objppp != null) { e.NewValues["Responsavel"] = objppp.CommaSeparatedAccounts; } }
protected void grid_Zone_CellEditorInitialize(object sender, ASPxGridViewEditorEventArgs e) { ASPxGridView grid = (sender as ASPxGridView) as ASPxGridView; if (grid.EditingRowVisibleIndex > -1) { ASPxTextBox code = grid.FindEditRowCellTemplateControl(null, "txt_ZoneCode") as ASPxTextBox; if (code != null) { code.ReadOnly = true; code.Border.BorderWidth = 0; } } }
protected void grid_det_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e) { ASPxGridView grid = sender as ASPxGridView; if (grid.EditingRowVisibleIndex > -1) { #region bool isDaily = SafeValue.SafeBool(grid.GetRowValues(grid.EditingRowVisibleIndex, new string[] { "IsDaily" }), false); if (isDaily) { ASPxSpinEdit dailyNo = grid.FindEditRowCellTemplateControl(null, "spin_det_DailyNo") as ASPxSpinEdit; dailyNo.ClientEnabled = false; } #endregion } }
protected void ASPxGridView1_HtmlRowCreated(object sender, ASPxGridViewTableRowEventArgs e) { ASPxGridView gridView = ((ASPxGridView)sender); if (e.RowType == GridViewRowType.Data) { ASPxHyperLink hyperlink = ((ASPxHyperLink)gridView.FindRowCellTemplateControl(e.VisibleIndex, null, "btnEdit")); hyperlink.Visible = true; hyperlink.NavigateUrl = string.Format("javascript:grid.StartEditRow('{0}');", e.VisibleIndex); } else if (e.RowType == GridViewRowType.InlineEdit) { GridViewDataColumn column = (GridViewDataColumn)gridView.Columns["#"]; ASPxHyperLink hyperlink = (ASPxHyperLink)gridView.FindEditRowCellTemplateControl(column, "btnUpdate"); hyperlink.ClientInstanceName = "btnUpdate_" + e.VisibleIndex.ToString(); } }
protected void ASPxGridViewNomina_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e) { ASPxGridView grid = (ASPxGridView)sender; ASPxComboBox cmb = (ASPxComboBox)grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["ClaveTrabajador"], "cmbEmployee"); e.NewValues["ClaveTrabajador"] = cmb.Text; e.NewValues["ClaveConcepto"] = ((ASPxGridView)sender).GetMasterRowKeyValue(); //se obtiene la empresa del trabajador seleccionado EmployeeBusinessObject _EmployeeBAL = new EmployeeBusinessObject(); EmployeeEntityOnject _EmployeeInfo = _EmployeeBAL.GetEmployee(e.NewValues["ClaveTrabajador"].ToString()); PeriodoBusinessObject _PeriodoBAL = new PeriodoBusinessObject(); PeriodoEntityObject _PeriodoInfo = _PeriodoBAL.GetPeriodoActualByNominaEmpresa(_EmployeeInfo.ClaveNomina, _EmployeeInfo.Empresa.Clave); e.NewValues["Empresa"] = _EmployeeInfo.Empresa.Clave; e.NewValues["Periodo"] = _PeriodoInfo.ClavePeriodo; }
protected void gridViewData_RowUpdating(object sender, ASPxDataUpdatingEventArgs e) { ASPxGridView grid = sender as ASPxGridView; ASPxCheckBoxList cbl = grid.FindEditRowCellTemplateControl(grid.Columns["EAN13"] as GridViewDataColumn, "cblSuppliers") as ASPxCheckBoxList; string ean13 = String.Empty; if (cbl.SelectedItems.Count > 0) { foreach (int supplierID in cbl.SelectedValues) { ean13 += supplierID.ToString() + ','; } ean13 = ean13.Trim(','); } e.NewValues["EAN13"] = ean13; e.Cancel = true; //COMMENT THIS LINE TO ALLOW UPDATING }
protected void InfoGrid_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e) { ASPxGridView grid = sender as ASPxGridView; ASPxComboBox code = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["Code"], "Code") as ASPxComboBox; SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); SqlCommand cmd = null; SqlDataReader reader = null; string[] arr = code.Text.ToString().Split(';'); string entity_string = arr[0]; if (grid.IsNewRowEditing) { string check = "SELECT COUNT(*) FROM [dbo].[tbl_PONumber] WHERE [EntityCode] = '" + entity_string + "'"; cmd = new SqlCommand(check, conn); Int32 result = Convert.ToInt32(cmd.ExecuteScalar()); if (result > 0) { e.RowError = "Entity Already Exist"; } } else { string PK = e.Keys[0].ToString(); string check = "SELECT [EntityCode] FROM [dbo].[tbl_PONumber] WHERE [EntityCode] = '" + entity_string + "' EXCEPT(SELECT[EntityCode] FROM[dbo].[tbl_PONumber] WHERE[PK] = '" + PK + "')"; cmd = new SqlCommand(check, conn); reader = cmd.ExecuteReader(); bool result = reader.Read(); if (result) { e.RowError = "Entity Already Exist"; } } conn.Close(); }
protected void gridDanhSach_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { string ID = e.Keys[0].ToString(); ASPxGridView grid = sender as ASPxGridView; ASPxTimeEdit te = grid.FindEditRowCellTemplateControl(grid.Columns["GioBatDau"] as GridViewDataColumn, "GioBatDau") as ASPxTimeEdit; object obj = e.NewValues["GioBatDau"].ToString(); string GioBatDau = DateTime.Parse(e.NewValues["GioBatDau"].ToString()).ToString("hh:mm tt"); string GioKetThuc = DateTime.Parse(e.NewValues["GioKetThuc"].ToString()).ToString("hh:mm tt"); string TyLe = e.NewValues["TyLe"].ToString(); data = new dtGio(); data.Sua(ID, DateTime.Parse(GioBatDau), DateTime.Parse(GioKetThuc), TyLe); e.Cancel = true; gridDanhSach.CancelEdit(); LoadGrid(); }
protected void grdSCMProcurementOffDetails_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { ASPxGridView grid = sender as ASPxGridView; ASPxHiddenField masterKey = grdSCMProcurementOffDetails.FindEditRowCellTemplateControl((GridViewDataColumn)grdSCMProcurementOffDetails.Columns["MasterKey"], "ASPxMasterKeyHiddenField") as ASPxHiddenField; ASPxComboBox scmProfCat = grid.FindEditRowCellTemplateControl((GridViewDataColumn)grid.Columns["ProcCatDesc"], "ProcurementCat") as ASPxComboBox; SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); string sLastModified = DateTime.Now.ToString(); string PK = e.Keys[0].ToString(); string update = "UPDATE tbl_System_SCMProcurementOfficer_Details " + " SET [ProcCat] = @ProcCat " + " WHERE ([PK] = @PK)"; SqlCommand cmd = new SqlCommand(update, conn); cmd.Parameters.AddWithValue("@PK", PK); cmd.Parameters.AddWithValue("@ProcCat", scmProfCat.Value.ToString()); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); string updateMaster = "UPDATE tbl_System_SCMProcurementOfficer " + " SET [LastModified] = @LastModified " + " WHERE ([PK] = @PK)"; SqlCommand cmd1 = new SqlCommand(updateMaster, conn); cmd1.Parameters.AddWithValue("@PK", iProcOffMaster.ToString()); cmd1.Parameters.AddWithValue("@LastModified", sLastModified.ToString()); cmd1.CommandType = CommandType.Text; cmd1.ExecuteNonQuery(); conn.Close(); e.Cancel = true; grid.CancelEdit(); BindSCMProcOff_Details(iProcOffMaster); }
private void UpdateMasterAccountActorComboBox(object sender) { ASPxCallbackPanel panel = sender as ASPxCallbackPanel; GridViewEditItemTemplateContainer itemContainer = (GridViewEditItemTemplateContainer)panel.NamingContainer; ASPxGridView grid = itemContainer.Grid; //Get allocation ASPxComboBox allocationComboBox = (ASPxComboBox)grid.FindEditRowCellTemplateControl(grid.Columns["Allocation!Key"] as GridViewDataColumn, "cboAllocation"); if (allocationComboBox.Value == null) { return; } Guid allocationId = (Guid)allocationComboBox.Value; Allocation allocation = session.GetObjectByKey <Allocation>(allocationId); //Get account actor type AllocationAccountActorType masterAllocationAccountActorType = allocation.AllocationAccountActorTypes.FirstOrDefault(r => r.IsMaster); if (masterAllocationAccountActorType == null) { throw new Exception("Invalid allocation. Make sure that the allocation has a master account actor type."); } AccountActorType accountActorType = masterAllocationAccountActorType.AccountActorTypeId; AccountActorTypeEnum accountActorTypeEnum = (AccountActorTypeEnum)Enum.Parse(typeof(AccountActorTypeEnum), accountActorType.Code); //Get account actor combobox AccountActorComboBox accountActorComboBox = (AccountActorComboBox)panel.FindControl("accountActorComboBox"); //FindEditRowCellTemplateControl(grid.Columns["MasterAccountActor"] as GridViewDataColumn, "accountActorComboBox"); //Validation setting accountActorComboBox.ComboBox.ValidationSettings.ErrorDisplayMode = ErrorDisplayMode.ImageWithTooltip; accountActorComboBox.ComboBox.ValidationSettings.RequiredField.IsRequired = true; accountActorComboBox.ComboBox.ValidationSettings.RequiredField.ErrorText = (string)HttpContext.GetGlobalResourceObject("MessageResource", "Msg_Required_Select"); //Set account actor combobox strategy accountActorComboBox.SetAccountActorComboBoxStrategy( AccountActorComboBoxStrategyCreators.GetCreator(accountActorTypeEnum).Create()); }
protected void Grid1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e) { e.NewValues["Remark"] = Helper.Safe.SafeString(e.NewValues["Remark"]).Trim(); e.NewValues["RowUpdateUser"] = HttpContext.Current.User.Identity.Name; e.NewValues["RowUpdateTime"] = DateTime.Now; e.NewValues["LineStatus"] = Helper.Safe.SafeString(e.NewValues["LineStatus"]).Trim(); e.NewValues["Unit"] = Helper.Safe.SafeString(e.NewValues["Unit"]).Trim(); e.NewValues["ContType"] = Helper.Safe.SafeString(e.NewValues["ContType"]).Trim(); if (Helper.Safe.SafeString(e.NewValues["ContType"]).Trim() != "") { e.NewValues["ContSize"] = Helper.Safe.SafeString(e.NewValues["ContType"]).Trim().Substring(0, 2); } else { e.NewValues["ContSize"] = Helper.Safe.SafeString(e.NewValues["ContSize"]).Trim(); } e.NewValues["Remark"] = Helper.Safe.SafeString(e.NewValues["Remark"]).Trim(); e.NewValues["BillScope"] = Helper.Safe.SafeString(e.NewValues["BillScope"]).Trim(); e.NewValues["BillType"] = Helper.Safe.SafeString(e.NewValues["BillType"]).Trim(); e.NewValues["BillClass"] = Helper.Safe.SafeString(e.NewValues["BillClass"]).Trim(); ASPxGridView grid = (sender as ASPxGridView) as ASPxGridView; ASPxButtonEdit txt_ChgCode = grid.FindEditRowCellTemplateControl(null, "txt_Line_ChgCode") as ASPxButtonEdit; string sql = string.Format(@"select ChgcodeDes from XXChgCode where ChgcodeId='{0}'", SafeValue.SafeString(txt_ChgCode.Value)); string chgcodeDes = SafeValue.SafeString(ConnectSql.ExecuteScalar(sql)); if (SafeValue.SafeString(e.NewValues["ChgCodeDe"]) == "") { e.NewValues["ChgCodeDe"] = chgcodeDes; } e.NewValues["ChgCode"] = SafeValue.SafeString(txt_ChgCode.Value); e.NewValues["ChgCodeDe"] = SafeValue.SafeString(e.NewValues["ChgCodeDe"]); e.NewValues["SkuClass"] = Helper.Safe.SafeString(e.NewValues["SkuClass"]).Trim(); e.NewValues["SkuUnit"] = Helper.Safe.SafeString(e.NewValues["SkuUnit"]).Trim(); e.NewValues["JobType"] = Helper.Safe.SafeString(e.NewValues["JobType"]).Trim(); e.NewValues["StorageType"] = Helper.Safe.SafeString(e.NewValues["StorageType"]).Trim(); e.NewValues["VehicleType"] = Helper.Safe.SafeString(e.NewValues["VehicleType"]).Trim(); e.NewValues["GstType"] = Helper.Safe.SafeString(e.NewValues["GstType"]).Trim(); btn_search_Click(null, null); }