void repositoryItemComboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
CboItemEntity item = new CboItemEntity();
try
{
//1.获取下拉框选中值
item = (CboItemEntity)(sender as ComboBoxEdit).SelectedItem;
string text = item.Text.ToString();
string value = item.Value.ToString();
//2.获取gridview选中的行
GridView myView = (gcCljbxx.MainView as GridView);
int dataIndex = myView.GetDataSourceRowIndex(myView.FocusedRowHandle);
var gridViewRow = myView.GetDataRow(myView.FocusedRowHandle);
//3.保存选中值到datatable
//Initdt.Rows[dataIndex]["value"] = value;
Initdt.Rows[dataIndex]["UPDATEFIELD"] = text;
Initdt.Rows[dataIndex]["FIELDNEW"] = QueryServerRLLX(gridViewRow["VIN"].ToString(), value);
Initdt.Rows[dataIndex]["FIELDOLD"] = QueryRLLX(gridViewRow["VIN"].ToString(), value);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void BindComBox(RepositoryItemComboBox ricb, string rllx)
{
CboItemEntity cie = null;
foreach (DataRow r in rllxParam.Select("FUEL_TYPE='" + rllx + "'"))
{
cie = new CboItemEntity();
cie.Text = r["PARAM_NAME"];
cie.Value = r["PARAM_CODE"];
ricb.Items.Add(cie);
}
ricb.SelectedIndexChanged += new EventHandler(repositoryItemComboBox1_SelectedIndexChanged);
ricb.ParseEditValue += new DevExpress.XtraEditors.Controls.ConvertEditValueEventHandler(repositoryItemComboBox1_ParseEditValue);
}
void rICbExamine_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
CboItemEntity item = (CboItemEntity)(sender as ComboBoxEdit).SelectedItem;
string text = item.Text.ToString();
int value = (int)item.Value;
DataRow dr = this.gridView.GetDataRow(this.gridView.FocusedRowHandle);
string UserName = dr[0].ToString();
UserInfoBll.Instance.UpdateWhatWhere(new { status = value.ToString() }, new { username = UserName });
}
catch (Exception ex)
{
XtraMessageBox.Show("修改用户状态失败：" + ex.Message, "错误");
}
BeginInit();
}
//初始化燃料参数
#region 初始化燃料参数（旧的方式）
// private DataTable InitRLLX(string type,string startDate,string endDate)
// {
// string sql = string.Empty;
// DateTime dt = DateTime.Now;
// int pageNum = 1;
// List<FuelDataService.VehicleBasicInfo> listTemp = new List<FuelDataService.VehicleBasicInfo>();
// List<FuelDataService.VehicleBasicInfo> list = new List<FuelDataService.VehicleBasicInfo>();
// while (true)
// {
// FuelDataService.VehicleBasicInfo[] queryInfoArr = null;
// if (type == "1") //补传
// {
// queryInfoArr = service.QueryApplyUpLoadOT(Utils.userId, Utils.password, pageNum, 50, "", "", "", "", startDate, endDate, "MANUFACTURE_TIME"); //MANUFACTURE_TIME 车辆制造日期
// }
// else if (type == "2") //修改
// {
// queryInfoArr = service.QueryApplyUpdateInfo(Utils.userId, Utils.password, pageNum, 50, "", "", "", "", startDate, endDate, "MANUFACTURE_TIME"); //MANUFACTURE_TIME 车辆制造日期
// }
// else //撤销
// {
// queryInfoArr = service.QueryApplyDelInfo(Utils.userId, Utils.password, pageNum, 50, "", "", "", "", startDate, endDate, "MANUFACTURE_TIME"); //MANUFACTURE_TIME 车辆制造日期
// }
// if (queryInfoArr == null || queryInfoArr.Length==0)
// break;
// pageNum++;
// listTemp.AddRange(queryInfoArr);
// }
// if (dt.Day>15) //当前日期大于15号 查询 当月1号以前的数据
// {
// list = listTemp.FindAll(u => u.Clzzrq < dt.AddDays(1 - dt.Day));
// }
// else //查询 上个月1号以前的数据
// {
// list = listTemp.FindAll(u => u.Clzzrq < dt.AddMonths(-1).AddDays(1 - dt.Day));
// }
// string str = string.Empty;
// foreach (var item in list)
// {
// str += "'" + item.App_Vin + "',";
// }
// str = str.TrimEnd(',');
// if (!string.IsNullOrEmpty(str))
// {
// sql = @"select * from
// (
// select VIN,CLXH,TYMC,RLLX,CT_ZHGKRLXHL,ZCZBZL,CT_BSQXS,ZWPS
//FROM FC_CLJBXX LEFT JOIN VIEW_RLLX_PARAM_ENTTITY ON FC_CLJBXX.VIN = VIEW_RLLX_PARAM_ENTTITY.VIN
//WHERE (((FC_CLJBXX.RLLX)='汽油' Or (FC_CLJBXX.RLLX)='柴油' Or (FC_CLJBXX.RLLX)='两用燃料' Or (FC_CLJBXX.RLLX)='双燃料'))
//
// union
// select VIN,CLXH,TYMC,RLLX,'',ZCZBZL,'',ZWPS FROM FC_CLJBXX LEFT JOIN VIEW_RLLX_PARAM_ENTTITY_CDD ON FC_CLJBXX.VIN=VIEW_RLLX_PARAM_ENTTITY_CDD.VIN
//WHERE FC_CLJBXX.RLLX='纯电动'
// union
// select VIN,CLXH,TYMC,RLLX,FCDS_HHDL_ZHGKRLXHL,ZCZBZL,FCDS_HHDL_BSQXS,ZWPS FROM FC_CLJBXX LEFT JOIN VIEW_RLLX_PARAM_ENTTITY_FCDS ON FC_CLJBXX.VIN=VIEW_RLLX_PARAM_ENTTITY_FCDS.VIN
//WHERE FC_CLJBXX.RLLX='非插电式混合动力'
// union
// select VIN,CLXH,TYMC,RLLX,CDS_HHDL_ZHGKRLXHL,ZCZBZL,CDS_HHDL_BSQXS,ZWPS FROM FC_CLJBXX LEFT JOIN VIEW_RLLX_PARAM_ENTTITY_CDS ON FC_CLJBXX.VIN=VIEW_RLLX_PARAM_ENTTITY_CDS.VIN
//WHERE FC_CLJBXX.RLLX='插电式混合动力'
// union
// select VIN,CLXH,TYMC,RLLX,'',ZCZBZL,'',ZWPS from FC_CLJBXX LEFT JOIN VIEW_RLLX_PARAM_ENTTITY_RLDC ON FC_CLJBXX.VIN=VIEW_RLLX_PARAM_ENTTITY_RLDC.VIN
//WHERE FC_CLJBXX.RLLX='燃料电池'
//
// ) where VIN in (" + str + ")";
// DataSet ds = AccessHelper.ExecuteDataSet(AccessHelper.conn, sql, null);
// if (ds != null && ds.Tables[0].Rows.Count > 0)
// {
// return ds.Tables[0];
// }
// }
// return null;
// }
#endregion
//绑定combobox
private void BindComboBoxDataSource()
{
string sql = "select * from RLLX_PARAM ";//where FUEL_TYPE='"+rllx+"'";
DataSet ds = AccessHelper.ExecuteDataSet(AccessHelper.conn, sql, null);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
CboItemEntity cie = null;
foreach (DataRow r in ds.Tables[0].Rows)
{
cie = new CboItemEntity();
cie.Text = r["PARAM_NAME"];
cie.Value = r["PARAM_CODE"];
this.repositoryItemComboBox1.Items.Add(cie);
}
}
repositoryItemComboBox1.SelectedIndexChanged += new EventHandler(repositoryItemComboBox1_SelectedIndexChanged);
repositoryItemComboBox1.ParseEditValue += new DevExpress.XtraEditors.Controls.ConvertEditValueEventHandler(repositoryItemComboBox1_ParseEditValue);
}
