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;
}
