public FormEmployee( ) { InitializeComponent( ); _bll = new LineProductMesBll.Bll.EmployeeBll( ); _model = new LineProductMesEntityu.EmployeeEntity( ); ToolBarContain.ToolbarC(barTool, toolExamin); UnEnable( ); GridViewMoHuSelect.SetFilter(gridView1); FieldInfo fi = typeof(DevExpress.Utils.Paint.XPaint).GetField("graphics", BindingFlags.Static | BindingFlags.NonPublic); fi.SetValue(null, new DrawXPaint( )); wait.Hide( ); getValueForPUATask( ); getDepart( ); clear( ); }
/// <summary> /// 编辑一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Edit(LineProductMesEntityu.EmployeeEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("update MIKEMP set "); strSql.Append("EMP002=@EMP002,"); strSql.Append("EMP003=@EMP003,"); strSql.Append("EMP004=@EMP004,"); strSql.Append("EMP005=@EMP005,"); strSql.Append("EMP006=@EMP006,"); strSql.Append("EMP007=@EMP007,"); strSql.Append("EMP008=@EMP008,"); strSql.Append("EMP009=@EMP009,"); strSql.Append("EMP010=@EMP010,"); strSql.Append("EMP011=@EMP011,"); strSql.Append("EMP012=@EMP012,"); strSql.Append("EMP013=@EMP013,"); strSql.Append("EMP014=@EMP014,"); strSql.Append("EMP015=@EMP015,"); strSql.Append("EMP016=@EMP016,"); strSql.Append("EMP017=@EMP017,"); strSql.Append("EMP018=@EMP018,"); strSql.Append("EMP019=@EMP019,"); strSql.Append("EMP020=@EMP020,"); strSql.Append("EMP021=@EMP021,"); strSql.Append("EMP022=@EMP022,"); strSql.Append("EMP023=@EMP023,"); strSql.Append("EMP024=@EMP024,"); strSql.Append("EMP025=@EMP025,"); strSql.Append("EMP026=@EMP026,"); strSql.Append("EMP027=@EMP027,"); strSql.Append("EMP028=@EMP028,"); strSql.Append("EMP029=@EMP029,"); strSql.Append("EMP030=@EMP030,"); strSql.Append("EMP031=@EMP031,"); strSql.Append("EMP032=@EMP032,"); strSql.Append("EMP034=@EMP034,"); strSql.Append("EMP035=@EMP035,"); strSql.Append("EMP036=@EMP036,"); strSql.Append("EMP037=@EMP037,"); strSql.Append("EMP038=@EMP038"); strSql.Append(" where EMP001=@EMP001"); SqlParameter [] parameters = { new SqlParameter("@EMP002", SqlDbType.NVarChar, 20), new SqlParameter("@EMP003", SqlDbType.NVarChar, 20), new SqlParameter("@EMP004", SqlDbType.NVarChar, 20), new SqlParameter("@EMP005", SqlDbType.NVarChar, 20), new SqlParameter("@EMP006", SqlDbType.NVarChar, 20), new SqlParameter("@EMP007", SqlDbType.NVarChar, 20), new SqlParameter("@EMP008", SqlDbType.Bit, 1), new SqlParameter("@EMP009", SqlDbType.Date, 3), new SqlParameter("@EMP010", SqlDbType.NVarChar, 20), new SqlParameter("@EMP011", SqlDbType.NVarChar, 20), new SqlParameter("@EMP012", SqlDbType.NVarChar, 20), new SqlParameter("@EMP013", SqlDbType.NVarChar, 20), new SqlParameter("@EMP014", SqlDbType.NVarChar, 50), new SqlParameter("@EMP015", SqlDbType.NVarChar, 20), new SqlParameter("@EMP016", SqlDbType.NVarChar, 20), new SqlParameter("@EMP017", SqlDbType.NVarChar, 20), new SqlParameter("@EMP018", SqlDbType.NVarChar, 20), new SqlParameter("@EMP019", SqlDbType.NVarChar, 20), new SqlParameter("@EMP020", SqlDbType.NVarChar, 20), new SqlParameter("@EMP021", SqlDbType.NVarChar, 20), new SqlParameter("@EMP022", SqlDbType.NVarChar, 20), new SqlParameter("@EMP023", SqlDbType.Date, 3), new SqlParameter("@EMP024", SqlDbType.NVarChar, 20), new SqlParameter("@EMP025", SqlDbType.Bit, 1), new SqlParameter("@EMP026", SqlDbType.NVarChar, 200), new SqlParameter("@EMP027", SqlDbType.Decimal, 9), new SqlParameter("@EMP028", SqlDbType.Decimal, 9), new SqlParameter("@EMP029", SqlDbType.Decimal, 9), new SqlParameter("@EMP030", SqlDbType.Decimal, 9), new SqlParameter("@EMP031", SqlDbType.Decimal, 9), new SqlParameter("@EMP032", SqlDbType.Decimal, 9), new SqlParameter("@EMP034", SqlDbType.Bit, 1), new SqlParameter("@EMP001", SqlDbType.NVarChar, 20), new SqlParameter("@EMP035", SqlDbType.NVarChar, 20), new SqlParameter("@EMP036", SqlDbType.NVarChar, 20), new SqlParameter("@EMP037", SqlDbType.Bit, 1), new SqlParameter("@EMP038", SqlDbType.NVarChar, 100) }; parameters [0].Value = model.EMP002; parameters [1].Value = model.EMP003; parameters [2].Value = model.EMP004; parameters [3].Value = model.EMP005; parameters [4].Value = model.EMP006; parameters [5].Value = model.EMP007; parameters [6].Value = model.EMP008; parameters [7].Value = model.EMP009; parameters [8].Value = model.EMP010; parameters [9].Value = model.EMP011; parameters [10].Value = model.EMP012; parameters [11].Value = model.EMP013; parameters [12].Value = model.EMP014; parameters [13].Value = model.EMP015; parameters [14].Value = model.EMP016; parameters [15].Value = model.EMP017; parameters [16].Value = model.EMP018; parameters [17].Value = model.EMP019; parameters [18].Value = model.EMP020; parameters [19].Value = model.EMP021; parameters [20].Value = model.EMP022; parameters [21].Value = model.EMP023; parameters [22].Value = model.EMP024; parameters [23].Value = model.EMP025; parameters [24].Value = model.EMP026; parameters [25].Value = model.EMP027; parameters [26].Value = model.EMP028; parameters [27].Value = model.EMP029; parameters [28].Value = model.EMP030; parameters [29].Value = model.EMP031; parameters [30].Value = model.EMP032; parameters [31].Value = model.EMP034; parameters [32].Value = model.EMP001; parameters [33].Value = model.EMP035; parameters [34].Value = model.EMP036; parameters [35].Value = model.EMP037; parameters [36].Value = model.EMP038; int row = SqlHelper.ExecuteNonQuery(strSql.ToString( ), parameters); if (row > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public int Add(LineProductMesEntityu.EmployeeEntity model) { StringBuilder strSql = new StringBuilder( ); strSql.Append("insert into MIKEMP("); strSql.Append("EMP001,EMP002,EMP003,EMP004,EMP005,EMP006,EMP007,EMP008,EMP009,EMP010,EMP011,EMP012,EMP013,EMP014,EMP015,EMP016,EMP017,EMP018,EMP019,EMP020,EMP021,EMP022,EMP023,EMP024,EMP025,EMP026,EMP027,EMP028,EMP029,EMP030,EMP031,EMP032,EMP033,EMP034,EMP035,EMP036,EMP037,EMP038)"); strSql.Append(" values ("); strSql.Append("@EMP001,@EMP002,@EMP003,@EMP004,@EMP005,@EMP006,@EMP007,@EMP008,@EMP009,@EMP010,@EMP011,@EMP012,@EMP013,@EMP014,@EMP015,@EMP016,@EMP017,@EMP018,@EMP019,@EMP020,@EMP021,@EMP022,@EMP023,@EMP024,@EMP025,@EMP026,@EMP027,@EMP028,@EMP029,@EMP030,@EMP031,@EMP032,@EMP033,@EMP034,@EMP035,@EMP036,@EMP037,@EMP038)"); strSql.Append(";select @@IDENTITY"); SqlParameter [] parameters = { new SqlParameter("@EMP001", SqlDbType.NVarChar, 20), new SqlParameter("@EMP002", SqlDbType.NVarChar, 20), new SqlParameter("@EMP003", SqlDbType.NVarChar, 20), new SqlParameter("@EMP004", SqlDbType.NVarChar, 20), new SqlParameter("@EMP005", SqlDbType.NVarChar, 20), new SqlParameter("@EMP006", SqlDbType.NVarChar, 20), new SqlParameter("@EMP007", SqlDbType.NVarChar, 20), new SqlParameter("@EMP008", SqlDbType.Bit, 1), new SqlParameter("@EMP009", SqlDbType.Date, 3), new SqlParameter("@EMP010", SqlDbType.NVarChar, 20), new SqlParameter("@EMP011", SqlDbType.NVarChar, 20), new SqlParameter("@EMP012", SqlDbType.NVarChar, 20), new SqlParameter("@EMP013", SqlDbType.NVarChar, 20), new SqlParameter("@EMP014", SqlDbType.NVarChar, 50), new SqlParameter("@EMP015", SqlDbType.NVarChar, 20), new SqlParameter("@EMP016", SqlDbType.NVarChar, 20), new SqlParameter("@EMP017", SqlDbType.NVarChar, 20), new SqlParameter("@EMP018", SqlDbType.NVarChar, 20), new SqlParameter("@EMP019", SqlDbType.NVarChar, 20), new SqlParameter("@EMP020", SqlDbType.NVarChar, 20), new SqlParameter("@EMP021", SqlDbType.NVarChar, 20), new SqlParameter("@EMP022", SqlDbType.NVarChar, 20), new SqlParameter("@EMP023", SqlDbType.Date, 3), new SqlParameter("@EMP024", SqlDbType.NVarChar, 20), new SqlParameter("@EMP025", SqlDbType.Bit, 1), new SqlParameter("@EMP026", SqlDbType.NVarChar, 200), new SqlParameter("@EMP027", SqlDbType.Decimal, 9), new SqlParameter("@EMP028", SqlDbType.Decimal, 9), new SqlParameter("@EMP029", SqlDbType.Decimal, 9), new SqlParameter("@EMP030", SqlDbType.Decimal, 9), new SqlParameter("@EMP031", SqlDbType.Decimal, 9), new SqlParameter("@EMP032", SqlDbType.Decimal, 9), new SqlParameter("@EMP033", SqlDbType.NVarChar, 50), new SqlParameter("@EMP034", SqlDbType.Bit, 1), new SqlParameter("@EMP035", SqlDbType.NVarChar, 20), new SqlParameter("@EMP036", SqlDbType.NVarChar, 20), new SqlParameter("@EMP037", SqlDbType.Bit, 1), new SqlParameter("@EMP038", SqlDbType.NVarChar, 100) }; parameters [0].Value = model.EMP001; parameters [1].Value = model.EMP002; parameters [2].Value = model.EMP003; parameters [3].Value = model.EMP004; parameters [4].Value = model.EMP005; parameters [5].Value = model.EMP006; parameters [6].Value = model.EMP007; parameters [7].Value = model.EMP008; parameters [8].Value = model.EMP009; parameters [9].Value = model.EMP010; parameters [10].Value = model.EMP011; parameters [11].Value = model.EMP012; parameters [12].Value = model.EMP013; parameters [13].Value = model.EMP014; parameters [14].Value = model.EMP015; parameters [15].Value = model.EMP016; parameters [16].Value = model.EMP017; parameters [17].Value = model.EMP018; parameters [18].Value = model.EMP019; parameters [19].Value = model.EMP020; parameters [20].Value = model.EMP021; parameters [21].Value = model.EMP022; parameters [22].Value = model.EMP023; parameters [23].Value = model.EMP024; parameters [24].Value = model.EMP025; parameters [25].Value = model.EMP026; parameters [26].Value = model.EMP027; parameters [27].Value = model.EMP028; parameters [28].Value = model.EMP029; parameters [29].Value = model.EMP030; parameters [30].Value = model.EMP031; parameters [31].Value = model.EMP032; parameters [32].Value = model.EMP033; parameters [33].Value = model.EMP034; parameters [34].Value = model.EMP035; parameters [35].Value = model.EMP036; parameters [36].Value = model.EMP037; parameters [37].Value = model.EMP038; return(SqlHelper.ExecuteSqlReturnId(strSql.ToString( ), parameters)); }
/// <summary> /// 编辑一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public bool Edit(LineProductMesEntityu.EmployeeEntity _model) { return(dal.Edit(_model)); }
/// <summary> /// 增加一条记录 /// </summary> /// <param name="_model"></param> /// <returns></returns> public int Add(LineProductMesEntityu.EmployeeEntity _model) { return(dal.Add(_model)); }
void assignMent(DataRow row, LineProductMesEntityu.EmployeeEntity _model) { if (_model.idx < 0) { return; } _model.EMP034 = ( bool )row ["EMP034"]; if (Convert.ToBoolean(_model.EMP034)) { layoutControlItem37.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always; Graph.grPic(pictureEdit1, "注销"); toolCancellation.Caption = "反注销"; toolEdit.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; toolDelete.Visibility = DevExpress.XtraBars.BarItemVisibility.Never; } else { layoutControlItem37.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never; Graph.grPic(pictureEdit1, "反"); toolCancellation.Caption = "注销"; toolEdit.Visibility = DevExpress.XtraBars.BarItemVisibility.Always; toolDelete.Visibility = DevExpress.XtraBars.BarItemVisibility.Always; } txtEMP001.Tag = row ["idx"].ToString( ); txtEMP001.Text = row ["EMP001"].ToString( ); txtEMP002.Text = row ["EMP002"].ToString( ); txtEMP004.EditValue = row ["EMP003"]; txtEMP006.EditValue = row ["EMP005"]; txtEMP007.Text = row ["EMP007"].ToString( ); txtEMP008.Text = row ["EMP008"].ToString( ); txtEMP009.Text = string.IsNullOrEmpty(row ["EMP009"].ToString( )) == true ? string.Empty : Convert.ToDateTime(row ["EMP009"].ToString( )).ToString("yyyy-MM-dd"); txtEMP010.Text = row ["EMP010"].ToString( ); txtEMP011.Text = row ["EMP011"].ToString( ); txtEMP012.Text = row ["EMP012"].ToString( ); txtEMP013.Text = row ["EMP013"].ToString( ); txtEMP014.Text = row ["EMP014"].ToString( ); txtEMP015.Text = row ["EMP015"].ToString( ); txtEMP016.Text = row ["EMP016"].ToString( ); txtEMP017.Text = row ["EMP017"].ToString( ); txtEMP018.Text = row ["EMP018"].ToString( ); txtEMP019.Text = row ["EMP019"].ToString( ); txtEMP020.Text = row ["EMP020"].ToString( ); txtEMP021.Text = row ["EMP021"].ToString( ); txtEMP022.Text = row ["EMP022"].ToString( ); txtEMP023.Text = string.IsNullOrEmpty(row ["EMP023"].ToString( )) == true ? string.Empty : Convert.ToDateTime(row ["EMP023"].ToString( )).ToString("yyyy-MM-dd"); txtEMP024.Text = row ["EMP024"].ToString( ); txtEMP025.Text = row ["EMP025"].ToString( ); txtEMP026.Text = row ["EMP026"].ToString( ); txtEMP027.Text = row ["EMP027"].ToString( ); txtEMP028.Text = row ["EMP028"].ToString( ); txtEMP029.Text = row ["EMP029"].ToString( ); txtEMP030.Text = row ["EMP030"].ToString( ); txtEMP031.Text = row ["EMP031"].ToString( ); txtEMP032.Text = row ["EMP032"].ToString( ); txtEMP035.Text = row ["EMP035"].ToString( ); txtEMP036.Text = row ["EMP036"].ToString( ); txtEMP037.Checked = string.IsNullOrEmpty(row ["EMP037"].ToString( )) == true ? true : Convert.ToBoolean(row ["EMP037"]); string sx = row ["EMP038"].ToString( ); txtEMP038.Text = row ["EMP038"].ToString( ); tabPageOne.Refresh( ); }
void serial(LineProductMesEntityu.EmployeeEntity _model) { statePrevious = _model.EMP001; }