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