private void gridViewShift_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
try
{
int Id = 0;
int.TryParse(gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "Id").ToString(), out Id);
if (Id == 0 && string.IsNullOrEmpty(gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "Name").ToString()))
{
goto End;
}
else if (Id == 0 && string.IsNullOrEmpty(gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "Start").ToString()))
{
goto End;
}
else if (Id == 0 && string.IsNullOrEmpty(gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "End").ToString()))
{
goto End;
}
if (Id != 0 && string.IsNullOrEmpty(gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "Name").ToString()))
{
MessageBox.Show("Vui lòng nhập tên ca làm việc.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Id != 0 && string.IsNullOrEmpty(gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "Start").ToString()))
{
MessageBox.Show("Vui lòng chọn thời gian bắt đầu ca làm việc.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Id != 0 && string.IsNullOrEmpty(gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "End").ToString()))
{
MessageBox.Show("Vui lòng chọn thời gian kết thúc ca làm việc.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
var obj = new Q_Shift();
obj.Id = Id;
obj.Name = gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "Name").ToString();
obj.Start = DateTime.Parse(gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "Start").ToString());
obj.End = DateTime.Parse(gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "End").ToString());
obj.Note = gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "Note") != null?gridViewShift.GetRowCellValue(gridViewShift.FocusedRowHandle, "Note").ToString() : "";
if (obj.Id == 0)
{
int result = BLLShift.Instance.Insert(connect, obj);
if (result == 0)
{
MessageBox.Show("Tên ca làm việc này đã tồn tại. Xin chọn lại", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
goto End;
}
}
else
{
bool result = BLLShift.Instance.Update(connect, obj);
if (result == false)
{
MessageBox.Show("Tên ca làm việc này đã tồn tại. Xin chọn lại", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
goto End;
}
}
GetGridShift();
}
}
catch (Exception ex)
{
}
End:
{
}
}
private void gridViewAdd_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
gridViewAdd.UpdateCurrentRow();
ShowTotal();
}
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
//表格数据发生变化
RefreshChart();
}
private void gridViewEquipment_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
try
{
int Id = 0;
int n = 0;
int.TryParse(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Id").ToString(), out Id);
bool isNumber = int.TryParse(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Code").ToString(), out n);
if (Id == 0 && string.IsNullOrEmpty(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Name").ToString()))
{
goto End;
}
else if (Id == 0 && string.IsNullOrEmpty(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Code").ToString()))
{
goto End;
}
else if (Id == 0 && (string.IsNullOrEmpty(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "CounterId").ToString()) || gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "CounterId").ToString() == "0"))
{
goto End;
}
else if (Id == 0 && (string.IsNullOrEmpty(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "StatusId").ToString()) || gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "StatusId").ToString() == "0"))
{
goto End;
}
if (Id != 0 && string.IsNullOrEmpty(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Name").ToString()))
{
MessageBox.Show("Vui lòng nhập tên thiết bị.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Id != 0 && string.IsNullOrEmpty(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Code").ToString()))
{
MessageBox.Show("Vui lòng nhập mã thiết bị.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Id != 0 && isNumber == false)
{
MessageBox.Show("Mã thiết bị phải là dạng chữ số. Xin nhập lại", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Id != 0 && n <= 0)
{
MessageBox.Show("Mã thiết bị phải là dạng chữ số lớn hơn 0. Xin nhập lại", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Id != 0 && int.Parse(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "CounterId").ToString()) == 0)
{
MessageBox.Show("Vui lòng chọn quầy.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Id != 0 && int.Parse(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "StatusId").ToString()) == 0)
{
MessageBox.Show("Vui lòng chọn trạng thái.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
var obj = new Q_Equipment();
obj.Id = Id;
obj.Name = gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Name").ToString();
obj.Code = int.Parse(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Code").ToString());
obj.EquipTypeId = equipTypeId;
obj.CounterId = int.Parse(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "CounterId").ToString());
obj.StatusId = int.Parse(gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "StatusId").ToString());
obj.Position = gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Position") != null?gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Position").ToString() : "";
//DateTime? et = (DateTime)gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "EndTime");
//obj.EndTime = et != null ? et : null;
obj.Note = gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Note") != null?gridViewEquipment.GetRowCellValue(gridViewEquipment.FocusedRowHandle, "Note").ToString() : "";
if (obj.Id == 0)
{
int result = BLLEquipment.Instance.Insert(connect, obj);
if (result == 0)
{
MessageBox.Show("Tên thiết bị đã tồn tại. Xin nhập tên khác", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
goto End;
}
}
else
{
bool result = BLLEquipment.Instance.Update(connect, obj);
if (result == false)
{
MessageBox.Show("Tên thiết bị đã tồn tại. Xin nhập tên khác", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
goto End;
}
}
GetGridEquipment();
frmMain.lib_Equipments = BLLEquipment.Instance.Gets(connect, (int)eEquipType.Counter);
}
}
catch (Exception ex)
{
}
End:
{
}
}
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
lblNetCost.Text = String.Format("{0:n2}", TotalSales());
}
private void gridViewService_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
try
{
int Id = 0;
int start = 0;
int end = 0;
bool isNumber1 = int.TryParse(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "StartNumber").ToString(), out start);
bool isNumber2 = int.TryParse(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "EndNumber").ToString(), out end);
int.TryParse(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "Id").ToString(), out Id);
if (Id == 0 && string.IsNullOrEmpty(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "Name").ToString()))
{
goto End;
}
else if (Id == 0 && (string.IsNullOrEmpty(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "StartNumber").ToString()) || isNumber1 == false || start <= 0))
{
goto End;
}
else if (Id == 0 && (string.IsNullOrEmpty(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "EndNumber").ToString()) || isNumber2 == false || end <= 0 || end < start))
{
goto End;
}
else if (Id == 0 && string.IsNullOrEmpty(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "TimeProcess").ToString()))
{
goto End;
}
if (Id != 0 && string.IsNullOrEmpty(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "Name").ToString()))
{
MessageBox.Show("Vui lòng nhập tên dịch vụ.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Id != 0 && string.IsNullOrEmpty(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "StartNumber").ToString()))
{
MessageBox.Show("Vui lòng nhập số phiếu bắt đầu.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Id != 0 && isNumber1 == false)
{
MessageBox.Show("Số phiếu bắt đầu phải là chữ số. Xin nhập lại", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Id != 0 && start <= 0)
{
MessageBox.Show("Số phiếu bắt đầu có giá trị không hợp lệ. Xin nhập lại", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Id != 0 && string.IsNullOrEmpty(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "EndNumber").ToString()))
{
MessageBox.Show("Vui lòng nhập số phiếu kết thúc.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Id != 0 && isNumber2 == false)
{
MessageBox.Show("Số phiếu kết thúc phải là chữ số. Xin nhập lại", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Id != 0 && (end <= 0 || end < start))
{
MessageBox.Show("Số phiếu kết thúc có giá trị không hợp lệ. Xin nhập lại", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Id != 0 && string.IsNullOrEmpty(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "TimeProcess").ToString()))
{
MessageBox.Show("Vui lòng nhập thời gian xử lý.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
var obj = new Q_Service();
obj.Id = Id;
obj.Name = gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "Name").ToString();
obj.StartNumber = int.Parse(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "StartNumber").ToString());
obj.EndNumber = int.Parse(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "EndNumber").ToString());
obj.TimeProcess = DateTime.Parse(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "TimeProcess").ToString());
obj.IsActived = bool.Parse(gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "IsActived").ToString());
obj.Note = gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "Note") != null?gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "Note").ToString() : "";
obj.Code = gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "Code") != null?gridViewService.GetRowCellValue(gridViewService.FocusedRowHandle, "Code").ToString() : "";
if (obj.Id == 0)
{
int result = BLLService.Instance.Insert(connect, obj);
if (result == 0)
{
MessageBox.Show("Tên dịch vụ đã tồn tại. Xin nhập tên khác", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
goto End;
}
}
else
{
bool result = BLLService.Instance.Update(connect, obj);
if (result == false)
{
MessageBox.Show("Tên dịch vụ đã tồn tại. Xin nhập tên khác", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
goto End;
}
}
GetGridService();
}
}
catch (Exception ex)
{
}
End:
{
}
}
private void gridViewModrecordgridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
var modrecordInfo = this.gridViewModrecord.GridView1.GetRow(e.RowHandle) as ModRecordInfo;
string idx = string.Empty;
this.gridViewModrecord.AddColumnAlias("GUID", "GUID");
this.gridViewModrecord.AddColumnAlias("ModDate", "修改日期");
this.gridViewModrecord.AddColumnAlias("ModVersion", "修改版本");
this.gridViewModrecord.AddColumnAlias("ModOrderId", "修改单号");
this.gridViewModrecord.AddColumnAlias("Proposer", "申请人");
this.gridViewModrecord.AddColumnAlias("Programmer", "修改人");
this.gridViewModrecord.AddColumnAlias("ModContent", "修改内容");
this.gridViewModrecord.AddColumnAlias("ModReason", "修改原因");
this.gridViewModrecord.AddColumnAlias("Remark", "备注");
switch (e.Column.ToString())
{
case "GUID":
idx = "guid";
break;
case "修改日期":
idx = "moddate";
break;
case "修改版本":
idx = "modversion";
break;
case "修改单号":
idx = "modorderId";
break;
case "申请人":
idx = "proposer";
break;
case "修改人":
idx = "programmer";
break;
case "修改内容":
idx = "modcontent";
break;
case "修改原因":
idx = "modreason";
break;
case "备注":
idx = "remark";
break;
}
if (string.IsNullOrEmpty(idx))
{
return;
}
XmlNodeList xmlNodeLst = xmldicthelper.Read("datatype/histories");
foreach (XmlElement element in xmlNodeLst)
{
if (string.Equals(element.Attributes["guid"].Value, modrecordInfo.GUID))
{
if (string.Equals(e.Column.ColumnType.Name, "DateTime"))
{
element.Attributes[idx].Value = Convert.ToDateTime(e.Value).ToShortDateString() + " " + DateTimeHelper.GetServerDateTime2().ToLongTimeString();
}
else
{
element.Attributes[idx].Value = e.Value.ToString();
}
}
}
xmldicthelper.Save(false);
}
private void GridlerIcin_EditValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
KaydetMedenCikilmasin(true);
}
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
try
{
if (e.RowHandle == -1)
{
return;
}
if (e.Column.FieldName == "FV")
{
DataRow dr = this.gridView1.GetDataRow(e.RowHandle);
IFieldInfo fi = dr["F"] as IFieldInfo;
if (fi != null)
{
string strobj = e.Value.ToString();
bool bRes = false;
switch (fi.FieldType)
{
case gviFieldType.gviFieldBlob:
case gviFieldType.gviFieldGeometry:
case gviFieldType.gviFieldUnknown:
break;
case gviFieldType.gviFieldFloat:
float f;
bRes = float.TryParse(strobj, out f);
if (bRes)
{
dr["FV"] = strobj;
}
else
{
dr["FV"] = null;
}
break;
case gviFieldType.gviFieldDouble:
double d;
bRes = double.TryParse(strobj, out d);
if (bRes)
{
dr["FV"] = strobj;
}
else
{
dr["FV"] = null;
}
break;
case gviFieldType.gviFieldFID:
case gviFieldType.gviFieldUUID:
case gviFieldType.gviFieldInt16:
Int16 i16;
bRes = Int16.TryParse(strobj, out i16);
if (bRes)
{
dr["FV"] = strobj;
}
else
{
dr["FV"] = null;
}
break;
case gviFieldType.gviFieldInt32:
Int32 i32;
bRes = Int32.TryParse(strobj, out i32);
if (bRes)
{
dr["FV"] = strobj;
}
else
{
dr["FV"] = null;
}
break;
case gviFieldType.gviFieldInt64:
Int64 i64;
bRes = Int64.TryParse(strobj, out i64);
if (bRes)
{
dr["FV"] = strobj;
}
else
{
dr["FV"] = null;
}
break;;
case gviFieldType.gviFieldString:
dr["FV"] = strobj;
break;
case gviFieldType.gviFieldDate:
DateTime dt;
bRes = DateTime.TryParse(strobj, out dt);
if (bRes)
{
dr["FV"] = strobj;
}
else
{
dr["FV"] = null;
}
break;
default:
break;
}
this.gridView1.RefreshRow(e.RowHandle);
}
}
}
catch (Exception ex)
{
}
}
private void gridViewCounter_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
try
{
int Id = 0;
int.TryParse(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Id").ToString(), out Id);
if (Id == 0 && string.IsNullOrEmpty(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Name").ToString()))
{
goto End;
}
else if (Id == 0 && string.IsNullOrEmpty(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "ShortName").ToString()))
{
goto End;
}
else if (Id == 0 && string.IsNullOrEmpty(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Index").ToString()))
{
goto End;
}
if (Id != 0 && string.IsNullOrEmpty(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Name").ToString()))
{
MessageBox.Show("Vui lòng nhập tên quầy.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Id != 0 && string.IsNullOrEmpty(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "ShortName").ToString()))
{
MessageBox.Show("Vui lòng nhập tên rút gọn.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else if (Id != 0 && string.IsNullOrEmpty(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Index").ToString()))
{
MessageBox.Show("Vui lòng nhập số thứ tự.", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
var obj = new Q_Counter();
obj.Id = Id;
obj.ShortName = gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "ShortName").ToString();
obj.Name = gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Name").ToString();
obj.Index = int.Parse(gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Index").ToString());
obj.Position = gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Position") != null?gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Position").ToString() : "";
obj.Acreage = gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Acreage") != null?gridViewCounter.GetRowCellValue(gridViewCounter.FocusedRowHandle, "Acreage").ToString() : "";
int kq = 0;
if (obj.Id == 0)
{
kq = BLLCounter.Instance.Insert(connect, obj);
}
else
{
kq = BLLCounter.Instance.Update(connect, obj);
}
if (kq == 0)
{
MessageBox.Show("Tên quầy đã tồn tại. Xin nhập tên khác", "Lỗi nhập liệu", MessageBoxButtons.OK, MessageBoxIcon.Error);
goto End;
}
else
{
GetGridCounter();
}
}
}
catch (Exception ex)
{
}
End : { }
}
private void grvGioGiang_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
drGioGiang = grvGioGiang.GetDataRow(grvGioGiang.FocusedRowHandle);
TinhGioChuan(drGioGiang);
}
void ViewFieldConfig_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
isNeedSave = true;
}
void gvDetail_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
GridView gv = sender as GridView;
if (e.Column.FieldName.ToUpper().Equals("MAVT"))
{
//khach hang
TextEdit txtKh = data.FrmMain.Controls.Find("MaKH", true)[0] as TextEdit;
//vat tu
string vt = gv.GetFocusedRowCellValue(e.Column).ToString();
//ngayCT
DateEdit dtp = data.FrmMain.Controls.Find("ngayCT", true)[0] as DateEdit;
string sql = "select * from ChinhSachGia CSG INNER JOIN GiaVT VT on VT.CSGID=CSG.CSGID " +
"LEFT JOIN GiaKH KH on KH.CSGID=CSG.CSGID WHERE VT.MaVT='" + vt + "'";
DataTable dt = db.GetDataTable(sql);
DataView dvGiaVT = new DataView(dt);
DataView dvKH;
string nhomkh = "";
sql = "select Nhom1 from dmkh where makh ='" + txtKh.Text + "'";
DataTable dtNhom = db.GetDataTable(sql);
if (dtNhom.Rows.Count > 0)
{
nhomkh = dtNhom.Rows[0]["Nhom1"].ToString();
}
dvGiaVT.RowFilter = "TuNgay is null and DenNgay is null";
//nhóm có, mã có
//nhóm không, mã có
//nhóm có, mã không
//nhóm không , mã không
if (dvGiaVT.Count > 0)
{
dvKH = new DataView(dvGiaVT.ToTable());
dvKH.RowFilter = "MaKH is null and NhomKH is null";
if (dvKH.Count == 0)
{
if (nhomkh != "")
{
dvKH.RowFilter = "MaKH is null and NhomKH = '" + nhomkh + "'";
}
}
if (dvKH.Count == 0)
{
dvKH.RowFilter = "MaKH='" + txtKh.Text + "'";
}
if (dvKH.Count == 0)//kt trường hợp vattu có chính sách giá trong khoảng thời gian hay ko?
{
dvGiaVT.RowFilter = "TuNgay <= '" + dtp.DateTime + "' and DenNgay >= '" + dtp.DateTime + "'";
dvKH = new DataView(dvGiaVT.ToTable());
dvKH.RowFilter = "MaKH is null and NhomKH is null";
if (dvKH.Count == 0)
{
if (nhomkh != "")
{
dvKH.RowFilter = "MaKH is null and NhomKH = '" + nhomkh + "'";
}
}
if (dvKH.Count == 0)
{
dvKH.RowFilter = "MaKH='" + txtKh.Text + "'";
}
}
}
else
{
dvGiaVT.RowFilter = "TuNgay <= '" + dtp.DateTime + "' and DenNgay >= '" + dtp.DateTime + "'";
dvKH = new DataView(dvGiaVT.ToTable());
dvKH.RowFilter = "MaKH is null and NhomKH is null";
if (dvKH.Count == 0)
{
if (nhomkh != "")
{
dvKH.RowFilter = "MaKH is null and NhomKH = '" + nhomkh + "'";
}
}
if (dvKH.Count == 0)
{
dvKH.RowFilter = "MaKH='" + txtKh.Text + "'";
}
}
setPrice(dvKH, gv);
}
}
private void gridView1_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
Kaydet_Vazgec_Sil_Enable(true);
}
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
//this.dgrex_Dm_Loai_Hopdong.EmbeddedNavigator.Buttons.EndEdit.DoClick();
this.DoClickEndEdit(dgrex_Dm_Loai_Hopdong);
}
private void _gdMAIN_VIEW_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
_gdMAIN_VIEW.CellValueChanged -= _gdMAIN_VIEW_CellValueChanged;
ChangeValues(sender, e);
_gdMAIN_VIEW.CellValueChanged += _gdMAIN_VIEW_CellValueChanged;
}
private void gVCambio_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
Caulcular();
}
private void grvDynamic_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
DirtyData = true;
}
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
}
private void gridViewAddVehicle_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (e.Column == colAddVehicleId || e.Column == colAddVehicleWorkerUnitPrice)
{
return;
}
TenderMaterialListEquipmentModel currentItem = new TenderMaterialListEquipmentModel();
int currentId = Convert.ToInt32(gridViewAddVehicle.GetFocusedRowCellValue("Id"));
if (currentId <= 0)
{
//if (e.Value == null)
//{
// return;
//}
currentItem = new TenderMaterialListEquipmentModel();
TenderEquipment equipment = new TenderEquipment();
equipment.IsWorker = false;
equipment.TenderId = UICurrentManager.Instance.CurrentTender.Id;
if (e.Column == colAddVehicleVehicle)
{
//System.Data.DataRow row = gridViewAddVehicle.GetDataRow(gridViewAddVehicle.FocusedRowHandle);
//string cellValue = row[0].ToString();
//object a = gridViewAddVehicle.GetSelectedRow("SelectedVehicle");
object b = gridViewAddVehicle.ActiveEditor.EditValue;
equipment.WorkerVehicleId = (int)b;
}
OperationResult result = TenderEquipmentProvider.Instance.Save(equipment);
if (result.Success)
{
TenderMaterialListEquipment tenderMaterialListEquipment = new TenderMaterialListEquipment();
tenderMaterialListEquipment.EquipmentId = equipment.Id;
tenderMaterialListEquipment.MaterialListId = this.SelectedMaterial.Id.Value;
tenderMaterialListEquipment.TenderId = UICurrentManager.Instance.CurrentTender.Id;
tenderMaterialListEquipment.Equipment = equipment;
OperationResult result1 = TenderMaterialListEquipmentProvider.Instance.Save(tenderMaterialListEquipment);
if (result1.Success)
{
currentItem = new TenderMaterialListEquipmentModel(tenderMaterialListEquipment);
currentItem.Equipment = equipment;
gridViewAddVehicle.SetFocusedRowCellValue(colAddVehicleId, currentItem.Id);
LoadWorkerMateriallistGrid();
return;
}
}
}
else
{
List <TenderMaterialListEquipmentModel> items = ((IEnumerable <TenderMaterialListEquipmentModel>)bindingSourceAddVehicle.DataSource).ToList();
foreach (TenderMaterialListEquipmentModel item in items)
{
if (item.Id == currentId)
{
currentItem = item;
break;
}
}
}
if (e.Column == colAddVehicleQuantity)
{
currentItem.Quantity = SimpleApplicationBase.Toolkit.Helpers.GetValueFromObject <double>(e.Value);
}
else if (e.Column == colAddVehicleUnitTime)
{
currentItem.UnitTime = SimpleApplicationBase.Toolkit.Helpers.GetValueFromObject <int>(e.Value);
}
else if (e.Column == colAddVehicleUnitTimeType)
{
currentItem.UnitTimeType = SimpleApplicationBase.Toolkit.Helpers.GetValueFromObject <UnitTimeTypesEnum>(e.Value);
}
else if (e.Column == colAddVehicleVehicle)
{
currentItem.Equipment.WorkerVehicleId = (int)e.Value;
TenderEquipmentProvider.Instance.Save(currentItem.Equipment);
currentItem.Equipment = null;
}
currentItem.Save();
grdAddVehicle.Refresh();
}
private void gridView2_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
if (e.Column.FieldName == "SOLUONG")
{
}
}
private void gvHoliday_CellValueChanging(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
}
private void GridViewCellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
treeList.Refresh();
}
public void grdGrid_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
#region Barcode
if (e.Column.ToString() == "Barkod")
{
string barcode = e.Value.ToString();
string oldBarcode, state = "";
int miktar = 0;
db.AddParameterValue("@barcode", barcode);
DataTable dtSearch = db.GetDataTable(@"SELECT stStockCard.Ref, stStockCard.code AS [Kart Kodu], stStockCard.name AS [Kart Adı], StStockCardBarcodes.size AS Beden, StStockCardBarcodes.color AS Renk, StStockCardBarcodes.barcode AS Barcode, StStockCardUnits.unitRef as [Birim Ref], StStockCardUnits.unitCode as [Birim Kodu] FROM stStockCard
LEFT JOIN StStockCardBarcodes ON stStockCard.Ref = StStockCardBarcodes.cardRef
LEFT JOIN StStockCardUnits ON stStockCard.Ref = StStockCardUnits.Ref
WHERE (stStockCard.active = 1)
and barcode = @barcode");
if (dtSearch.Rows.Count > 0)
{
if (grdGrid.RowCount - 1 > 0)
{
for (int i = 0; i < grdGrid.RowCount - 1; i++)
{
oldBarcode = grdGrid.GetRowCellValue(i, "Barkod").ToString();
if (barcode == oldBarcode)
{
grdGrid.DeleteRow(grdGrid.FocusedRowHandle);
miktar = int.Parse(grdGrid.GetRowCellValue(i, "Miktar").ToString());
miktar++;
grdGrid.SetRowCellValue(i, "Miktar", miktar);
state = "true";
break;
}
else
{
state = "false";
}
}
if (state == "false")
{
DataRow row = dtBox.NewRow();
row["Kart Ref"] = int.Parse(dtSearch.Rows[0]["Ref"].ToString());
row["Kart Kodu"] = dtSearch.Rows[0]["Kart Kodu"].ToString();
row["Kart Adı"] = dtSearch.Rows[0]["Kart Adı"].ToString();
row["Renk"] = dtSearch.Rows[0]["Renk"].ToString();
row["Beden"] = dtSearch.Rows[0]["Beden"].ToString();
row["Barkod"] = barcode;
row["Birim Kodu"] = "Adet";
row["Miktar"] = 1;
db.AddParameterValue("@barcode", barcode);
db.AddParameterValue("@branchRef", ledBranch.GetValue());
string price = db.GetScalarValue("select dbo.Tools_GetLastActiveBuyPrice(@barcode,@branchRef)").ToString();
row["Birim Fiyat"] = price;
decimal total = decimal.Parse(row["Miktar"].ToString()) * decimal.Parse(price);
row["Toplam Tutar"] = total;
grdGrid.DeleteRow(grdGrid.FocusedRowHandle);
dtBox.Rows.Add(row);
grdGrid.RefreshData();
}
}
else
{
grdGrid.DeleteRow(grdGrid.FocusedRowHandle);
DataRow row = dtBox.NewRow();
row["Kart Ref"] = int.Parse(dtSearch.Rows[0]["Ref"].ToString());
row["Kart Kodu"] = dtSearch.Rows[0]["Kart Kodu"].ToString();
row["Kart Adı"] = dtSearch.Rows[0]["Kart Adı"].ToString();
row["Renk"] = dtSearch.Rows[0]["Renk"].ToString();
row["Beden"] = dtSearch.Rows[0]["Beden"].ToString();
row["Barkod"] = barcode;
row["Birim Kodu"] = "Adet";
row["Miktar"] = 1;
db.AddParameterValue("@barcode", barcode);
db.AddParameterValue("@branchRef", ledBranch.GetValue());
string price = db.GetScalarValue("select dbo.Tools_GetLastActiveBuyPrice(@barcode,@branchRef)").ToString();
row["Birim Fiyat"] = price;
decimal total = decimal.Parse(row["Miktar"].ToString()) * decimal.Parse(price);
row["Toplam Tutar"] = total;
dtBox.Rows.Add(row);
grdGrid.RefreshData();
}
}
else
{
grdGrid.DeleteRow(grdGrid.FocusedRowHandle);
}
}
#endregion
if (e.Column.ToString() == "Miktar" || e.Column.ToString() == "Birim Fiyat")
{
Calculate();
}
}
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
ischange = true;
gridView1.SelectRow(e.RowHandle);
}
private void gridViewLancsBaixa_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
refreshTotal();
}
private void gridStokHareket_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
Toplamlar();
}
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
_haveChange = true;
RaiseDataChanged();
}
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
this.dgware_Dm_Nhom_Hanghoa_Ban.EmbeddedNavigator.Buttons.DoClick(dgware_Dm_Nhom_Hanghoa_Ban.EmbeddedNavigator.Buttons.EndEdit);
}
private void GridViewSampleNotes_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
{
gridViewSampleNotes.PostEditor();
gridViewSampleNotes.UpdateCurrentRow();
}
