private void gv_Detail_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e) { var view = sender as DevExpress.XtraGrid.Views.Grid.GridView; if (Object.Equals(view.FocusedColumn.Tag, "NotNull")) { if (Object.Equals(string.Empty, e.Value) || Object.Equals(null, e.Value) || Object.Equals(DBNull.Value, e.Value)) { e.Valid = false; e.ErrorText = view.FocusedColumn.Caption + "不能为空!"; } } if (view.FocusedColumn.FieldName == tb_PODetail.Qty || view.FocusedColumn.FieldName == tb_PODetail.POPrice) { decimal price = 0; int qty = 0; if (view.FocusedColumn.FieldName == tb_PODetail.Qty) { price = ConvertLib.ToDecimal(view.GetFocusedDataRow()[tb_PODetail.POPrice], 0); qty = ConvertLib.ToInt(e.Value, 0); } else { price = ConvertLib.ToDecimal(e.Value, 0); qty = ConvertLib.ToInt(view.GetFocusedDataRow()[tb_PODetail.Qty], 0); } decimal amount = price * qty; view.SetFocusedRowCellValue(tb_PODetail.TotalPOAmount, amount); RefreshSummary(); } }
void refreshAmount() { int qty = ConvertLib.ToInt(txtQty.EditValue); decimal price = ConvertLib.ToDecimal(txtUnitPrice.EditValue, 0); txtTotalAmount.EditValue = qty * price; }
private void btn_OK_Click(object sender, EventArgs e) { bool b = LibraryTools.IsNotEmpBaseEdit(txtItemNo, "货号不能为空!"); if (b == false) { return; } Data = new DataTable(); Data.Columns.Add(nameof(tb_PODetail.ItemNo), typeof(System.String)); Data.Columns.Add(nameof(tb_PODetail.ItemName), typeof(System.String)); Data.Columns.Add(nameof(tb_PODetail.CategoryID), typeof(System.String)); Data.Columns.Add(nameof(tb_PODetail.POPrice), typeof(System.Decimal)); Data.Columns.Add(nameof(tb_PODetail.SOPrice), typeof(System.Decimal)); Data.Columns.Add(nameof(tb_PODetail.Color), typeof(System.String)); Data.Columns.Add(nameof(tb_PODetail.Size), typeof(System.String)); Data.Columns.Add(nameof(tb_PODetail.Qty), typeof(System.Int16)); Data.Columns.Add(nameof(tb_PODetail.TotalPOAmount), typeof(System.Decimal)); foreach (DataRow row in dtQty.Rows) { string color = ConvertLib.ToString(row["Color"]); for (int i = 0; i < dtSize.Rows.Count; i++) { string fileName = "Qty_" + (i + 1); int qty = ConvertLib.ToInt(row[fileName]); if (qty > 0) { DataRow dr = Data.NewRow(); dr[tb_PODetail.ItemNo] = txtItemNo.EditValue; if (!String.IsNullOrEmpty(ConvertLib.ToString(txtItemName.EditValue))) { dr[tb_PODetail.ItemName] = txtItemName.EditValue; } dr[tb_PODetail.CategoryID] = txtCategory.EditValue; if (!String.IsNullOrEmpty(ConvertLib.ToString(txtPOPrice.EditValue))) { dr[tb_PODetail.POPrice] = txtPOPrice.EditValue; } if (!String.IsNullOrEmpty(ConvertLib.ToString(txtSOPrice.EditValue))) { dr[tb_PODetail.SOPrice] = txtSOPrice.EditValue; } dr[tb_PODetail.Color] = color; dr[tb_PODetail.Size] = dtSize.Rows[i]["DataName"]; dr[tb_PODetail.Qty] = qty; dr[tb_PODetail.TotalPOAmount] = ConvertLib.ToDecimal(txtPOPrice.EditValue, 0) * qty; Data.Rows.Add(dr); } } } Data.AcceptChanges(); this.DialogResult = DialogResult.OK; }
private void btn_OK_Click(object sender, EventArgs e) { decimal amount = ConvertLib.ToDecimal(txtAmount.EditValue, 0); AmountIn = ConvertLib.ToDecimal(txtIn.EditValue, 0); AmountOut = ConvertLib.ToDecimal(txtOut.EditValue, 0); if (AmountIn < amount) { Msg.ShowError("收款金额不能小于应收款"); } else { this.DialogResult = DialogResult.OK; } }
//结算 private void btn_Complete_Click(object sender, EventArgs e) { //Msg.ShowInformation("结算"); bool validate = LibraryTools.IsNotEmpBaseEdit(txt_Sale, "销售员不能为空!"); if (validate == false) { Msg.Warning("请检查必填项"); return; } decimal Amount = ConvertLib.ToDecimal(gcTotalAmount.SummaryItem.SummaryValue, 0); decimal AmountIn = 0, AmountOut = 0; DialogResult result = frmDailogSalePay.ShowForm(Amount, out AmountIn, out AmountOut); //frmDailogSalePay frm = new Dialog.frmDailogSalePay(); //frm.Amount = Amount; //DialogResult result = frm.ShowDialog(); if (result != DialogResult.OK) { return; } DataRow row = EditData.Tables[tb_SO._TableName].Rows.Add(); row[tb_SO.DocDate] = bll.GetServerTime(); row[tb_SO.SaleBy] = txt_Sale.EditValue; row[tb_SO.TotalQty] = gcQty.SummaryItem.SummaryValue; row[tb_SO.TotalAmount] = row[tb_SO.TotalPrice] = Amount; row[tb_SO.AmountIn] = AmountIn; row[tb_SO.AmountOut] = AmountOut; foreach (DataRow dr in EditData.Tables[tb_SODetail._TableName].Rows) { dr[tb_SODetail.SaleBy] = txt_Sale.EditValue; } bool success = bll.Update(EditData); if (success == true) { EditData.Tables[tb_SO._TableName].Rows.Clear(); EditData.Tables[tb_SODetail._TableName].Rows.Clear(); EditData.AcceptChanges(); refreshTotalMsg(); } }
void Find() { DataTable dt = bllpi.SearchDataBarCode(txt_ProductCode.Text); DataRow row; if (dt.Rows.Count != 1) { row = Dialog.frmDialogProducQty.ShowForm(txt_ProductCode.Text, dt); } else { row = dt.Rows[0]; } //DataRow row = Dialog.frmDialogProducQty.ShowForm(txt_ProductCode.Text); if (row != null) { var al = EditData.Tables[tb_SODetail._TableName].Select($"{tb_SODetail.BarCode}='{row[tb_ProductInventory.BarCode]}'").FirstOrDefault(); if (al != null) { int newQty = ConvertLib.ToInt(al[tb_SODetail.Qty]) + 1; al[tb_SODetail.Qty] = newQty; al[tb_SODetail.TotalAmount] = ConvertLib.ToDecimal(al[tb_SODetail.UnitPrice], 0) * newQty; } else { DataRow dr = EditData.Tables[tb_SODetail._TableName].NewRow(); dr[tb_SODetail.BarCode] = row[tb_ProductInventory.BarCode]; dr[tb_SODetail.ItemNo] = row[tb_ProductInventory.ItemNo]; dr[tb_SODetail.ItemName] = row[tb_ProductInventory.ItemName]; dr[tb_SODetail.CategoryID] = row[tb_ProductInventory.CategoryID]; dr[tb_SODetail.Color] = row[tb_ProductInventory.Color]; dr[tb_SODetail.Size] = row[tb_ProductInventory.Size]; dr[tb_SODetail.Qty] = 1; dr[tb_SODetail.UnitPrice] = row[tb_ProductInventory.SOPrice]; dr[tb_SODetail.TotalAmount] = ConvertLib.ToDecimal(row[tb_ProductInventory.SOPrice], 0) * 1; EditData.Tables[tb_SODetail._TableName].Rows.Add(dr); gvSummary.ClearSelection(); gvSummary.SelectRow(gvSummary.RowCount - 1); gvSummary.FocusedRowHandle = gvSummary.RowCount - 1; } txt_ProductCode.EditValue = ""; refreshTotalMsg(); } }
private void btn_OK_Click(object sender, EventArgs e) { value = ConvertLib.ToDecimal(textEdit1.EditValue, 0); this.Close(); }
private void txtIn_EditValueChanged(object sender, EventArgs e) { txtOut.EditValue = ConvertLib.ToDecimal(txtIn.EditValue, 0) - ConvertLib.ToDecimal(txtAmount.EditValue, 0); }