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)); }
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 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"]; }