private void gridView1_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
try
{
string Id = gridView1.GetFocusedDataRow()[0].ToString();
SelectItemRow = Convert.ToInt32(Id);
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
catch (Exception exp)
{
MessageBox.Show(exp.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void gridView1_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
//if(e.Column == gcRead && e.Button == MouseButtons.Left)
// RaiseReadMessagesChanged(e.RowHandle);
if (e.Column.FieldName == "Priority" && e.Button == MouseButtons.Left)
{
PriorityMenu.ShowPopup(gridControlStock.PointToScreen(e.Location));
}
if (e.Button == MouseButtons.Right)
{
ShowMessageMenu(gridControlStock.PointToScreen(e.Location));
}
if (e.Button == MouseButtons.Left && e.Clicks == 2)
{
EditStock(e.RowHandle);
}
}
private void gridViewXuong_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
txtMaXuong.Text = gridViewXuong.GetRowCellValue(e.RowHandle, "FactoryCode").ToString();
txtTenXuong.Text = gridViewXuong.GetRowCellValue(e.RowHandle, "FactoryName").ToString();
txtGhiChu.Text = gridViewXuong.GetRowCellValue(e.RowHandle, "Note").ToString();
if (gridViewXuong.GetRowCellValue(e.RowHandle, "Status").ToString() == "Kích hoạt")
{
rbtnKichHoat.Checked = true;
}
else
{
rbtnKhoa.Checked = true;
}
txtMaXuong.Enabled = false;
btnSua.Enabled = true;
btnThem.Enabled = false;
}
private void gridView1_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
try
{
string Id = gridView1.GetFocusedDataRow()[6].ToString();
date = gridView1.GetFocusedDataRow()[1].ToString();
string OwnerID = gridView1.GetFocusedDataRow()[7].ToString();
string HeadID = gridView1.GetFocusedDataRow()[0].ToString();
Grid1Id = Convert.ToInt32(Id);
Grid3Id = Convert.ToInt32(HeadID);
OwnerId_v2 = Convert.ToInt32(OwnerID);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void gridViewKho_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
txtMaKho.Text = gridViewKho.GetRowCellValue(e.RowHandle, "StorageCode").ToString();
txtTenKho.Text = gridViewKho.GetRowCellValue(e.RowHandle, "StorageName").ToString();
cbLoaiKho.SelectedItem = gridViewKho.GetRowCellValue(e.RowHandle, "Type").ToString();
txtGhiChu.Text = gridViewKho.GetRowCellValue(e.RowHandle, "Note").ToString();
if (gridViewKho.GetRowCellValue(e.RowHandle, "Status").ToString() == "Kích hoạt")
{
rbtnKichHoat.Checked = true;
}
else
{
rbtnKhoa.Checked = true;
}
txtMaKho.Enabled = false;
btnSua.Enabled = true;
btnThem.Enabled = false;
}
private void gridView_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
try
{
ResetForm();
chuyenId = 0;
if (gridView.GetRowCellValue(gridView.FocusedRowHandle, "MaChuyen") != null)
{
int.TryParse(gridView.GetRowCellValue(gridView.FocusedRowHandle, "MaChuyen").ToString(), out chuyenId);
}
if (gridView.GetRowCellValue(gridView.FocusedRowHandle, "Code") != null)
{
txtCode.Text = gridView.GetRowCellValue(gridView.FocusedRowHandle, "Code").ToString();
}
if (gridView.GetRowCellValue(gridView.FocusedRowHandle, "TenChuyen") != null)
{
txtName.Text = gridView.GetRowCellValue(gridView.FocusedRowHandle, "TenChuyen").ToString();
}
if (gridView.GetRowCellValue(gridView.FocusedRowHandle, "DinhNghia") != null)
{
txtDescription.Text = gridView.GetRowCellValue(gridView.FocusedRowHandle, "DinhNghia").ToString();
}
if (gridView.GetRowCellValue(gridView.FocusedRowHandle, "Sound") != null)
{
txtSound.Text = gridView.GetRowCellValue(gridView.FocusedRowHandle, "Sound").ToString();
}
if (gridView.GetRowCellValue(gridView.FocusedRowHandle, "FloorName") != null)
{
cbbFloor.Text = gridView.GetRowCellValue(gridView.FocusedRowHandle, "FloorName").ToString();
}
if (gridView.GetRowCellValue(gridView.FocusedRowHandle, "LaoDongDinhBien") != null)
{
txtLabor.Value = (int)gridView.GetRowCellValue(gridView.FocusedRowHandle, "LaoDongDinhBien");
}
btnAdd.Enabled = false;
btnUpdate.Enabled = true;
btnDelete.Enabled = true;
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: " + ex.Message);
}
}
/// 删除本列数据
private void gvTradeOrder_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
GridView gv = (sender as GridView).GridControl.GetViewAt(e.Location) as GridView;
if (gv != null)
{
GridHitInfo hi = gv.CalcHitInfo(e.Location);
if (hi.Column != null && hi.InRowCell)
{
DataRow currentMatch = gv.GetDataRow(hi.RowHandle); //记录当前焦点所在的OrderRow
if (hi.Column.ColumnHandle == 0) //如果选中行为修改订单
{
switch (XtraMessageBox.Show("是否确认删除本行订单！", "确认？", MessageBoxButtons.OKCancel))
{
case DialogResult.OK:
#region 去除源Table中的本行记录&&Grid中的本行记录
foreach (DataRow row in _dTbRecord.Rows)
{
if (row["OuterID"].ToString() == currentMatch["OuterID"].ToString() &&
row["SkuProps_Str"].ToString() == currentMatch["SkuProps_Str"].ToString())
{
_dTbRecord.Rows.Remove(row);
//重新计算当前的折扣金额
txtDiscountFee.Text = (GetOrdersTotalFee() * (1.0 - Double.Parse(txtDiscountRate.Text))).ToString();
//重新计算当前的折扣后金额
txtDicountOutFee.Text = (GetOrdersTotalFee() * Double.Parse(txtDiscountRate.Text)).ToString();
break;
}
}
gvTradeOrder.DeleteRow(hi.RowHandle);
#endregion
break;
case DialogResult.Cancel:
return;
}
}
}
}
}
private void gridView1_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
try
{
row1 = gridView1.GetDataRow(gridView1.GetRowHandle(e.RowHandle));
txtCode.Text = row1["الكود"].ToString();
txtQuantity.Text = "";
comBranch.SelectedIndex = -1;
txtBillNum.Text = "";
txtQuantity.ReadOnly = false;
CustomerBillID = 0;
#region MyRegion
/*string store = "";
* if (comFromStore.Text != "")
* {
* store = comFromStore.SelectedValue.ToString();
* }
* else
* {
* store = "select Store_ID from Store";
* }
* string query = "select Store_Place,Storage_ID from Storage where Code='" + txtCode.Text + "' and Store_ID in (" + store + ") order by Storage_Date asc";
* MySqlDataAdapter da = new MySqlDataAdapter(query, dbconnection);
* DataTable dt = new DataTable();
* da.Fill(dt);
* cmbPlace.DataSource = dt;
* cmbPlace.DisplayMember = dt.Columns["Store_Place"].ToString();
* cmbPlace.ValueMember = dt.Columns["Storage_ID"].ToString();
* cmbPlace.Text = row1[12].Value.ToString();
* txtQuantity.BackColor = System.Drawing.Color.White;*/
#endregion
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void gridViewFuzzyTriple_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
if (e.Button == MouseButtons.Right)
{
try
{
if (e.Column.FieldName == "gridColValue" && e.Column.OptionsColumn.ReadOnly == true)
{
FrmListValueFuzzy frm = new FrmListValueFuzzy(datatypename);
frm.ShowDialog();
if (frm.valuename != string.Empty)
{
gridViewFuzzyTriple.SetRowCellValue(e.RowHandle, "gridColValue", frm.valuename);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void gridViewLicenses_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
var mod = gridViewLicenses.GetRow(e.RowHandle) as DriverLicenseModel;
if (mod == null)
{
return;
}
if (e.Clicks == 2 || e.Column.Name == col_Edit.Name)
{
HandleEdit(mod, e);
}
else if (e.Column.Name == col_Renew.Name)
{
HandleRenew(mod, e);
}
else if (e.Column.Name == col_Delete.Name)
{
HandleDelete(mod, e);
}
}
private void gridViewScoreBoard_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
try
{
if (e.Column.FieldName != "User_Name" && e.Column.FieldName != "Branch_Name" && e.Column.FieldName != "Branch_Name" && e.Column.FieldName != "DRN_Emp_Code" &&
e.Column.FieldName != "Emp_Job_Role" && e.Column.FieldName != "Shift_Type_Name" && e.Column.FieldName != "Reporting_To_1" &&
e.Column.FieldName != "Reporting_To_2" && e.Column.FieldName != "Avg_Eff" && e.Column.FieldName != "Operation_Type")
{
if (String.IsNullOrEmpty(gridViewScoreBoard.GetRowCellValue(e.RowHandle, gridViewScoreBoard.Columns.ColumnByFieldName(e.Column.FieldName)).ToString()))
{
return;
}
string avgEfficiency = gridViewScoreBoard.GetRowCellValue(e.RowHandle, gridViewScoreBoard.Columns.ColumnByFieldName(e.Column.FieldName)).ToString();
int userId = Convert.ToInt32(gridViewScoreBoard.GetRowCellValue(e.RowHandle, "User_Id"));
string date;
if (lookUpEditYear.EditValue != null)
{
date = DateTime.ParseExact(e.Column.FieldName + "/" + lookUpEditYear.EditValue.ToString(), "dd/MM/yyyy", null).ToString("MM/dd/yyyy");
}
else
{
XtraMessageBox.Show("year not selected");
return;
}
var ht = new Hashtable();
ht.Add("@Trans", "INSERT_INTO_TEMP_USER");
ht.Add("@Production_Date", date);
ht.Add("@User_Id", userId);
var dt = dataaccess.ExecuteSP("Sp_Employee_Production_Score_Board", ht);
Ordermanagement_01.Dashboard.Emp_Production_Score_Board TargeDashboard = new Ordermanagement_01.Dashboard.Emp_Production_Score_Board(userId, userRoleId.ToString(), date.ToString(), avgEfficiency);
TargeDashboard.Show();
}
}
catch (Exception ex)
{
XtraMessageBox.Show("Something went wrong");
}
}
private void bandedGridView2_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
FieldID = Convert.ToInt32(tableGrid.Rows[e.RowHandle]["FieldID"].ToString()); // Get the field id on the selected row
// MessageBox.Show(FieldID.ToString());
}
private void gvCurrency_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
}
private void gridViewTaxOrders_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
if (e.Column.FieldName == "Client_Order_Number")
{
if (Operation == "My_Orders")
{
string Order_Id = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Order_ID").ToString();
string Order_Task_Id = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Order_Task").ToString();
string Tax_TAsk_Id = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Tax_Task_Id").ToString();
string Tax_Status = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Tax_Status_Id").ToString();
string Order_Number = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Client_Order_Number").ToString();
string Check_Tax_Status = "";
if (Order_Process == "Internal_Tax_Request")
{
Hashtable htcheck_Order_Status = new Hashtable();
DataTable dtcheck_Order_Status = new DataTable();
htcheck_Order_Status.Add("@Trans", "GET_INTERNAL_TAX_ORDER_STATUS");
htcheck_Order_Status.Add("@Order_Id", Order_Id);
dtcheck_Order_Status = dataaccess.ExecuteSP("Sp_Tax_Orders", htcheck_Order_Status);
string Order_Status = dtcheck_Order_Status.Rows[0]["Order_Progress"].ToString();
if (dtcheck_Order_Status.Rows.Count > 0)
{
Check_Tax_Status = dtcheck_Order_Status.Rows[0]["Search_Tax_Request"].ToString();
}
else
{
Check_Tax_Status = "False";
}
if (Order_Status != "4")
{
if (Check_Tax_Status == "True")
{
// Inserting Order Timings for the user
Hashtable ht_InserT_Time = new Hashtable();
DataTable dt_Insert_Time = new DataTable();
ht_InserT_Time.Add("@Trans", "INSERT");
ht_InserT_Time.Add("@Order_Id", Order_Id);
ht_InserT_Time.Add("@Tax_Task", Tax_TAsk_Id);
ht_InserT_Time.Add("@Tax_Status", Tax_Status);
ht_InserT_Time.Add("@User_Id", User_Id);
ht_InserT_Time.Add("@Status", "True");
var Time_Id = dataaccess.ExecuteSPForScalar("Sp_Tax_Order_User_Timings", ht_InserT_Time);
int Order_Time_Id = int.Parse(Time_Id.ToString());
Tax_Order_Processing txpr = new Tax_Order_Processing(Order_Id, Order_Task_Id, Tax_TAsk_Id, Tax_Status, User_Id, Order_Number, User_Role, Order_Time_Id);
txpr.Show();
this.Close();
}
else
{
MessageBox.Show("This Order has been cancelled from the internal Search Team");
}
}
else
{
MessageBox.Show("This Order has been cancelled from the internal Search Team");
}
}
else
{
// Inserting Order Timings for the user
Hashtable ht_InserT_Time = new Hashtable();
DataTable dt_Insert_Time = new DataTable();
ht_InserT_Time.Add("@Trans", "INSERT");
ht_InserT_Time.Add("@Order_Id", Order_Id);
ht_InserT_Time.Add("@Tax_Task", Tax_TAsk_Id);
ht_InserT_Time.Add("@Tax_Status", Tax_Status);
ht_InserT_Time.Add("@User_Id", User_Id);
ht_InserT_Time.Add("@Status", "True");
var Time_Id = dataaccess.ExecuteSPForScalar("Sp_Tax_Order_User_Timings", ht_InserT_Time);
int Order_Time_Id = int.Parse(Time_Id.ToString());
Tax_Order_Processing txpr = new Tax_Order_Processing(Order_Id, Order_Task_Id, Tax_TAsk_Id, Tax_Status, User_Id, Order_Number, User_Role, Order_Time_Id);
txpr.Show();
this.Close();
}
}
else
{
string Order_Id = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Order_ID").ToString();
string Order_Task_Id = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Order_Task").ToString();
string Tax_TAsk_Id = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Tax_Task_Id").ToString();
string Tax_Status = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Tax_Status_Id").ToString();
string Order_Number = gridViewTaxOrders.GetRowCellValue(e.RowHandle, "Client_Order_Number").ToString();
Tax_Order_View txview = new Tax_Order_View(Order_Id, User_Id, Order_Number, User_Role);
txview.Show();
}
}
}
private void gridView7_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
//setProfile(e.RowHandle);
setGiaoDich(e.RowHandle);
}
private void gridView3_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
setTaiKhoan(e.RowHandle);
}
private void gridViewEmpleado_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
}
private void gridView4_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
// if(gridView4.Rows[e.RowIndex].cells)
}
private void advBandedGridView1_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
//simpleButton1_Click_1( sender, e);
}
private void FlatView_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
CCId = Convert.ToInt32(FlatView.GetFocusedRowCellValue("CostCentreId"));
FlatId = Convert.ToInt32(FlatView.GetFocusedRowCellValue("FlatId"));
m_sFlatNo = FlatView.GetFocusedRowCellValue("FlatNo").ToString();
m_iLandRegId = Convert.ToInt32(CommFun.IsNullCheck(FlatView.GetFocusedRowCellValue("LandRegisterId"), CommFun.datatypes.vartypenumeric));
if (m_iLandRegId != 0)
{
dtPaySchedule = PaymentScheduleBL.GetPaymentSchedulePlot(m_iLandRegId, FlatId);
}
else
{
dtPaySchedule = PaymentScheduleBL.GetPaymentScheduleFlat(CCId, FlatId);
}
grdPayment.DataSource = dtPaySchedule;
if (dtPaySchedule.Rows.Count > 0)
{
decimal dAmt = 0;
for (int i = 0; i < dtPaySchedule.Rows.Count; i++)
{
dAmt = dAmt + Convert.ToDecimal(dtPaySchedule.Rows[i]["NetAmount"]);
dtPaySchedule.Rows[i]["CumulativeAmount"] = dAmt;
}
}
PaymentView.Columns["PaymentSchId"].Visible = false;
//PaymentView.Columns["CostCentreId"].Visible = false;
//PaymentView.Columns["FlatId"].Visible = false;
//PaymentView.Columns["OtherCostId"].Visible = false;
PanelProgress.Controls.Clear();
frmFlatTrans frmT = new frmFlatTrans();
frmT.Dock = DockStyle.Fill;
frmT.TopLevel = false;
frmT.FormBorderStyle = FormBorderStyle.None;
PanelProgress.Controls.Add(frmT);
frmT.Execute(FlatId);
int LandId = Convert.ToInt32(CommFun.IsNullCheck(FlatView.GetFocusedRowCellValue("LandRegisterId"), CommFun.datatypes.vartypenumeric));
frmProgressChart frmP = new frmProgressChart();
PanelProgress.Controls.Clear();
frmP.Dock = DockStyle.Fill;
frmP.TopLevel = false;
frmP.FormBorderStyle = FormBorderStyle.None;
PanelProgress.Controls.Add(frmP);
frmP.m_iLandId = LandId;
if (cboCheckList.EditValue.ToString() == "Handing Over")
{
frmP.Execute(FlatId, false, "H");
}
else if (cboCheckList.EditValue.ToString() == "Works")
{
frmP.Execute(FlatId, false, "W");
}
else if (cboCheckList.EditValue.ToString() == "Finalization")
{
frmP.Execute(FlatId, false, "F");
}
else if (cboCheckList.EditValue.ToString() == "Cancellation")
{
frmP.Execute(FlatId, false, "C");
}
PopulatePayInfo();
PopulateBuyerInfo();
PopulateCustomerFeedback();
}
private void LinesView_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)
{
Column = e.Column;
RowHandle = e.RowHandle;
}
