public override global::System.Data.DataTable Clone()
{
EmployeeDataTable cln = ((EmployeeDataTable)(base.Clone()));
cln.InitVars();
return(cln);
}
public bool Save()
{
bool f = false;
if (Userid == -1 && Username.Equals(""))
{
return(f);
}
else if (Userid == -1)
{
if (Email != "" && EmployeeDataTable.Select(string.Format("email = '{0}' and onjob = 1", Email)).Length > 0)
{
xuxSeecion.ERRMESSAGE = "Email 重复";
}
else if (EmployeeDataTable.Select(string.Format("idcardno = '{0}' and onjob = 1", Idcardno)).Length > 0)
{
xuxSeecion.ERRMESSAGE = "证件号码重复";
}
else
{
f = insertUser();
}
}
else
{
f = updateUser();
}
return(f);
}
public employee(string email, string pwd)
{
//test();
//string[] para = new string[] { email, pwd };
sxEmployeeDataTable();
//DataTable dt = Select("select userid,username,englishname,usertypeid,userpowerid,birthday,cardtype,idcardno,sex,employeeno,joindate,"
// + "onjob,email,outdate from T_employeeInfo where email = @para1 and pwd = @para2 and onjob = 1", para);
DataRow[] drc = EmployeeDataTable.Select(string.Format("email = '{0}' and pwd = '{1}' and onjob = 1", email, pwd));
if (drc.Length == 1)
{
DataRow dr = drc[0];
Userid = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("userid")]);
Username = dr.ItemArray[EmployeeDataTable.Columns.IndexOf("username")].ToString();
Englishname = dr.ItemArray[EmployeeDataTable.Columns.IndexOf("englishname")].ToString();
Usertypeid = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("usertypeid")]);
Userpowerid = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("userpowerid")]);
Birthday = Convert.ToDateTime(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("birthday")]);
Cardtype = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("Cardtype")]);
Idcardno = dr.ItemArray[EmployeeDataTable.Columns.IndexOf("idcardno")].ToString();
Sex = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("sex")]);
//Employeeno = Convert.ToInt16(dr.ItemArray[dt.Columns.IndexOf("employeeno")]);
Joindate = Convert.ToDateTime(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("joindate")]);
Outdate = Convert.ToDateTime(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("outdate")]);
Onjob = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("onjob")]) == 1 ?true:false;
Email = email;
Pwd = pwd;
}
else
{
Userid = -1;
}
}
public bool GetByUserId(string userId)
{
bool b = false;
//string[] para = new string[] { userId };
//DataTable dt = Select("select userid,username,englishname,usertypeid,userpowerid,birthday,cardtype,idcardno,sex,employeeno,joindate,"
// + "onjob,email,outdate from T_employeeInfo where userid = @para1", para);
DataRow[] drs = EmployeeDataTable.Select(string.Format("userid = {0}", userId));
if (drs.Length == 1)
{
b = true;
DataRow dr = drs[0];
Userid = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("userid")]);
Username = dr.ItemArray[EmployeeDataTable.Columns.IndexOf("username")].ToString();
Englishname = dr.ItemArray[EmployeeDataTable.Columns.IndexOf("englishname")].ToString();
Usertypeid = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("usertypeid")]);
Userpowerid = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("userpowerid")]);
Birthday = Convert.ToDateTime(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("birthday")]);
Cardtype = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("Cardtype")]);
Idcardno = dr.ItemArray[EmployeeDataTable.Columns.IndexOf("idcardno")].ToString();
Sex = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("sex")]);
//Employeeno = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("employeeno")]);
Joindate = Convert.ToDateTime(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("joindate")]);
Outdate = Convert.ToDateTime(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("outdate")]);
Onjob = Convert.ToInt16(dr.ItemArray[EmployeeDataTable.Columns.IndexOf("onjob")]) == 1 ? true : false;
Email = dr.ItemArray[EmployeeDataTable.Columns.IndexOf("email")].ToString();
}
return(b);
}
public virtual EmployeeDataTable GetData()
{
this.Adapter.SelectCommand = this.CommandCollection[0];
EmployeeDataTable employeeDataTable = new EmployeeDataTable();
this.Adapter.Fill(employeeDataTable);
return(employeeDataTable);
}
internal void InitVars()
{
this.tableEmployee = ((EmployeeDataTable)(this.Tables["Employee"]));
if ((this.tableEmployee != null))
{
this.tableEmployee.InitVars();
}
}
private void InitClass()
{
this.DataSetName = "Employees";
this.Prefix = "";
this.Locale = new global::System.Globalization.CultureInfo("en-US");
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableEmployee = new EmployeeDataTable();
base.Tables.Add(this.tableEmployee);
}
private void InitClass()
{
this.DataSetName = "NewDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/data.xsd";
this.EnforceConstraints = false;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableEmployee = new EmployeeDataTable();
base.Tables.Add(this.tableEmployee);
}
public virtual int Fill(EmployeeDataTable dataTable)
{
this.Adapter.SelectCommand = this.CommandCollection[0];
if (this.ClearBeforeFill)
{
dataTable.Clear();
}
int num = this.Adapter.Fill(dataTable);
return(num);
}
internal void InitVars(bool initTable)
{
this.tableEmployee = ((EmployeeDataTable)(base.Tables["Employee"]));
if ((initTable == true))
{
if ((this.tableEmployee != null))
{
this.tableEmployee.InitVars();
}
}
}
private void InitClass()
{
this.DataSetName = "empSet";
this.Prefix = "";
this.Namespace = "http://www.tempuri.org/empSet.xsd";
this.Locale = new System.Globalization.CultureInfo("en-US");
this.CaseSensitive = false;
this.EnforceConstraints = true;
this.tableEmployee = new EmployeeDataTable();
this.Tables.Add(this.tableEmployee);
}
private void EmployeeForm_Load(object sender, EventArgs e)
{
this.eTable = this._employee.getEmployee();
this.eTable.AddressColumn.ColumnName = "العنوان";
this.eTable.AccCodeColumn.ColumnName = "رقم الحساب";
this.eTable.NameColumn.ColumnName = "اسم الموظف";
this.eTable.EmployeeIDColumn.ColumnName = "رقم الموظف";
this.eTable.PhoneColumn.ColumnName = "رقم الهاتف";
this.eTable.NationalityColumn.ColumnName = "الجنسية";
this.eTable.IDNumberColumn.ColumnName = "رقم الهوية";
this.eTable.RoleColumn.ColumnName = "الوظيفة";
this.dgvEmployee.DataSource = this.eTable;
this.mode = Mode.Null;
base.WindowState = FormWindowState.Maximized;
this.resetUI((Form1)base.MdiParent.UserName);
}
internal EmployeeRow(global::System.Data.DataRowBuilder rb) :
base(rb)
{
this.tableEmployee = ((EmployeeDataTable)(this.Table));
}
internal EmployeeRow(global::System.Data.DataRowBuilder rb) :
base(rb) {
this.tableEmployee = ((EmployeeDataTable)(this.Table));
}
private void InitClass() {
this.DataSetName = "MyDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/MyDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableEmployee = new EmployeeDataTable();
base.Tables.Add(this.tableEmployee);
}
internal void InitVars(bool initTable) {
this.tableEmployee = ((EmployeeDataTable)(base.Tables["Employee"]));
if ((initTable == true)) {
if ((this.tableEmployee != null)) {
this.tableEmployee.InitVars();
}
}
}
internal EmployeeRow(DataRowBuilder rb) :
base(rb)
{
this.tableEmployee = ((EmployeeDataTable)(this.Table));
}
public virtual int Update(EmployeeDataTable dataTable)
{
return(this.Adapter.Update(dataTable));
}
private void InitClass()
{
this.DataSetName = "Company";
this.Prefix = "";
this.Namespace = "http://www.softlang.org/company.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableDepartment = new DepartmentDataTable();
base.Tables.Add(this.tableDepartment);
this.tableManager = new ManagerDataTable();
base.Tables.Add(this.tableManager);
this.tableEmployee = new EmployeeDataTable();
base.Tables.Add(this.tableEmployee);
global::System.Data.ForeignKeyConstraint fkc;
fkc = new global::System.Data.ForeignKeyConstraint("Department_Department", new global::System.Data.DataColumn[] {
this.tableDepartment.Department_IdColumn}, new global::System.Data.DataColumn[] {
this.tableDepartment.Department_Id_0Column});
this.tableDepartment.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.Cascade;
fkc.UpdateRule = global::System.Data.Rule.Cascade;
fkc = new global::System.Data.ForeignKeyConstraint("Department_Manager", new global::System.Data.DataColumn[] {
this.tableDepartment.Department_IdColumn}, new global::System.Data.DataColumn[] {
this.tableManager.Department_IdColumn});
this.tableManager.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.Cascade;
fkc.UpdateRule = global::System.Data.Rule.Cascade;
fkc = new global::System.Data.ForeignKeyConstraint("Department_Employee", new global::System.Data.DataColumn[] {
this.tableDepartment.Department_IdColumn}, new global::System.Data.DataColumn[] {
this.tableEmployee.Department_IdColumn});
this.tableEmployee.Constraints.Add(fkc);
fkc.AcceptRejectRule = global::System.Data.AcceptRejectRule.None;
fkc.DeleteRule = global::System.Data.Rule.Cascade;
fkc.UpdateRule = global::System.Data.Rule.Cascade;
this.relationDepartment_Department = new global::System.Data.DataRelation("Department_Department", new global::System.Data.DataColumn[] {
this.tableDepartment.Department_IdColumn}, new global::System.Data.DataColumn[] {
this.tableDepartment.Department_Id_0Column}, false);
this.relationDepartment_Department.Nested = true;
this.Relations.Add(this.relationDepartment_Department);
this.relationDepartment_Manager = new global::System.Data.DataRelation("Department_Manager", new global::System.Data.DataColumn[] {
this.tableDepartment.Department_IdColumn}, new global::System.Data.DataColumn[] {
this.tableManager.Department_IdColumn}, false);
this.relationDepartment_Manager.Nested = true;
this.Relations.Add(this.relationDepartment_Manager);
this.relationDepartment_Employee = new global::System.Data.DataRelation("Department_Employee", new global::System.Data.DataColumn[] {
this.tableDepartment.Department_IdColumn}, new global::System.Data.DataColumn[] {
this.tableEmployee.Department_IdColumn}, false);
this.relationDepartment_Employee.Nested = true;
this.Relations.Add(this.relationDepartment_Employee);
}
internal void InitVars(bool initTable)
{
this.tableDepartment = ((DepartmentDataTable)(base.Tables["Department"]));
if ((initTable == true)) {
if ((this.tableDepartment != null)) {
this.tableDepartment.InitVars();
}
}
this.tableManager = ((ManagerDataTable)(base.Tables["Manager"]));
if ((initTable == true)) {
if ((this.tableManager != null)) {
this.tableManager.InitVars();
}
}
this.tableEmployee = ((EmployeeDataTable)(base.Tables["Employee"]));
if ((initTable == true)) {
if ((this.tableEmployee != null)) {
this.tableEmployee.InitVars();
}
}
this.relationDepartment_Department = this.Relations["Department_Department"];
this.relationDepartment_Manager = this.Relations["Department_Manager"];
this.relationDepartment_Employee = this.Relations["Department_Employee"];
}
