public void btnSearchByName_Click(System.Object sender, System.EventArgs e)
{
string s1 = " OrderNo الكـــود ,";
s1 += " (SELECT NAME FROM dbo.Employees WHERE Code=dbo.PaymentsEmployeesBetween.EmployeesCode) الاســــم,Amount المبلغ";
s = "Year=" + Settings.CurrentYear + " and Branch_ID=N'" + Settings.CurrentBranch_ID + "' and ShiftOrderNo=" + ShiftOrderNo + " and BoxCode=N'" + Settings.CurrentBox + "'";
mTable.Search(txtOrderNo, s1, s + " order by OrderNo");
Retrieve();
}
public void btnSearchByName_Click(System.Object sender, System.EventArgs e)
{
mTable.Search(txtCode, "Code الكـــود,Name الاســــم", where + " order by " + (BasicDataNo ? "CONVERT(INT,code)" : "Code"));
Retrieve();
}
private void txtEmployeeCode_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
Employees.Search(txtEmployeeCode, "Code الكـــود,Name الاســــم", " 1=1 order by " + (BasicDataNo ? "CONVERT(INT,code)" : "Code"));
txtEmployeeCode_Validated(null, null);
}
private void txtCode_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
Employees.Search(txtCode, "Code الكود,Name الاسم");
txtCode_Validated(null, null);
}