void gridView_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
GridView view = sender as GridView;
GridView gridView = (GridView)MainView;
ManagerTimeKeeperEntities entity = (ManagerTimeKeeperEntities)((BaseModuleERP)Screen.Module).CurrentModuleEntity;
if (e.RowHandle >= 0)
{
HRTimeKeeperCompletesInfo objTimeKeeperCompletesInfo = (HRTimeKeeperCompletesInfo)gridView.GetRow(e.RowHandle);
((ManagerTimeKeeperModule)Screen.Module).AddBackupList(objTimeKeeperCompletesInfo);
if (e.Column.FieldName == "HRTimeKeeperCompleteTimeCheck")
{
//1.CheckSameTime
((ManagerTimeKeeperModule)Screen.Module).CheckSameTime(objTimeKeeperCompletesInfo, entity.TimeKeeperCompletesList.ToList());
//2.CheckNotInOverTime
((ManagerTimeKeeperModule)Screen.Module).CheckNotInOverTime(objTimeKeeperCompletesInfo, 60, true);
//2.CheckNotInOverTime
((ManagerTimeKeeperModule)Screen.Module).CheckOverTimeAbsence(objTimeKeeperCompletesInfo, 60, true);
}
if (e.Column.FieldName == "HRTimeKeeperCompleteDate")
{
((ManagerTimeKeeperModule)Screen.Module).ChangeCompleteDate(objTimeKeeperCompletesInfo);
}
}
}
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
try
{
this.BaseFocusLabel.Focus();
if (e.Column.FieldName == "GrossQty")
{
// 净重=毛米长（米）*克重 （千克/米）*门幅（米） 毛重=净重+0.05kg 云虹公式：
ColumnView view = sender as ColumnView;
decimal grossqty = SysConvert.ToDecimal(view.GetRowCellValue(view.FocusedRowHandle, "GrossQty")); //毛米长
decimal grossweight = SysConvert.ToDecimal(view.GetRowCellValue(view.FocusedRowHandle, "GrossWeight")); //毛重
decimal netweight = SysConvert.ToDecimal(view.GetRowCellValue(view.FocusedRowHandle, "NetWeight")); //净重
decimal mwidth = SysConvert.ToDecimal(view.GetRowCellValue(view.FocusedRowHandle, "MWidth")); //门幅
decimal mweight = SysConvert.ToDecimal(view.GetRowCellValue(view.FocusedRowHandle, "MWeight")); //克重
if (mwidth > 0 && mwidth < 1000)
{
decimal mf = mwidth * SysConvert.ToDecimal(0.01);
decimal kz = mweight * SysConvert.ToDecimal(0.001);
decimal jz = SysConvert.ToDecimal(grossqty * mf * kz, 2);
view.SetRowCellValue(view.FocusedRowHandle, "NetWeight", jz);
decimal mz = jz + SysConvert.ToDecimal(0.05);
view.SetRowCellValue(view.FocusedRowHandle, "GrossWeight", mz);
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
private void viewListado_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
ro_nomina_tipo_liqui_orden_Info oFila = new ro_nomina_tipo_liqui_orden_Info();
try
{
int cont = 0;
oFila = (ro_nomina_tipo_liqui_orden_Info)viewListado.GetRow(e.RowHandle);
if (oFila != null)
{
if (e.Column.Name == "colOrden")
{
cont = (from a in oLstOrdenRubrosNomina_Info
where a.Orden == oFila.Orden
select a).Count();
if (cont > 1)
{
MessageBox.Show("El Orden se encuentra repetido, revise por favor", "ATENCION", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
Log_Error_bus.Log_Error(ex.ToString());
}
}
/// <summary>
/// 主表单元格值变化进行的操作
/// </summary>
private void gridViewPSchedule_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
try
{
switch (e.Column.FieldName)
{
case "CodeFileName":
string tmpStr = DataTypeConvert.GetString(gridViewPSchedule.GetDataRow(e.RowHandle)["CodeFileName"]);
if (tmpStr == "")
{
gridViewPSchedule.SetRowCellValue(e.RowHandle, "CodeName", "");
}
else
{
DataTable temp = (DataTable)repSearchCodeFileName.DataSource;
DataRow[] drs = temp.Select(string.Format("CodeFileName='{0}'", tmpStr));
if (drs.Length > 0)
{
gridViewPSchedule.SetRowCellValue(e.RowHandle, "CodeName", DataTypeConvert.GetString(drs[0]["CodeName"]));
}
}
break;
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--主表单元格值变化进行的操作错误。", ex);
}
}
void rootgridViewPaymentTerms_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
try
{
GridView view = sender as GridView;
if (CurrentState == ActionsStates.Edit)
{
PaymentTerms tmpPaymentTerms = new PaymentTerms();
object idPaymentTerms = view.GetRowCellValue(view.FocusedRowHandle, nameof(PaymentTerms.IdPaymentTerms));
object description = view.GetRowCellValue(view.FocusedRowHandle, nameof(PaymentTerms.Description));
object descriptionZh = view.GetRowCellValue(view.FocusedRowHandle, nameof(PaymentTerms.DescriptionZh));
tmpPaymentTerms.IdPaymentTerms = (idPaymentTerms ?? string.Empty).ToString();
tmpPaymentTerms.Description = (description ?? string.Empty).ToString();
tmpPaymentTerms.DescriptionZh = (descriptionZh ?? string.Empty).ToString();
AddModifiedPaymentTermToList(tmpPaymentTerms);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void GVDanhSachDaCapMa_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
GridView view = sender as GridView;
var columnHandle = e.Column.ColumnHandle;
var rowHandle = e.RowHandle;
var maDonvi = view.GetRowCellValue(rowHandle, this.col_MaDonVi_GCDaCapMau);
var maXN = view.GetRowCellValue(rowHandle, this.col_MaXetNghiem_GCDaCapMau);
//int sLuong = view.GetRowCellValue(rowHandle, this.col_SoLuong) == null ? 1 : int.Parse(view.GetRowCellValue(rowHandle, this.col_SoLuong).ToString());
//var GtriBatDau = view.GetRowCellValue(rowHandle, this.col_MaBatDau) == null ? string.Empty : view.GetRowCellValue(rowHandle, this.col_MaBatDau).ToString();
//var GtriKetThuc = view.GetRowCellValue(rowHandle, this.col_MaKetThuc) == null ? string.Empty : view.GetRowCellValue(rowHandle, this.col_MaKetThuc).ToString();
if (rowHandle < view.RowCount)
{
if (columnHandle == this.col_MaXetNghiem_GCDaCapMau.ColumnHandle)
{
var rs = this.lstDaDanhMaXN.FirstOrDefault(p => p.MaXetNghiem == maXN.ToString());
var valueOld = view.ActiveEditor.OldEditValue;
if (rs != null)
{
if (!string.IsNullOrEmpty(valueOld.ToString()))
{
for (int i = 0; i < view.RowCount; i++)
{
if (view.GetRowCellValue(i, this.col_MaXetNghiem_GCDaCapMau).Equals(maXN) && !i.Equals(rowHandle))
{
view.SetRowCellValue(i, this.col_MaXetNghiem_GCDaCapMau, valueOld.ToString());
break;
}
}
}
}
}
}
}
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
// xmlhelper.Read("bookstore/book[@ISBN=\"7-111-19149-6\"]") Attributes 的属性
// xmlhelper.Read("bookstore/book[title=\"计算机硬件技术基础\"]") 内部节点
XmlNodeList xmlNodeLst = xmlhelper.Read("datatype/item[@gid=\"" + tmpconstantInfo.Gid + "\"]");
Int32 idx = -1;
switch (e.Column.ToString())
{
case "名称":
idx = 0;
break;
case "常量值":
idx = 1;
break;
case "说明":
idx = 2;
break;
}
if (idx == -1)
{
return;
}
xmlNodeLst.Item(idx).InnerText = e.Value.ToString();
xmlhelper.Save(false);
tmpconstantInfo = null;
}
private void gvPO_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
DataRow row = gvPO.GetDataRow(e.RowHandle);
if (e.Column == colSupplierCode || e.Column == colSupplierName)
{
string code = (string)row[e.Column.FieldName];
row[colSupplierCode.FieldName] = code;
row[colSupplierName.FieldName] = code;
}
else if (e.Column == colProjectCode || e.Column == colProjectName)
{
int projectId = (int)row[e.Column.FieldName];
row[colProjectCode.FieldName] = projectId;
row[colProjectName.FieldName] = projectId;
row[colBillable.FieldName] = Project.GetProject(projectId)?.Billable ?? false;
}
if (!gvPO.IsNewItemRow(e.RowHandle))
{
if (new GridColumn[] { colPODate, colPONumber, colSupplierCode, colSupplierName, colProjectCode, colProjectName, colBillable }.Contains(e.Column))
{
FieldPO.SqlUpdate((int)row[colId.FieldName], (DateTime)row[colPODate.FieldName], Convert.ToString(row[colPONumber.FieldName]),
(string)row[colSupplierCode.FieldName], (int)row[colProjectCode.FieldName], (bool)row[colBillable.FieldName]);
row[colStatus.FieldName] = Enum.GetName(typeof(EnumSubmitStatus), EnumSubmitStatus.Open);
btnSubmit.Enabled = true;
}
}
}
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (!GridViewVouch.IsFilterRow(e.RowHandle))
{
modified = true;
}
}
void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (!CellExists(gridView1.GetDataSourceRowIndex(e.RowHandle), e.Column))
{
modifiedCells.Add(new GridCell(gridView1.GetDataSourceRowIndex(e.RowHandle), e.Column));
}
}
private void gridViewLeaveDayDetail_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (e.Column == colDayOffType)
{
CalculateLeaveDays();
}
}
void rootgridViewFamiliesHk_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
try
{
GridView view = sender as GridView;
if (CurrentState == ActionsStates.Edit)
{
FamilyHK tmpFamilyHK = new FamilyHK();
object idFamilyHk = view.GetRowCellValue(view.FocusedRowHandle, nameof(FamilyHK.IdFamilyHk));
object description = view.GetRowCellValue(view.FocusedRowHandle, nameof(FamilyHK.Description));
tmpFamilyHK.IdFamilyHk = (idFamilyHk ?? string.Empty).ToString();
tmpFamilyHK.Description = (description ?? string.Empty).ToString();
AddModifiedFamilyHkToList(tmpFamilyHK);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void grvData_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
decimal qty = TextUtils.ToDecimal(grvData.GetRowCellValue(e.RowHandle, colQty));
decimal vat = TextUtils.ToDecimal(grvData.GetRowCellValue(e.RowHandle, colVAT)) / 100;
decimal priceHD = TextUtils.ToDecimal(grvData.GetRowCellValue(e.RowHandle, colPriceHD));
decimal priceTPA = TextUtils.ToDecimal(grvData.GetRowCellValue(e.RowHandle, colPriceTPA));
decimal priceReal = TextUtils.ToDecimal(grvData.GetRowCellValue(e.RowHandle, colPriceReal));
decimal priceVT = TextUtils.ToDecimal(grvData.GetRowCellValue(e.RowHandle, colPriceDT));
string priceType = TextUtils.ToString(grvData.GetRowCellValue(e.RowHandle, colPriceType));
int costGroupID = TextUtils.ToInt(grvData.GetRowCellValue(e.RowHandle, colCostGroupID));
bool isChange = false;
if (e.Column == colQty)
{
grvData.SetRowCellValue(e.RowHandle, colTotalVT, qty * priceVT);
grvData.SetRowCellValue(e.RowHandle, colTotalHD, qty * priceHD);
grvData.SetRowCellValue(e.RowHandle, colTotalTPA, qty * priceTPA);
grvData.SetRowCellValue(e.RowHandle, colTotalReal, qty * priceReal);
isChange = true;
}
if (e.Column == colVAT)
{
grvData.SetRowCellValue(e.RowHandle, colPriceHDnoVAT, priceHD * (1 - vat));
grvData.SetRowCellValue(e.RowHandle, colTotalHDnoVat, qty * (priceHD * (1 - vat)));
isChange = true;
}
if (e.Column == colPriceType || e.Column == colPriceDT || e.Column == colCostGroupID)
{
decimal costSX = GetCostSX(costGroupID, priceVT);
decimal costTM = GetCostTM(costGroupID, priceVT);
if (priceType.ToUpper() == "SX")
{
grvData.SetRowCellValue(e.RowHandle, colPriceTPA, costSX);
grvData.SetRowCellValue(e.RowHandle, colTotalTPA, qty * costSX);
}
else
{
grvData.SetRowCellValue(e.RowHandle, colPriceTPA, costTM);
grvData.SetRowCellValue(e.RowHandle, colTotalTPA, qty * costTM);
}
}
if (e.Column == colPriceHD)
{
grvData.SetRowCellValue(e.RowHandle, colPriceHDnoVAT, priceHD * (1 - vat));
grvData.SetRowCellValue(e.RowHandle, colTotalHDnoVat, qty * (priceHD * (1 - vat)));
grvData.SetRowCellValue(e.RowHandle, colTotalHD, qty * priceHD);
isChange = true;
}
if (isChange)
{
loadRealPrice();
}
}
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
//if (e.Column.FieldName == "PorcDesc")
//{
// bEditMontoDesc = false;
// bEditPorcDesc = true;
//}
}
void gvMain_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (e.Column.FieldName == "AdjustQTY")
{
gvMain.SetFocusedRowCellValue(gvMain.Columns["TotalQTY"],
Convert.ToDecimal(e.Value) + Convert.ToDecimal(gvMain.GetFocusedRowCellValue("FinishJobQTY")));
}
}
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
ColumnView view = gridControl1.FocusedView as ColumnView;
// if (view.UpdateCurrentRow())
{
dataTableAdapter.Update(eJX_DATADataSet.Data);
}
}
private void advBandedGridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (!AdvBandedGridViewDigHdr.IsFilterRow(e.RowHandle))
{
modified = true;
labelControl7.Text = DateTime.Today.ToShortDateString();
}
}
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (string.IsNullOrEmpty((gridView1.GetFocusedRow() as ConstantInfo).Gid) && (gridView1.FocusedRowHandle + 1 == gridView1.RowCount))
{
btnAdd_Click(null, null);
}
tmpconstantInfo = gridView1.GetRow(e.RowHandle) as ConstantInfo;
}
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (!GridViewBusTable.IsFilterRow(e.RowHandle))
{
modified = true;
}
labelControl1.Text = DateTime.Today.ToShortDateString();
labelControl2.Text = username;
}
private void dvgBsDetails_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
//if(e.Column.FieldName== "Amount")
//{
// decimal value;
// value = Convert.ToDecimal(Amount.SummaryItem.SummaryValue)-Convert.ToDecimal(e.Value.ToString());
//}
}
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
//DevExpress.XtraGrid.Views.Grid.GridView view = sender as DevExpress.XtraGrid.Views.Grid.GridView;
////MessageBox.Show("" + e.RowHandle + "");
//viethoadon(e.RowHandle);
//BandedGridView view = sender as BandedGridView;
//decimal a = 1000;
//view.Columns["TotalPrice"]
}
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
// xmlhelper.Read("bookstore/book[@ISBN=\"7-111-19149-6\"]") Attributes 的属性
// xmlhelper.Read("bookstore/book[title=\"计算机硬件技术基础\"]") 内部节点
XmlNodeList xmlNodeLst = xmlhelper.Read("datatype/item[@gid=\"" + tmpdataTypeInfo.Gid + "\"]");
Int32 idx = -1;
switch (e.Column.ToString())
{
case "类型名":
idx = 0;
break;
case "名称":
idx = 1;
break;
case "Oracle":
idx = 2;
break;
case "Mysql":
idx = 3;
break;
case "DB2":
idx = 4;
break;
case "Sql Server":
idx = 5;
break;
case "Sqlite":
idx = 6;
break;
case "Access":
idx = 7;
break;
case "CShort":
idx = 8;
break;
}
if (idx == -1)
{
return;
}
xmlNodeLst.Item(idx).InnerText = e.Value.ToString();
xmlhelper.Save(false);
tmpdataTypeInfo = null;
}
/// <summary>
/// 套餐类别变更
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (e.Column.FieldName == "CB002") //套餐类别
{
if (e.Value.ToString() == "1")
{
(sender as ColumnView).SetRowCellValue(e.RowHandle, "CB005", null);
}
}
}
private void dvgItemDetails_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
List <ItemMasterModel> lstItems = objIMBL.GetItemsByName(e.Value.ToString());
if (e.Column.Caption == "Item")
{
if (e.Value.ToString() == null)
{
dvgBsDetails.Focus();
}
else
{
List <string> lstUnits = new List <string>();
foreach (ItemMasterModel objUnits in lstItems)
{
lstUnits.Add(objUnits.MainUnit);
lstUnits.Add(objUnits.AltUnit);
}
UnitsLookup.DataSource = lstUnits;
}
}
if (e.Column.Caption == "Qty" || e.Column.Caption == "Basic Amt" || e.Column.Caption == "Price(Rs.)")
{
GridView view = sender as GridView;
decimal Qty = Convert.ToDecimal(view.GetRowCellValue(e.RowHandle, view.Columns["Qty"]).ToString());
decimal Price = Convert.ToDecimal(view.GetRowCellValue(e.RowHandle, view.Columns["Price"]).ToString() == string.Empty ? "0.00" : view.GetRowCellValue(e.RowHandle, view.Columns["Price"]).ToString());
decimal BasicAmt = Convert.ToDecimal(view.GetRowCellValue(e.RowHandle, view.Columns["BasicAmt"]).ToString() == string.Empty ? "0.00" : view.GetRowCellValue(e.RowHandle, view.Columns["BasicAmt"]).ToString());
decimal TaxSlab = 5;
if (view.GetRowCellValue(e.RowHandle, view.Columns["Qty"]).ToString() != string.Empty && view.GetRowCellValue(e.RowHandle, view.Columns["Price"]).ToString() != string.Empty)
{
//if (tbxSaleType.SelectedItem.ToString() == "VAT Incl")
//{
// TaxCalculationModel objTax = objSTCal.VATInclusive(Qty, Price, BasicAmt, TaxSlab);
// view.SetRowCellValue(e.RowHandle, view.Columns["Amount"], Math.Round(objTax.TotalAmount, 2));
// view.SetRowCellValue(e.RowHandle, view.Columns["BasicAmt"], Math.Round(objTax.BasicAmount, 2));
// view.SetRowCellValue(e.RowHandle, view.Columns["TaxAmount"], Math.Round(objTax.TaxAmount, 2));
// view.SetRowCellValue(e.RowHandle, view.Columns["Price"], Math.Round(objTax.Price, 2));
//}
}
}
//decimal Value;
//if (e.Column.Caption == "Basic Amt")
//{
// Value = Convert.ToDecimal(e.Value.ToString()) / Convert.ToDecimal(view.GetRowCellValue(e.RowHandle, view.Columns["Qty"]).ToString());
// if (tbxSaleType.SelectedItem.ToString() == "VAT Incl")
// {
// TaxCalculationModel objTax = objSTCal.VATInclusive(Convert.ToDecimal(view.GetRowCellValue(e.RowHandle, view.Columns["Qty"]).ToString()), Convert.ToDecimal(va), 5);
// view.SetRowCellValue(e.RowHandle, view.Columns["BasicAmt"], Math.Round(objTax.BasicAmount, 2));
// view.SetRowCellValue(e.RowHandle, view.Columns["TaxAmount"], Math.Round(objTax.TaxAmount, 2));
// view.SetRowCellValue(e.RowHandle, view.Columns["Amount"], Math.Round(objTax.TotalAmount, 2));
// }
//}
}
private void gvEquipment_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
DataRow row = gvEquipment.GetDataRow(e.RowHandle);
if (e.Column == colEqpNum || e.Column == colAssetDescription)
{
string eqtNum = Convert.ToString(row[e.Column.FieldName]);
row[colEqpNum.FieldName] = eqtNum;
row[colAssetDescription.FieldName] = eqtNum;
var equip = Equipment.GetEquipment(eqtNum);
row[colEquipmentClass.FieldName] = EquipmentClass.GetEquipmentClass(equip.ClassCode)?.DisplayName ?? "";
Employee employee = (equip.OwnerType == EnumOwnerType.Employee) ? EquipmentAssignment.GetEmployee(equip.EqpNum, _headerRecord.LogDate) : null;
row[colEmpNum.FieldName] = (object)employee?.EmpNum ?? DBNull.Value;
row[colEmployeeName.FieldName] = employee?.DisplayName ?? "";
RefreshBillRate(row);
}
else if (e.Column == colLevel1Code)
{
row[colLevel2Code.FieldName] = DBNull.Value;
row[colLevel3Code.FieldName] = DBNull.Value;
row[colLevel4Code.FieldName] = DBNull.Value;
}
else if (e.Column == colLevel2Code)
{
row[colLevel3Code.FieldName] = DBNull.Value;
row[colLevel4Code.FieldName] = DBNull.Value;
}
else if (e.Column == colLevel3Code)
{
row[colLevel4Code.FieldName] = DBNull.Value;
}
else if (e.Column == colBillCycle)
{
RefreshBillRate(row);
}
else if (e.Column == colQuantity)
{
RefreshBillAmount(row);
}
if (!gvEquipment.IsNewItemRow(e.RowHandle))
{
if (new GridColumn[] { colEqpNum, colAssetDescription, colChangeOrder, colLevel1Code, colLevel2Code, colLevel3Code, colLevel4Code, colBillable, colQuantity, colBillCycle }.Contains(e.Column))
{
EquipTimeEntry.SqlUpdate((int)row[colId.FieldName], (string)row[colEqpNum.FieldName], ConvertEx.ToNullable <int>(row[colEmpNum.FieldName]), ConvertEx.ToNullable <int>(row[colChangeOrder.FieldName]),
ConvertEx.ToNullable <int>(row[colLevel1Code.FieldName]), ConvertEx.ToNullable <int>(row[colLevel2Code.FieldName]), ConvertEx.ToNullable <int>(row[colLevel3Code.FieldName]), ConvertEx.ToNullable <int>(row[colLevel4Code.FieldName]),
(bool)row[colBillable.FieldName], ConvertEx.ToNullable <decimal>(row[colQuantity.FieldName]) ?? 0, ConvertEx.CharToEnum <EnumBillCycle>(row[colBillCycle.FieldName]), ConvertEx.ToNullable <decimal>(row[colBillAmount.FieldName]));
LemHeader.SqlUpdateSubmitStatus(_headerRecord.Id, EnumSubmitStatus.Open);
}
}
}
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
GridView view = sender as GridView;
int HTV = 0;
long a = 0;
switch (e.Column.FieldName)
{
case "GiaHeThong2":
case "GiaHeThong":
case "GiaYeuCau":
view.SetRowCellValue(e.RowHandle, view.Columns["CL1"], (long)view.GetRowCellValue(e.RowHandle, view.Columns["GiaYeuCau"]) - (long)view.GetRowCellValue(e.RowHandle, view.Columns["GiaHeThong"]));
view.SetRowCellValue(e.RowHandle, view.Columns["CL5"], (long)view.GetRowCellValue(e.RowHandle, view.Columns["CL1"]) * 10 / 11);
view.SetRowCellValue(e.RowHandle, view.Columns["CL2"], (long)view.GetRowCellValue(e.RowHandle, view.Columns["CL1"]) * (float)view.GetRowCellValue(e.RowHandle, view.Columns["PhanTram"]) / 100);
if ((long)view.GetRowCellValue(e.RowHandle, view.Columns["GiaHeThong2"]) > 0)
{
view.SetRowCellValue(e.RowHandle, view.Columns["CL3"], (long)view.GetRowCellValue(e.RowHandle, view.Columns["GiaYeuCau"]) - (long)view.GetRowCellValue(e.RowHandle, view.Columns["GiaHeThong2"]));
view.SetRowCellValue(e.RowHandle, view.Columns["CL6"], (long)view.GetRowCellValue(e.RowHandle, view.Columns["CL3"]) * 10 / 11);
view.SetRowCellValue(e.RowHandle, view.Columns["CL4"], (long)view.GetRowCellValue(e.RowHandle, view.Columns["CL3"]) * (float)view.GetRowCellValue(e.RowHandle, view.Columns["PhanTram2"]) / 100);
}
HTV = (int)view.GetRowCellValue(e.RowHandle, view.Columns["HanhTrinhVe"]);
a = (long)view.GetRowCellValue(e.RowHandle, view.Columns["CL1"]) / (HTV > 0 ? 2 : 1);
if (a > 50000)
{
view.SetRowCellValue(e.RowHandle, view.Columns["PhanTram"], 10);
}
a = 0;
bandedGridView1.BestFitColumns();
break;
case "PhanTram2":
case "PhanTram":
view.SetRowCellValue(e.RowHandle, view.Columns["CL2"], (long)view.GetRowCellValue(e.RowHandle, view.Columns["CL1"]) * (float)view.GetRowCellValue(e.RowHandle, view.Columns["PhanTram"]) / 100);
if ((long)view.GetRowCellValue(e.RowHandle, view.Columns["GiaHeThong2"]) > 0)
{
view.SetRowCellValue(e.RowHandle, view.Columns["CL4"], (long)view.GetRowCellValue(e.RowHandle, view.Columns["CL3"]) * (float)view.GetRowCellValue(e.RowHandle, view.Columns["PhanTram2"]) / 100);
}
break;
case "CL1":
HTV = (int)view.GetRowCellValue(e.RowHandle, view.Columns["HanhTrinhVe"]);
a = (long)view.GetRowCellValue(e.RowHandle, view.Columns["CL1"]) / (HTV > 0 ? 2 : 1);
if (a > 50000)
{
view.SetRowCellValue(e.RowHandle, view.Columns["PhanTram"], 10);
}
a = 0;
break;
}
}
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
Task task = gridView1.GetRow(e.RowHandle) as Task;
if (e.Column == colComplete && task != null)
{
task.Complete = !task.Complete;
gridView1.CloseEditor();
gridView1.UpdateCurrentRow();
}
}
/// <summary>
/// 数据改变事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridView2_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (e.Column.FieldName.ToUpper() == "AC116") //出生日期
{
if (e.Value != null && !(e.Value is DBNull))
{
ChineseDateTime cdt = new ChineseDateTime(Convert.ToDateTime(e.Value));
gridView2.SetRowCellValue(e.RowHandle, "AC117", cdt.ToChineseString());
}
}
}
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
try
{
//if (e.Column.FieldName == "YM")//修改原码
//{
// int DID = SysConvert.ToInt32(gridView1.GetFocusedRowCellValue("DID"));
// CheckOrderISNRule rule = new CheckOrderISNRule();
// CheckOrderISN entity = new CheckOrderISN();
// entity.ID = DID;
// entity.SelectByID();
// if (SysConvert.ToDecimal(gridView1.GetFocusedRowCellValue("YM")) != entity.YM)
// {
// if (!FCommon.RightCheck(this.FormID, this.RightFormID, this.FormListAID, this.FormListBID, RightSub.新增))
// {
// this.ShowMessage("你没有此操作权限");
// return;
// }
// entity.YM = SysConvert.ToDecimal(gridView1.GetFocusedRowCellValue("YM"));
// rule.RUpdate(entity);
// }
//}
//if (e.Column.FieldName == "CheckFlag")
//{
// if (SysConvert.ToInt32(gridView1.GetFocusedRowCellValue("CheckFlag")) == 1)
// {
// int ID = SysConvert.ToInt32(gridView1.GetFocusedRowCellValue("ID"));
// for (int i = 0; i < gridView1.RowCount; i++)
// {
// if (SysConvert.ToInt32(gridView1.GetRowCellValue(i, "CheckFlag")) == 1)
// {
// if (ID != SysConvert.ToInt32(gridView1.GetRowCellValue(i, "ID")))
// {
// this.ShowMessage("请勾选同一缸号！");
// gridView1.SetFocusedRowCellValue("CheckFlag", 0);
// }
// }
// }
// }
//}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 子表单元格值变化进行的操作
/// </summary>
private void gridViewSWWList_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
try
{
switch (e.Column.FieldName)
{
case "CodeFileName":
string tmpStr = DataTypeConvert.GetString(gridViewSWWList.GetDataRow(e.RowHandle)["CodeFileName"]);
if (tmpStr == "")
{
gridViewSWWList.SetRowCellValue(e.RowHandle, "CodeName", "");
}
else
{
DataTable temp = (DataTable)repSearchCodeFileName.DataSource;
DataRow[] drs = temp.Select(string.Format("CodeFileName='{0}'", tmpStr));
if (drs.Length > 0)
{
gridViewSWWList.SetRowCellValue(e.RowHandle, "CodeName", DataTypeConvert.GetString(drs[0]["CodeName"]));
}
}
break;
case "ProjectName":
string projectNameStr = DataTypeConvert.GetString(gridViewSWWList.GetDataRow(e.RowHandle)["ProjectName"]);
string projectNoStr = "";
if (projectNameStr == "")
{
gridViewSWWList.SetRowCellValue(e.RowHandle, "ProjectNo", "");
gridViewSWWList.SetRowCellValue(e.RowHandle, "ProjectName", "");
gridViewSWWList.SetRowCellValue(e.RowHandle, "StnNo", "");
}
else
{
DataTable temp = (DataTable)repSearchProjectNo.DataSource;
DataRow[] drs = temp.Select(string.Format("ProjectName='{0}'", projectNameStr));
if (drs.Length > 0)
{
gridViewSWWList.SetRowCellValue(e.RowHandle, "ProjectNo", DataTypeConvert.GetString(drs[0]["ProjectNo"]));
projectNoStr = DataTypeConvert.GetString(drs[0]["ProjectNo"]);
}
gridViewSWWList.SetRowCellValue(e.RowHandle, "StnNo", "");
}
BingStnListComboBox(projectNoStr);
break;
}
}
catch (Exception ex)
{
ExceptionHandler.HandleException(this.Text + "--子表单元格值变化进行的操作错误。", ex);
}
}
private void gvRate_CellValueChanged(object sender, CellValueChangedEventArgs e)
{
var rate = gvRate.GetRow(gvRate.FocusedRowHandle) as WorkHourStandartDrawing;
if (rate != null)
{
_controller.SaveRate(rate);
}
}
private void gvTopView_CellValueChanged(object sender, CellValueChangedEventArgs e)
{
var doc = (StandartDrawing)gvTopView.GetRow(e.RowHandle);
if (doc != null)
_controller.Save(doc);
}
