private void textBoxName_TextChanged(object sender, EventArgs e)
{
if (m_isInit)
{
if (!m_isAdd)
{
if (!m_isMaterielGroup)
{
if (m_materiel != null)
{
if (m_materiel.name.CompareTo(this.textBoxName.Text) != 0 ||
m_materiel.num.CompareTo(this.textBoxNum.Text) != 0 ||
m_materiel.nameShort.CompareTo(this.textBoxShortName.Text) != 0 ||
m_materiel.materielParameter.CompareTo(this.textBoxParameter.Text) != 0 ||
m_materiel.brand.CompareTo(this.textBoxBrand.Text) != 0 ||
m_materiel.model.CompareTo(this.textBoxModel.Text) != 0 ||
m_materiel.CZ.CompareTo(this.textBoxCZ.Text) != 0 ||
m_materiel.attribute1.CompareTo(this.textBoxAttribute1.Text) != 0 ||
m_materiel.attribute2.CompareTo(this.textBoxAttribute2.Text) != 0 ||
m_materiel.mnemonicCode.CompareTo(this.textBoxMnemonicCode.Text) != 0 ||
m_materiel.min != ConvertExtend.toInt32(this.textBoxMIN.Text.ToString()) ||
m_materiel.max != ConvertExtend.toInt32(this.textBoxMAX.Text.ToString()) ||
m_materiel.warramty != ConvertExtend.toInt32(this.textBoxWarranty.Text.ToString()) ||
m_materiel.materielAttribute != AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName(MATERIEL_ATTRIBUTE_TABLE_NAME, this.comboBoxMaterielAttribut.Text) ||
m_materiel.warramty != AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName(VALUATION_TYPE_LIST_TABLE_NAME, this.comboBoxValuationType.Text) ||
m_materiel.storage != AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName(STORAGE_LIST_TABLE_NAME, this.comboBoxStorage.Text) ||
m_materiel.unit != AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName(UNIT_LIST_TABLE_NAME, this.comboBoxUnit.Text) ||
m_materiel.unitPurchase != AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName(UNIT_LIST_TABLE_NAME, this.comboBoxUnitPurchase.Text) ||
m_materiel.unitSale != AuxiliaryMaterial.getInctance().getAuxiliaryMaterialPkeyFromName(UNIT_LIST_TABLE_NAME, this.comboBoxUnitSale.Text) ||
m_materiel.note.CompareTo(this.textBoxNote.Text) != 0)
{
this.buttonAdd.Enabled = true;
}
else
{
this.buttonAdd.Enabled = false;
}
}
}
else
{
if (m_materielType != null)
{
if (m_materielType.name.CompareTo(this.textBoxMaterielGroupName.Text) != 0 ||
m_materielType.num.CompareTo(this.textBoxGroupNum.Text) != 0 ||
m_materielType.desc.CompareTo(this.textBoxMaterielGroupDesc.Text) != 0)
{
this.buttonAdd.Enabled = true;
}
else
{
this.buttonAdd.Enabled = false;
}
}
}
}
}
}
private void load()
{
string userQuery = "SELECT [PKEY],[NUMBER],[NAME],[SEX],[EDU_BACKGROUND],[NO],[TEL],[ADDRESS],[E_MAIL]";
userQuery += ",[ENTRY_DATE],[PROFILE_ID],[DEPARTMENT],[STAFF_TYPE],[IS_FORBID],[REMARKS] FROM [dbo].[BASE_STAFF_LIST]";
m_noForbidStaffList.Clear();
m_forbidStaffList.Clear();
using (DataTable dataTable = DatabaseAccessFactoryInstance.Instance.QueryDataTable(FormMain.DB_NAME, userQuery))
{
foreach (DataRow row in dataTable.Rows)
{
StaffTable user = new StaffTable();
user.pkey = DbDataConvert.ToInt32(row[0]);
user.number = DbDataConvert.ToString(row[1]);
user.name = DbDataConvert.ToString(row[2]);
user.sex = DbDataConvert.ToString(row[3]);
user.eduBackground = DbDataConvert.ToString(row[4]);
user.NO = DbDataConvert.ToString(row[5]);
user.tel = DbDataConvert.ToString(row[6]);
user.address = DbDataConvert.ToString(row[7]);
user.email = DbDataConvert.ToString(row[8]);
user.enterDate = DbDataConvert.ToString(row[9]);
user.prifileID = ConvertExtend.toInt32(row[10].ToString());
user.departmentID = ConvertExtend.toInt32(row[11].ToString());
user.staffType = ConvertExtend.toInt32(row[12].ToString());
user.state = ConvertExtend.toInt32(row[13].ToString());
user.remarks = DbDataConvert.ToString(row[14]);
if (user.state == 1)
{
m_forbidStaffList.Add(m_forbidStaffList.Count, user);
}
else
{
m_noForbidStaffList.Add(m_noForbidStaffList.Count, user);
}
}
}
}
