/// <summary> /// 获取科长系长组长 确认下拉 /// </summary> public void GetGridInitComBobox() { string str1 = string.Format(@"SELECT ID,pName FROM Attend_Confirm"); m_tblAttendConfirm = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str1); for (int i = 0; i < m_tblAttendConfirm.Rows.Count; i++) { CboItemEntity item4 = new CboItemEntity(); item4.Value = m_tblAttendConfirm.Rows[i]["ID"].ToString(); item4.Text = m_tblAttendConfirm.Rows[i]["pName"].ToString(); repositoryItemComboBox4.Items.Add(item4); CboItemEntity item5 = new CboItemEntity(); item5.Value = m_tblAttendConfirm.Rows[i]["ID"].ToString(); item5.Text = m_tblAttendConfirm.Rows[i]["pName"].ToString(); repositoryItemComboBox5.Items.Add(item5); CboItemEntity item6 = new CboItemEntity(); item6.Value = m_tblAttendConfirm.Rows[i]["ID"].ToString(); item6.Text = m_tblAttendConfirm.Rows[i]["pName"].ToString(); repositoryItemComboBox6.Items.Add(item6); } }
/// <summary> /// 表格改变事件 /// </summary> private void gridView2_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { return; gridView2.CloseEditor(); gridView2.UpdateCurrentRow(); if (gridView2.FocusedRowHandle < 0) return; DataView view ; DataTable dt_temp = new DataTable(); string str_where = string.Empty; switch (e.Column.FieldName) { case "JobForID": str_where = " where 1=1 "; string strJobFor = gridView2.GetFocusedRowCellValue(e.Column.FieldName).ToString(); view = new DataView(m_tblJobForID.Copy()); view.RowFilter = "JobForName='" + strJobFor + "'"; dt_temp=view.ToTable(); if (dt_temp.Rows.Count == 1) { str_where += " and JobForID='" + dt_temp.Rows[0]["JobForID"].ToString() + "'"; } //工程别 string str_sql = string.Format(@"select DISTINCT ProjectID,ProjectName FROM v_Produce_Para_i " + str_where + " order by ProjectName"); m_tblProjectID = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str_sql); for (int i = 0; i < m_tblProjectID.Rows.Count; i++) { CboItemEntity item = new CboItemEntity(); item.Value = m_tblProjectID.Rows[i]["ProjectID"].ToString(); item.Text = m_tblProjectID.Rows[i]["ProjectName"].ToString(); repositoryItemComboBox5.Items.Add(item); } break; case "ProjectID": string strProject = gridView2.GetFocusedRowCellValue(e.Column.FieldName).ToString(); view = new DataView(m_tblProjectID.Copy()); view.RowFilter = "ProjectName='" + strProject + "'"; dt_temp=view.ToTable(); if (dt_temp.Rows.Count == 1) { str_where = " where ProjectID='" + dt_temp.Rows[0]["ProjectID"].ToString() + "'"; } str_sql = string.Format(@"select DISTINCT LineID,LineName FROM v_Produce_Para_i " + str_where + " order by LineName"); m_tblLineID= SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str_sql); //Line别 for (int i = 0; i < m_tblLineID.Rows.Count; i++) { CboItemEntity item = new CboItemEntity(); item.Value = m_tblLineID.Rows[i]["LineID"].ToString(); item.Text = m_tblLineID.Rows[i]["LineName"].ToString(); repositoryItemComboBox6.Items.Add(item); } break; case"": break; } }
/// <summary> /// 获取表格信息一览 /// </summary> protected override void GetDspDataList() { //获取向别下拉 string str_sql = string.Format(@"Select id as JobForID,pName as JoBForName From P_Produce_JobFor Order by id"); m_tblJobForID = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str_sql); for (int i = 0; i < m_tblJobForID.Rows.Count; i++) { CboItemEntity item = new CboItemEntity(); item.Value = m_tblJobForID.Rows[i]["JobForID"].ToString(); item.Text = m_tblJobForID.Rows[i]["JoBForName"].ToString(); repositoryItemComboBox4.Items.Add(item); } if (Common._myTeamName != "") { repositoryItemComboBox4.NullText = Common._myTeamName; } //工程别 str_sql = string.Format(@"select DISTINCT ProjectID,ProjectName FROM v_Produce_Para_i order by ProjectName"); m_tblProjectID = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str_sql); for (int i = 0; i < m_tblProjectID.Rows.Count; i++) { CboItemEntity item = new CboItemEntity(); item.Value = m_tblProjectID.Rows[i]["ProjectID"].ToString(); item.Text = m_tblProjectID.Rows[i]["ProjectName"].ToString(); repositoryItemComboBox5.Items.Add(item); } str_sql = string.Format(@"select DISTINCT LineID,LineName FROM v_Produce_Para_i order by LineName"); m_tblLineID = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str_sql); //Line别 for (int i = 0; i < m_tblLineID.Rows.Count; i++) { CboItemEntity item = new CboItemEntity(); item.Value = m_tblLineID.Rows[i]["LineID"].ToString(); item.Text = m_tblLineID.Rows[i]["LineName"].ToString(); repositoryItemComboBox6.Items.Add(item); } str_sql = string.Format(@"select Distinct T.GuanweiName from ( (select p.*,g.pName as GuanweiName from Produce_Guanwei p inner join P_Produce_Guanwei g on p.GuanweiID=g.ID) )T Order by GuanweiName"); m_tblGuanwei = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str_sql); //关位 for (int i = 0; i < m_tblGuanwei.Rows.Count; i++) { CboItemEntity item = new CboItemEntity(); item.Value = i; item.Text = m_tblGuanwei.Rows[i]["GuanweiName"].ToString(); repositoryItemComboBox7.Items.Add(item); } str_sql = string.Format(@"select * from P_License_S"); DataTable dt_temp = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str_sql); //等级 for (int i = 0; i < dt_temp.Rows.Count; i++) { CboItemEntity item = new CboItemEntity(); item.Value = dt_temp.Rows[i]["ID"].ToString(); item.Text = dt_temp.Rows[i]["pName"].ToString(); repositoryItemComboBox8.Items.Add(item); } }
/// <summary> /// 获取表格信息一览下拉框初始数据 /// </summary> protected override void GetDspDataList() { try { //获取向别下拉 string str_sql = string.Format(@"Select id as JobForID,pName as JoBForName From P_Produce_JobFor Order by id"); m_tblJobForID = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str_sql); repositoryItemComboBox1.Items.Clear(); CboItemEntity item; for (int i = 0; i < m_tblJobForID.Rows.Count; i++) { item = new CboItemEntity(); item.Value = m_tblJobForID.Rows[i]["JobForID"].ToString(); item.Text = m_tblJobForID.Rows[i]["JobForName"].ToString(); repositoryItemComboBox1.Items.Add(item); } //工程别 str_sql = string.Format(@"select DISTINCT ProjectID,ProjectName FROM v_Produce_Para order by ProjectName"); m_tblProjectID = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str_sql); for (int i = 0; i < m_tblProjectID.Rows.Count; i++) { item = new CboItemEntity(); item.Value = m_tblProjectID.Rows[i]["ProjectID"].ToString(); item.Text = m_tblProjectID.Rows[i]["ProjectName"].ToString(); repositoryItemComboBox2.Items.Add(item); } //Line别 str_sql = string.Format(@"select DISTINCT LineID,LineName FROM V_Produce_Para order by LineName"); m_tblLineID = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str_sql); for (int i = 0; i < m_tblLineID.Rows.Count; i++) { item = new CboItemEntity(); item.Value = m_tblLineID.Rows[i]["LineID"].ToString(); item.Text = m_tblLineID.Rows[i]["LineName"].ToString(); repositoryItemComboBox3.Items.Add(item); } //关位 str_sql = string.Format(@"select DISTINCT GuanweiID,GuanweiName FROM V_Produce_Para order by GuanweiName"); m_tblGuanweiID = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str_sql); for (int i = 0; i < m_tblGuanweiID.Rows.Count; i++) { item = new CboItemEntity(); item.Value = m_tblGuanweiID.Rows[i]["GuanweiID"].ToString(); item.Text = m_tblGuanweiID.Rows[i]["GuanweiName"].ToString(); repositoryItemComboBox4.Items.Add(item); } //等级 str_sql = string.Format(@"select * from P_License_S"); m_tblSID = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str_sql); for (int i = 0; i < m_tblSID.Rows.Count; i++) { item = new CboItemEntity(); item.Value = m_tblSID.Rows[i]["ID"].ToString(); item.Text = m_tblSID.Rows[i]["pName"].ToString(); repositoryItemComboBox5.Items.Add(item); } txtGuanwei.Focus(); } catch (Exception ex) { log.Error(ex); XtraMsgBox.Show("下拉框初始化失败!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error, ex, this.GetType()); } }
public void GetGridInitComBobox() { //类型 string str1 = string.Format(@"select * from P_Produce_TeamKind "); m_Type = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str1); for (int i = 0; i < m_Type.Rows.Count; i++) { CboItemEntity item = new CboItemEntity(); item.Value = m_Type.Rows[i]["ID"].ToString(); item.Text = m_Type.Rows[i]["pName"].ToString(); repositoryItemComboBox2.Items.Add(item); } }
/// <summary> /// 获取下拉框数据 /// </summary> public void GetComboBox() { DataTable dt_temp = new DataTable(); CboItemEntity item = new CboItemEntity(); //获取向别下拉 string str_sql = string.Format(@"Select distinct myteamName from V_Produce_Para order by myteamName"); m_tblJobForID = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str_sql); for (int i = 0; i < m_tblJobForID.Rows.Count; i++) { item = new CboItemEntity(); item.Value = m_tblJobForID.Rows[i]["myteamName"].ToString(); item.Text = m_tblJobForID.Rows[i]["myteamName"].ToString(); repositoryItemComboBox2.Items.Add(item); } //考勤单位 item = new CboItemEntity(); item.Value = "是"; item.Text = "是"; repositoryItemComboBox7.Items.Add(item); item = new CboItemEntity(); item.Value = "否"; item.Text = "否"; repositoryItemComboBox7.Items.Add(item); }
private void gridView1_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { if (gridView1.FocusedRowHandle < 0) { return; } string strmyteamName = m_tblDataList.Rows[gridView1.FocusedRowHandle]["myTeamName"].ToString(); string str_sql = string.Format(@"Select GuanweiID, GuanweiName,SetNum From V_Produce_Para where myTeamName='{0}' Order by GuanweiID", strmyteamName); m_tblGuanwei = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str_sql); repositoryItemComboBox3.Items.Clear(); //关位 for (int i = 0; i < m_tblGuanwei.Rows.Count; i++) { CboItemEntity item = new CboItemEntity(); //item.Value = i; item.Value = m_tblGuanwei.Rows[i]["GuanweiID"].ToString(); item.Text = m_tblGuanwei.Rows[i]["GuanweiName"].ToString(); repositoryItemComboBox3.Items.Add(item); } //位置 string GuanweiName = m_tblDataList.Rows[gridView1.FocusedRowHandle]["GuanweiName"].ToString(); DataView view = new DataView(m_tblGuanwei.Copy()); view.RowFilter = "GuanweiName='" + GuanweiName + "'"; DataTable dt = view.ToTable(); if (dt.Rows.Count > 0) { //位置 int guanweiSite = int.Parse(dt.Rows[0]["SetNum"].ToString()); CboItemEntity item = new CboItemEntity(); repositoryItemComboBox6.Items.Clear(); for (int i = 0; i < guanweiSite; i++) { item = new CboItemEntity(); item.Value = i + 1; item.Text = i + 1; repositoryItemComboBox6.Items.Add(item); } item = new CboItemEntity(); item.Value = "99"; item.Text = "99"; repositoryItemComboBox6.Items.Add(item); gridView1.BestFitColumns(); } }
/// <summary> /// 选择关位信息 /// </summary> void repositoryItemComboBox3_EditValueChanged(object sender, EventArgs e) { try { gridView1.CloseEditor(); gridView1.UpdateCurrentRow(); m_tblDataList = ((DataView)this.gridView1.DataSource).ToTable(); DataRow row = gridView1.GetFocusedDataRow(); DataView view = new DataView(m_tblGuanwei.Copy()); view.RowFilter = "GuanweiName='" + row["GuanweiName"].ToString() + "'"; DataTable dt = view.ToTable(); if (dt.Rows.Count > 0) { m_tblDataList.Rows[gridView1.FocusedRowHandle]["GuanWeiID"] = dt.Rows[0]["GuanWeiID"].ToString(); //位置 int guanweiSite = int.Parse(dt.Rows[0]["SetNum"].ToString()); CboItemEntity item = new CboItemEntity(); repositoryItemComboBox6.Items.Clear(); for (int i = 0; i < guanweiSite; i++) { item = new CboItemEntity(); item.Value = i + 1; item.Text = i + 1; repositoryItemComboBox6.Items.Add(item); } item = new CboItemEntity(); item.Value = "99"; item.Text = "99"; repositoryItemComboBox6.Items.Add(item); gridView1.BestFitColumns(); } if (gridView1.GetFocusedDataRow()["ID"].ToString() != ""){ if(gridView1.GetFocusedDataRow()["GuanWeiNameBak"].ToString() != gridView1.GetFocusedDataRow()["GuanWeiName"].ToString() ||gridView1.GetFocusedDataRow()["GuanweiSiteBak"].ToString() != gridView1.GetFocusedDataRow()["GuanweiSite" ].ToString()) { m_tblDataList.Rows[gridView1.FocusedRowHandle]["pmark"] = "调整关位"; gridControl1.DataSource = m_tblDataList; } else { m_tblDataList.Rows[gridView1.FocusedRowHandle]["pmark"] = ""; gridControl1.DataSource = m_tblDataList; } } } catch (Exception ex) { XtraMsgBox.Show("加载关位失败!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error, ex, this.GetType()); } }
/// <summary> /// 选择向别信息 /// </summary> void repositoryItemComboBox2_EditValueChanged(object sender, EventArgs e) { try { string strID = gridView1.GetFocusedDataRow()["ID"].ToString(); if (strID != "") { XtraMsgBox.Show("向别-班别不能修改!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); gridView1.BestFitColumns(); return; } gridView1.CloseEditor(); gridView1.UpdateCurrentRow(); m_tblDataList = ((DataView)this.gridView1.DataSource).ToTable(); DataRow row = gridView1.GetFocusedDataRow(); if (row["ID"].ToString()!="") { return; } string strmyteamName = row["myTeamName"].ToString(); m_tblDataList.Rows[gridView1.FocusedRowHandle]["myTeamName"] = strmyteamName; string str_sql = string.Format(@"Select GuanweiID, GuanweiName,SetNum From V_Produce_Para where myTeamName='{0}' Order by GuanweiID", strmyteamName); m_tblGuanwei = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str_sql); repositoryItemComboBox3.Items.Clear(); //关位 for (int i = 0; i < m_tblGuanwei.Rows.Count; i++) { CboItemEntity item = new CboItemEntity(); //item.Value = i; item.Value = m_tblGuanwei.Rows[i]["GuanweiID"].ToString(); item.Text = m_tblGuanwei.Rows[i]["GuanweiName"].ToString(); repositoryItemComboBox3.Items.Add(item); } gridView1.BestFitColumns(); } catch (Exception ex) { XtraMsgBox.Show("加载关位失败!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error, ex, this.GetType()); } }
} //防止闪烁 /// <summary> /// 窗体初始化处理 /// </summary> public override void SetFormValue() { try { repositoryItemDateEdit2.EditMask = "yyyy-MM-dd HH:mm"; repositoryItemDateEdit2.Mask.UseMaskAsDisplayFormat = true; repositoryItemDateEdit3.EditMask = "yyyy-MM-dd HH:mm"; repositoryItemDateEdit3.Mask.UseMaskAsDisplayFormat = true; gridView1.IndicatorWidth =70; //班别 SysParam.m_daoCommon.SetLoopUpEdit(TableNames.P_Produce_Scheduling, lookTeamType, true, EnumDefine.DefalutItemAllNo, EnumDefine.DefalutItemAllText); repositoryItemComboBox2.ParseEditValue += new DevExpress.XtraEditors.Controls.ConvertEditValueEventHandler(repositoryItemComboBox2_ParseEditValue); repositoryItemButtonEdit1.ButtonClick+=new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(repositoryItemButtonEdit1_ButtonClick); if (gridView1 != null) { gridView1.CustomDrawRowIndicator += new DevExpress.XtraGrid.Views.Grid.RowIndicatorCustomDrawEventHandler(gridView1_CustomDrawRowIndicator); } //获取白班晚班 string str_sql = string.Format(@"select ID as pTypeID,pName as TeamSetName from P_Produce_TeamKind "); m_tblTeamType = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str_sql); for (int i = 0; i < m_tblTeamType.Rows.Count; i++) { CboItemEntity item = new CboItemEntity(); item.Value = m_tblTeamType.Rows[i]["pTypeID"].ToString(); item.Text = m_tblTeamType.Rows[i]["TeamSetName"].ToString(); repositoryItemComboBox2.Items.Add(item); } if (Common._myTeamName != "") { repositoryItemComboBox2.NullText = Common._myTeamName; } GetDspDataList(); } catch (Exception ex) { FrmAttendDialog FrmDialog = new FrmAttendDialog( "画面初始化失败!"+ex); FrmDialog.ShowDialog(); } }
/// <summary> /// 获取下拉 /// </summary> public void GetComBobox() { //获取账号状态下拉 string str = string.Format(@"select * from P_Oper_Status"); m_tblCbxList = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str); for (int i = 0; i < m_tblCbxList.Rows.Count; i++) { CboItemEntity item = new CboItemEntity(); item.Value = m_tblCbxList.Rows[i]["ID"].ToString(); item.Text = m_tblCbxList.Rows[i]["pName"].ToString(); repositoryItemComboBox3.Items.Add(item); } //获取用户类型下拉 str = string.Format(@"select * from P_Oper_Type"); m_tblCbxType = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str); for (int i = 0; i < m_tblCbxType.Rows.Count; i++) { CboItemEntity item = new CboItemEntity(); item.Value = m_tblCbxType.Rows[i]["ID"].ToString(); item.Text = m_tblCbxType.Rows[i]["pName"].ToString(); repositoryItemComboBox4.Items.Add(item); } }
/// <summary> /// 获取下拉框数据 /// </summary> public void GetSelectLookUpList() { try { string strSql = ""; //************向别-班别************ if (Common._myTeamName == "" || Common._myTeamName == null) { strSql = string.Format(@"select distinct myteamName from V_Produce_Para WHERE myteamName<>'' order by myteamName"); } else { strSql = string.Format(@"Select distinct myteamName From V_Produce_Para where myTeamName in ('{0}') AND myteamName<>'' Order by myteamName", Common._myTeamName); } DataTable dt_temp = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(strSql); //默认选中 DataRow dr = dt_temp.NewRow(); dr[0] = "全部"; dt_temp.Rows.InsertAt(dr, 0); lookUpEditmyTeamName.Properties.DataSource = dt_temp.DefaultView; lookUpEditmyTeamName.Properties.ValueMember = dt_temp.Columns[0].ColumnName; lookUpEditmyTeamName.Properties.DisplayMember = dt_temp.Columns[0].ColumnName; ; if (dt_temp.Rows.Count > 0) { lookUpEditmyTeamName.EditValue = dt_temp.Rows[0][0].ToString(); } lookUpEditmyTeamName.ItemIndex = 0; lookUpEditmyTeamName.Properties.BestFit(); //************班种************ //班别 SysParam.m_daoCommon.SetLoopUpEdit(TableNames.P_Produce_Scheduling, lookUpEditScheduling, true, EnumDefine.DefalutItemAllNo, EnumDefine.DefalutItemAllText); repositoryItemComboBox2.ParseEditValue += new DevExpress.XtraEditors.Controls.ConvertEditValueEventHandler(repositoryItemComboBox2_ParseEditValue); if (gridView1 != null) { gridView1.CustomDrawRowIndicator += new DevExpress.XtraGrid.Views.Grid.RowIndicatorCustomDrawEventHandler(gridView1_CustomDrawRowIndicator); } //获取白班晚班 string str_sql = string.Format(@"select ID as TypeID,pName as TypeName from P_Produce_TeamKind "); m_tblTeamType = SysParam.m_daoCommon.GetTableInfoBySqlNoWhere(str_sql); for (int i = 0; i < m_tblTeamType.Rows.Count; i++) { CboItemEntity item = new CboItemEntity(); item.Value = m_tblTeamType.Rows[i]["TypeID"].ToString(); item.Text = m_tblTeamType.Rows[i]["TypeName"].ToString(); repositoryItemComboBox2.Items.Add(item); } //开始时间 repositoryItemDateEdit1.EditMask = "yyyy-MM-dd HH:mm"; repositoryItemDateEdit1.Mask.UseMaskAsDisplayFormat = true; //结束时间 repositoryItemDateEdit2.EditMask = "yyyy-MM-dd HH:mm"; repositoryItemDateEdit2.Mask.UseMaskAsDisplayFormat = true; } catch (Exception ex) { log.Error(ex); XtraMsgBox.Show("数据加载失败!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error, ex, this.GetType()); } }