private void FrmGetMaterias_Load(object sender, EventArgs e)
{
try
{
DataTable dt = CtrlAreas.GetAreaAll().Tables[0];
LueArea.Properties.DataSource = dt;
LueArea.Properties.DisplayMember = "Nombre";
LueArea.Properties.ValueMember = "Codigo";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col;
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Nombre", "Nombre", 100);
//col.SortOrder = DevExpress.Data.ColumnSortOrder.Ascending;
LueArea.Properties.Columns.Add(col);
LueArea.ItemIndex = -1;
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, Resources.AppName, MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button2);
return;
}
TxtNombre.Focus();
if (Modo == "E" && Id > 0)
{
CargarDatos(Id);
}
}
public Form1()
{
InitializeComponent();
DataTable dt = new DataTable();
DataColumn c1 = new DataColumn("code", typeof(System.String));
DataColumn c2 = new DataColumn("name", typeof(System.String));
DataColumn c3 = new DataColumn("pym", typeof(System.String));
DataColumn c4 = new DataColumn("pymName", typeof(System.String));
dt.Columns.Add(c1); dt.Columns.Add(c2); dt.Columns.Add(c3);; dt.Columns.Add(c4);
DataRow dr = dt.NewRow();
dr = dt.NewRow(); dr.ItemArray = new object[] { "1", "张山", "zs", "zs张山" }; dt.Rows.Add(dr);
dr = dt.NewRow(); dr.ItemArray = new object[] { "2", "张三", "zs", "zs张三" }; dt.Rows.Add(dr);
dr = dt.NewRow(); dr.ItemArray = new object[] { "3", "李四", "ls", "ls李四" }; dt.Rows.Add(dr);
dr = dt.NewRow(); dr.ItemArray = new object[] { "4", "李胜", "ls", "ls李胜" }; dt.Rows.Add(dr);
dr = dt.NewRow(); dr.ItemArray = new object[] { "6", "李爽", "ls", "ls李爽" }; dt.Rows.Add(dr);
dr = dt.NewRow(); dr.ItemArray = new object[] { "7", "王五", "ww", "ww王五" }; dt.Rows.Add(dr);
//lookUpCmb1.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;
//lookUpCmb1.Properties.DisplayMember = "name";
//lookUpCmb1.Properties.ValueMember = "code";
//lookUpCmb1.Properties.DataSource = dt;
//lookUpCmb1.DataSource = dt.Copy();
// DevExpress.XtraEditors.Controls.LookUpColumnInfo
DevExpress.XtraEditors.Controls.LookUpColumnInfo col1 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("name", 30, "名称");
DevExpress.XtraEditors.Controls.LookUpColumnInfo col2 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("code", 30, "代码");
DevExpress.XtraEditors.Controls.LookUpColumnInfo col3 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("pym", 30, "拼音码");
DevExpress.XtraEditors.Controls.LookUpColumnInfo col4 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("pymName", 30, "");
//lookUpCmb1.Properties.Columns.AddRange(new DevExpress.XtraEditors.Controls.LookUpColumnInfo[] { col1, col2, col3, col4});
}
/// <summary>LlenarTablas(String tabla)
/// Permite inicializar el LookUpEdit (LueOrigenD), con las tablas que pertenecen a la Base de Datos.
/// Si el parametro (tabla), es diferente de ""; se inicializa el LookUpEdit (LueOrigenD), y se selecciona el nombre de la tabla que viene en el parametro (tabla)
/// </summary>
/// <param name="tabla">En este parametro se recibe el nombre de la tabla que se desea selecionar en el LookUpEdit (LueOrigenD) </param>
public void LlenarTablas(String tabla)
{
Funciones f = new Funciones();
dsTablas = f.GetTables(ConexionDB.getInstancia().Conexion(Dbase, null));
dtTablas = dsTablas.Tables[0];
try
{
LueOrigenD.Properties.DataSource = dtTablas;
LueOrigenD.Properties.DisplayMember = "TABLA";
LueOrigenD.Properties.ValueMember = "TABLA";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col;
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("TABLA", 10, "Tablas");
col.SortOrder = DevExpress.Data.ColumnSortOrder.Ascending;
LueOrigenD.Properties.Columns.Add(col);
var col2 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Id", 10, "Tablas");
col2.Visible = false;
LueOrigenD.Properties.Columns.Add(col2);
if (!String.IsNullOrEmpty(tabla))
{
LueOrigenD.EditValue = tabla;
}
else
{
LueOrigenD.ItemIndex = -1;
}
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message);
}
}
public void Bind_Lookkupedit_Application_Login()
{
lookUpEdit3_Application_Login.Properties.DataSource = null;
Hashtable htParam = new Hashtable();
DataTable dtParam = new DataTable();
htParam.Clear();
dtParam.Clear();
htParam.Add("@Trans", "BIND_APPLICATION_TYPE");
dtParam = dataaccess.ExecuteSP("Sp_User", htParam);
if (dtParam.Rows.Count > 0)
{
DataRow dr = dtParam.NewRow();
dr[0] = 0;
dr[1] = "SELECT";
dtParam.Rows.InsertAt(dr, 0);
}
lookUpEdit3_Application_Login.Properties.DataSource = dtParam;
lookUpEdit3_Application_Login.Properties.DisplayMember = "Application_Login_Type";
lookUpEdit3_Application_Login.Properties.ValueMember = "Application_Login_Type_Id";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col;
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Application_Login_Type", 100);
lookUpEdit3_Application_Login.Properties.Columns.Add(col);
}
public static void InitDefaultRepositoryLookupEdit(String strTableName, ABCRepositoryLookUpEdit repo)
{
DataConfigProvider.TableConfig config = DataConfigProvider.TableConfigList[strTableName];
#region Columns
foreach (String strField in config.FieldConfigList.Keys)
{
if (config.FieldConfigList[strField].InUse && config.FieldConfigList[strField].IsDefault)
{
DevExpress.XtraEditors.Controls.LookUpColumnInfo col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo();
col.FieldName = strField;
col.Caption = DataConfigProvider.GetFieldCaption(strTableName, strField);
col.Visible = true;
repo.Columns.Add(col);
}
}
#endregion
repo.ValueMember = DataStructureProvider.DataTablesList[strTableName].PrimaryColumn;
repo.DisplayMember = DataStructureProvider.GetDisplayColumn(strTableName);
if (String.IsNullOrWhiteSpace(repo.DisplayMember) && repo.Columns.Count > 0)
{
repo.DisplayMember = repo.Columns[0].FieldName;
}
repo.BestFit();
}
private void FrmImprimirBoletin_Load(object sender, EventArgs e)
{
try
{
DataTable dt2 = CtrlCursos.GetCursoAll().Tables[0];
LueCurso.Properties.DataSource = dt2;
LueCurso.Properties.DisplayMember = "Nombre";
LueCurso.Properties.ValueMember = "CodigoCurso";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col1;
col1 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Nombre", "Nombre", 100);
LueCurso.Properties.Columns.Clear();
LueCurso.Properties.Columns.Add(col1);
LueCurso.ItemIndex = -1;
DataTable dt3 = CtrlPeriodos.GetPeriodoAll().Tables[0];
LuePeriodo.Properties.DataSource = dt3;
LuePeriodo.Properties.DisplayMember = "Nombre";
LuePeriodo.Properties.ValueMember = "CodigoPeriodo";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col2;
col2 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Nombre", "Nombre", 100);
LuePeriodo.Properties.Columns.Add(col2);
LuePeriodo.ItemIndex = -1;
LuePeriodo.EditValue = CodPeriodo;
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, Resources.AppName, MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button2);
return;
}
TxtAño.Text = Año.ToString();
}
public void BindLookUpEdit_Accuracy_Month()
{
Hashtable ht_month = new Hashtable();
System.Data.DataTable dt_month = new System.Data.DataTable();
lookUpEdit_Accuracy_Month.Properties.DataSource = null;
ht_month.Add("@Trans", "GET_MONTHS");
dt_month = dataaccess.ExecuteSP("Sp_Score_Board", ht_month);
DataRow dr = dt_month.NewRow();
dr[0] = 0;
dr[1] = "SELECT";
dt_month.Rows.InsertAt(dr, 0);
lookUpEdit_Accuracy_Month.Properties.DataSource = dt_month;
lookUpEdit_Accuracy_Month.Properties.DisplayMember = "monthname";
lookUpEdit_Accuracy_Month.Properties.ValueMember = "mth";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col_month;
col_month = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("monthname", 100);
lookUpEdit_Accuracy_Month.Properties.Columns.Add(col_month);
}
private void mdServiceInit()
{
fMode = "N";
string strSQL;
//strSQL = "select * from tblServiceType";
//comboBind(mdSV_cbNServiceTypeID,strSQL,"strDescription","nServiceTypeID",true);
DataTable dt;
DataSet _ds;
_ds = new DataSet();
strSQL = "select * from tblServiceType";
SqlHelper.FillDataset(connection, CommandType.StoredProcedure, "UP_GETDATA", _ds, new string[] { "Table" }, new SqlParameter("@strSQL", strSQL));
dt = _ds.Tables["Table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nServiceTypeID", "Service Type ID", 15, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription", "Description", 15, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None);
myManager = new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(repositoryItemLookUpEdit1, dt, col, "strDescription", "nServiceTypeID", "Manager");
strSQL = "select A.*,B.strDescription as ServiceTypeName from tblService A inner join tblServiceType B on A.nServiceTypeID=B.nServiceTypeID";
strSQL += " and (A.strServiceCode like '%" + txtSearch.Text + "%' or A.strDescription like '%" + txtSearch.Text + "%')";
_ds = new DataSet();
SqlHelper.FillDataset(connection, CommandType.StoredProcedure, "UP_GETDATA", _ds, new string[] { "table" }, new SqlParameter("@strSQL", strSQL));
dtService = _ds.Tables["table"];
this.gridControlMd_Service.DataSource = dtService;
}
private void LueCurso_EditValueChanged(object sender, EventArgs e)
{
if (LueCurso.EditValue != null)
{
LueMateria.Enabled = true;
codCurso = LueCurso.EditValue.ToString();
}
try
{
RegistroNota regN = new RegistroNota();
regN.Profesor.CodigoProfesor = codProfesor;
regN.Curso.CodigoCurso = codCurso;
DataTable dt2 = CtrlRegistroNotas.GetMateriasCursosProfe(regN).Tables[0];
LueMateria.Properties.DataSource = dt2;
LueMateria.Properties.DisplayMember = "Nombre";
LueMateria.Properties.ValueMember = "CodMateria";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col1;
col1 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Nombre", "Nombre", 100);
LueMateria.Properties.Columns.Clear();
LueMateria.Properties.Columns.Add(col1);
LueMateria.ItemIndex = -1;
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, Resources.AppName, MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button2);
return;
}
}
public void BindBranch(object editvalue)
{
Hashtable ht_branch = new Hashtable();
DataTable dt_branch = new DataTable();
//object obj = lookUpEdit1.EditValue;
//string comp_name = lookUpEdit1.Text;
//if (obj.ToString() != "0")
//{
// Company_Id = (int)obj;
//}
ht_branch.Clear();
dt_branch.Clear();
ht_branch.Add("@Trans", "BIND");
ht_branch.Add("@Company_Id", editvalue);
dt_branch = dataaccess.ExecuteSP("Sp_Branch", ht_branch);
DataRow dr = dt_branch.NewRow();
dr[0] = 0;
dr[1] = "SELECT";
dt_branch.Rows.InsertAt(dr, 0);
lookUpEdit2_Branch.Properties.DataSource = dt_branch;
lookUpEdit2_Branch.Properties.DisplayMember = "Branch_Name";
lookUpEdit2_Branch.Properties.ValueMember = "Branch_ID";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col;
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Branch_Name", 100);
lookUpEdit2_Branch.Properties.Columns.Add(col);
}
private void FrmLogin_Load(object sender, EventArgs e)
{
DataSet ds = CtrlPeriodos.GetPeriodoAll();
if (ds.Tables.Count > 0)
{
DataTable dt3 = ds.Tables[0];
LuePeriodo.Properties.DataSource = dt3;
LuePeriodo.Properties.DisplayMember = "Nombre";
LuePeriodo.Properties.ValueMember = "CodigoPeriodo";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col2;
col2 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Nombre", "Nombre", 100);
LuePeriodo.Properties.Columns.Add(col2);
LuePeriodo.ItemIndex = -1;
}
int[] años = new int[20];
int añoActual = DateTime.Now.Year;
int inicioCombo = añoActual - 10;
for (int i = 0; i < años.Length; i++)
{
años[i] = inicioCombo;
inicioCombo = inicioCombo + 1;
}
CmbAño.Properties.Items.AddRange(años);
CmbAño.SelectedItem = añoActual;
}
private void frmItem_Edit_Load(object sender, System.EventArgs e)
{
DataSet _ds = new DataSet();
string strSQL;
strSQL = "select strPromotionCode, strDescription from TblPromotion";
SqlHelper.FillDataset(connection, CommandType.StoredProcedure, "UP_GETDATA", _ds, new string[] { "table" }, new SqlParameter("@strSQL", strSQL));
DataTable dt = _ds.Tables["table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strPromotionCode", "Code", 15, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription", "Description", 15, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.luedtItemPromotion.Properties, dt, col, "strDescription", "strPromotionCode", "Promotion");
_ds = new DataSet();
strSQL = "Select * from TblItemPromotion Where strPromotionCode = '" + PromotionCode + "' And strCode = '" + Code + "'";
SqlHelper.FillDataset(connection, CommandType.StoredProcedure, "UP_GETDATA", _ds, new string[] { "table" }, new SqlParameter("@strSQL", strSQL));
dt = _ds.Tables["table"];
luedtItemPromotion.EditValue = dt.Rows[0]["strPromotionCode"];
CategoryTypeID.EditValue = dt.Rows[0]["nCategoryTypeID"];
GroupID.EditValue = dt.Rows[0]["nGroupID"];
BindCode(CategoryTypeID.EditValue.ToString(), GroupID.EditValue.ToString());
this.luedtCode.EditValue = dt.Rows[0]["strCode"];
}
private void FrmGetProfesorMaterias_Load(object sender, EventArgs e)
{
try
{
TxtNombreProfe.Text = NombreProfe;
ProfesorMaterias prMat = new ProfesorMaterias();
prMat.Profesor.CodigoProfesor = CodProfesor;
DataTable dt1 = new DataTable();
dt1 = CtrlProfesorMaterias.GetMateNoAsigNadas(prMat).Tables[0];
LueMateria.Properties.DataSource = dt1;
LueMateria.Properties.DisplayMember = "Nombre";
LueMateria.Properties.ValueMember = "CodMateria";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col;
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Nombre", "Nombre", 100);
LueMateria.Properties.Columns.Add(col);
LueMateria.ItemIndex = -1;
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, Resources.AppName, MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button2);
return;
}
}
private void RPStaffReport_Load(object sender, System.EventArgs e)
{
DataSet _ds = new DataSet();
string strSQL = "Select distinct year(dtDate) as Year From tblReceipt Order by year(dtDate) desc";
comboBind(this.cmbYearFrm, strSQL, "Year", "Year", true);
cmbYearFrm.SelectedIndex = 0;
comboBind(this.cmbYearTo, strSQL, "Year", "Year", true);
cmbYearTo.SelectedIndex = 0;
this.cmbMonthTo.EditValue = DateTime.Today.Month;
_ds = new DataSet();
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
new ACMS.XtraUtils.LookupEditBuilder.EmployeeIDLookupEditBuilder(luedtRPStaffSalesPerfmEmpID.Properties);
strSQL = "select * from tblCategory Where nCategoryID In (1,3,5,6,11,12)";
SqlHelper.FillDataset(connection, CommandType.StoredProcedure, "UP_GETDATA", _ds, new string[] { "table" }, new SqlParameter("@strSQL", strSQL));
DataTable dt = _ds.Tables["table"];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nCategoryID", "Id", 15, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription", "Description", 15, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.luedtRPStaffSalesPerfmCategory.Properties, dt, col, "strDescription", "nCategoryID", "Category");
LoadReport();
}
private void FrmGetImprimirPlanilla_Load(object sender, EventArgs e)
{
try
{
CursoAñoElectivo curAe = new CursoAñoElectivo();
curAe.AñoElectivo = Año;
DataTable dt2 = CtrlCursoAñoElectivo.GetCursoAñoElectivo(curAe).Tables[0];
//DataTable dt2 = CtrlCursos.GetCursoAll().Tables[0];
LueCurso.Properties.DataSource = dt2;
LueCurso.Properties.DisplayMember = "Nombre";
LueCurso.Properties.ValueMember = "CodigoCurso";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col1;
col1 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Nombre", "Nombre", 100);
LueCurso.Properties.Columns.Clear();
LueCurso.Properties.Columns.Add(col1);
LueCurso.ItemIndex = -1;
dtConsultaPeriodos = CtrlPeriodos.GetPeriodoAll().Tables[0];
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message, Resources.AppName, MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button2);
return;
}
TxtAño.Text = Año.ToString();
}
private void FillLookUpEditOrderStatus()
{
lookUpEditOrderStatus.Properties.DisplayMember = "OrderName";
lookUpEditOrderStatus.Properties.ValueMember = "ID_OrderStatus";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col;
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("OrderName", "OrderStatus", 100);
lookUpEditOrderStatus.Properties.Columns.Add(col);
lookUpEditOrderStatus.Properties.NullText = "--choose status--";
}
private void FillLookUpEditPatient()
{
lookUpEditPatient.Properties.DisplayMember = "Lastname";
lookUpEditPatient.Properties.ValueMember = "ID_Patient";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col;
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Lastname", "Patient", 100);
lookUpEditPatient.Properties.Columns.Add(col);
lookUpEditPatient.Properties.NullText = "--choose patient--";
}
private void FillLookUpEditTestName()
{
lookUpEditTestName.Properties.DisplayMember = "TestName";
lookUpEditTestName.Properties.ValueMember = "ID_Test";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col;
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("TestName", "Test", 100);
lookUpEditTestName.Properties.Columns.Add(col);
lookUpEditTestName.Properties.NullText = "--choose type--";
}
private void FillLookUpEditOrder()
{
lookUpEditOrder.Properties.DisplayMember = "ID_Order";
lookUpEditOrder.Properties.ValueMember = "ID_Order";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col;
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("ID_Order", "OrderOfPatient", 100);
lookUpEditOrder.Properties.Columns.Add(col);
lookUpEditOrder.Properties.NullText = "--choose type--";
}
private void FillLookUpEditGender()
{
lookUpEditGender.Properties.DisplayMember = "GenderName";
lookUpEditGender.Properties.ValueMember = "ID_Gender";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col;
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("GenderName", "Gender", 100);
lookUpEditGender.Properties.Columns.Add(col);
lookUpEditGender.Properties.NullText = "--choose gender--";
}
private void FillLookUpEditSpecimentStatus()
{
lookUpEditSpecimentStatus.Properties.DisplayMember = "SpecimentStatusName";
lookUpEditSpecimentStatus.Properties.ValueMember = "ID_SpecimentStatus";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col;
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("SpecimentStatusName", "SpecimentStatus", 100);
lookUpEditSpecimentStatus.Properties.Columns.Add(col);
lookUpEditSpecimentStatus.Properties.NullText = "--choose type--";
}
private void FillLookUpEditDoctor()
{
lookUpEditDoctor.Properties.DisplayMember = "Lastname";
lookUpEditDoctor.Properties.ValueMember = "ID_Doctor";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col;
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Lastname", "Doctor", 100);
lookUpEditDoctor.Properties.Columns.Add(col);
lookUpEditDoctor.Properties.NullText = "--choose doctor--";
}
public void SetupLookup()
{
lookUpEdit1.Properties.DataSource = table;
lookUpEdit1.Properties.DisplayMember = "Name";
lookUpEdit1.Properties.ValueMember = "ID";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col;
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Name", "Country", 100);
col.SortOrder = DevExpress.Data.ColumnSortOrder.Ascending;
lookUpEdit1.Properties.Columns.Add(col);
}
public OrdersUpdateXFrom(Guid id)
{
this.id = id;
InitializeComponent();
using (DataContext Db = new DataContext())
{
vehList = Db?.Vehicles?.ToList();
empList = Db?.Employees?.ToList();
//senList = Db?.SenderUsers?.ToList();
//callList = Db?.CallUsers?.ToList();
cusList = Db?.Customers?.ToList();
EmpLook.Properties.DataSource = empList;
VehicleLook.Properties.DataSource = vehList;
//SenderEmpLook.Properties.DataSource = senList;
//CallEmpLook.Properties.DataSource = callList;
CustomerLook.Properties.DataSource = cusList;
EmpLook.Properties.ValueMember = "ID";
VehicleLook.Properties.ValueMember = "ID";
//SenderEmpLook.Properties.ValueMember = "ID";
//CallEmpLook.Properties.ValueMember = "ID";
CustomerLook.Properties.ValueMember = "ID";
EmpLook.Properties.DisplayMember = "Name";
VehicleLook.Properties.DisplayMember = "Number";
//SenderEmpLook.Properties.DisplayMember = "Username";
//CallEmpLook.Properties.DisplayMember = "Username";
CustomerLook.Properties.DisplayMember = "Name";
DevExpress.XtraEditors.Controls.LookUpColumnInfo nameCol = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Name");
DevExpress.XtraEditors.Controls.LookUpColumnInfo numberCol = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Number");
DevExpress.XtraEditors.Controls.LookUpColumnInfo usernameCol = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Username");
EmpLook.Properties.Columns.Add(nameCol);
CustomerLook.Properties.Columns.Add(nameCol);
//SenderEmpLook.Properties.Columns.Add(usernameCol);
//CallEmpLook.Properties.Columns.Add(usernameCol);
VehicleLook.Properties.Columns.Add(numberCol);
var order = Db?.FinishedOrders?.SingleOrDefault(s => s.ID == id);
EarnTxt.Text = order.Earn.ToString();
OrderTxt.Text = order.Details.ToString();
LocationTxt.Text = order.Location.ToString();
EmpLook.EditValue = order.EmployeeID;
CustomerLook.EditValue = order.CustomerID;
VehicleLook.EditValue = order.VehicleID;
date.Value = order.Date;
//SenderEmpLook.EditValue = order.SenderUserID;
//CallEmpLook.EditValue = order.CallUserID;
}
}
private void LoadEmployeeList()
{
_ds = new DataSet();
strSQL = "select nEmployeeID, strEmployeeName from tblEmployee";
SqlHelper.FillDataset(connection, CommandType.StoredProcedure, "UP_GETDATA", _ds, new string[] { "Table" }, new SqlParameter("@strSQL", strSQL));
dt = _ds.Tables["Table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nEmployeeID", "Employee ID", 15, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strEmployeeName", "Name", 15, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None);
myLookUpEdit = new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(lkedtEmployee.Properties, dt, col, "strEmployeeName", "nEmployeeID", "Stock");
}
private void LoadBranchCodeList()
{
_ds = new DataSet();
strSQL = "select null [strBranchCode],'' [strBranchName] union select strBranchCode, strBranchName from tblBranch";
_ds = SqlHelperUtils.ExecuteDatasetText(strSQL, null);
//SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"Table"}, new SqlParameter("@strSQL", strSQL) );
dt = _ds.Tables["Table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strBranchCode", "Branch Code", 15, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strBranchName", "Description", 15, DevExpress.Utils.FormatType.None, "", true, DevExpress.Utils.HorzAlignment.Default, DevExpress.Data.ColumnSortOrder.None);
myLookUpEdit = new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(lkedtBranch.Properties, dt, col, "strBranchName", "strBranchCode", "Branch");
}
public EditFrm(Guid OrderID, Guid?UserID, DataContext context)
{
InitializeComponent();
TimeTxt.EditValueChanged += (sender, e) =>
{
TimeSpan now = DateTime.Now.TimeOfDay;
TimeSpan def = TimeTxt.TimeSpan - now;
afterTimeLbl.Text = "بعد " + def.Hours + " ساعة و " + def.Minutes + "دقيقة";
};
SenderUserID = (Guid)UserID;
// DataContext.ConnectionString = Settings1.Default.Connection;
try { hoursCB.SelectedIndex = 0; minCB.SelectedIndex = 30; } catch { }
List <Vehicle> vList = context?.Vehicles?.ToList();
List <Employee> eList = context?.Employees?.Where(s => s.IsBike == true)?.ToList();
MainOrder = context?.Orders.Include("Customer")?.SingleOrDefault(s => s.ID == OrderID);
isExist = MainOrder == null ? false : true;
if (isExist)
{
labelControl4.Text = MainOrder.Details + ": تفاصيل الطلب";
labelControl3.Text = MainOrder?.CustomerName + ": اسم الزبون";
labelControl2.Text = MainOrder.Location + ": الموقع";
lookUpEdit2.Properties.DataSource = vList;
lookUpEdit2.Properties.ValueMember = "ID";
lookUpEdit2.Properties.DisplayMember = "Number";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Number");
lookUpEdit2.Properties.Columns.Add(col);
lookUpEdit1.Properties.DataSource = eList;
lookUpEdit1.Properties.ValueMember = "ID";
lookUpEdit1.Properties.DisplayMember = "Name";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col2 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Name");
lookUpEdit1.Properties.Columns.Add(col2);
lookUpEdit2.EditValue = MainOrder?.VehicleID;
lookUpEdit1.EditValue = MainOrder?.EmployeeID;
earnTE.EditValue = string.IsNullOrEmpty(MainOrder?.Earn?.ToString()) ? "300" : MainOrder?.Earn?.ToString();
TimeTxt.EditValue = MainOrder.BikeTime;
// textEdit1.EditValue = MainOrder?.Timer;
if (eList.Count > 0)
{
lookUpEdit1.EditValue = eList[0].ID;
}
if (vList.Count > 0)
{
lookUpEdit2.EditValue = eList[0].VehicleID;
}
}
context.Dispose();
}
private void _LoadWebPage()
{
DataTable NhomDT = WebPage.GetActive(_Type);
lookUpEditPage.Properties.DataSource = NhomDT;
lookUpEditPage.Properties.DisplayMember = "Page";
lookUpEditPage.Properties.ValueMember = "Page";
DevExpress.XtraEditors.Controls.LookUpColumnInfo colun0 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo();
colun0.Caption = "Page";
colun0.FieldName = "Page";
lookUpEditPage.Properties.Columns.Add(colun0);
}
private void cmbBirimDoldur()
{
DevExpress.XtraEditors.Controls.LookUpColumnInfo kolon1 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo();
kolon1.Caption = "Birimi";
kolon1.FieldName = "Adi";
cmbBirim.Properties.DataSource = null;
cmbBirim.Properties.Columns.Clear();
cmbBirim.Properties.Columns.Add(kolon1);
cmbBirim.Properties.DataSource = new Stok.Services.HamMalzeme().GetAllbyStatus(true);
cmbBirim.Properties.DisplayMember = "Adi";
cmbBirim.Properties.ValueMember = "Id";
cmbBirim.Properties.DataSource = new Stok.Services.Birim().GetAll();
}
public void SetRecipients(DataTable arr)
{
lkMailTo.Properties.DataSource = arr;
lkMailTo.Properties.DisplayMember = "Email";
lkMailTo.Properties.ValueMember = "ID";
lkMailTo.Properties.Columns.Clear();
DevExpress.XtraEditors.Controls.LookUpColumnInfo colun1 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo();
colun1.Caption = "Email";
colun1.FieldName = "Email";
lkMailTo.Properties.Columns.Add(colun1);
lkMailTo.ItemIndex = 0;
//lkMailTo_EditValueChanged(null, null);
}
public void SetRecipients(DataTable arr)
{
lkMailTo.Properties.DataSource = arr;
lkMailTo.Properties.DisplayMember = "Email";
lkMailTo.Properties.ValueMember = "ID";
lkMailTo.Properties.Columns.Clear();
DevExpress.XtraEditors.Controls.LookUpColumnInfo colun1 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo();
colun1.Caption = "Email";
colun1.FieldName = "Email";
lkMailTo.Properties.Columns.Add(colun1);
lkMailTo.ItemIndex = 0;
//lkMailTo_EditValueChanged(null, null);
}
public EmployeeINFrm(string con)
{
InitializeComponent();
Connection = con;
using (DataContext Db = new DataContext())
{
lookUpEdit1.Properties.DataSource = Db.Vehicles.ToList();
lookUpEdit1.Properties.ValueMember = "ID";
lookUpEdit1.Properties.DisplayMember = "Number";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Name");
lookUpEdit1.Properties.Columns.Add(col);
}
}
public static void GroupComboListFill(studentform stdform)
{
var groupcoll = gebase.GetCollection<groupcolls>("groups");
var result = groupcoll.FindAll()
.SetFields(Fields.Include("number"))
.ToList();
stdform.stgroup.Properties.DataSource = result;
stdform.stgroup.Properties.DisplayMember = "number";
stdform.stgroup.Properties.ValueMember = "number";
stdform.stgroup.Properties.ShowHeader = false;
var col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("number", 25) { SortOrder = DevExpress.Data.ColumnSortOrder.Ascending };
stdform.stgroup.Properties.Columns.Add(col);
}
void cmbTezgahDoldur()
{
DevExpress.XtraEditors.Controls.LookUpColumnInfo kolon1 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo();
kolon1.Caption = "Marka";
kolon1.FieldName = "Marka";
DevExpress.XtraEditors.Controls.LookUpColumnInfo kolon2 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo();
kolon2.Caption = "Model";
kolon2.FieldName = "Model";
DevExpress.XtraEditors.Controls.LookUpColumnInfo kolon3 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo();
kolon3.Caption = "Seri No";
kolon3.FieldName = "SeriNo";
cmbTezgah.Properties.DataSource = null;
cmbTezgah.Properties.Columns.Clear();
cmbTezgah.Properties.Columns.Add(kolon1);
cmbTezgah.Properties.Columns.Add(kolon2);
cmbTezgah.Properties.Columns.Add(kolon3);
cmbTezgah.Properties.DataSource = new Services.Tezgah().GetAll();
cmbTezgah.Properties.DisplayMember = "Model";
cmbTezgah.Properties.ValueMember = "Id";
}
private void LoadMailSetting()
{
DataTable dtTable = MailConfig.GetAll();
lkProfile.Properties.DataSource = dtTable;
lkProfile.Properties.DisplayMember = "Code";
lkProfile.Properties.ValueMember = "ID";
lkProfile.Properties.Columns.Clear();
DevExpress.XtraEditors.Controls.LookUpColumnInfo colun1 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo();
colun1.Caption = "Code";
colun1.FieldName = "Code";
lkProfile.Properties.Columns.Add(colun1);
DevExpress.XtraEditors.Controls.LookUpColumnInfo colun2 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo();
colun2.Caption = "Mail From";
colun2.FieldName = "MailFrom";
lkProfile.Properties.Columns.Add(colun2);
DevExpress.XtraEditors.Controls.LookUpColumnInfo colun3 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo();
colun3.Caption = "Dislay Name";
colun3.FieldName = "DislayName";
lkProfile.Properties.Columns.Add(colun3);
if (dtTable.Rows.Count > 0)
{
MailConfig cf = MailConfig.GetByDefault();
if (cf != null)
{
lkProfile.EditValue = int.Parse(cf.ID.ToString());
}
else
{
lkProfile.ItemIndex = 0;
}
}
else
{
ClearFormInfo();
SetFormStatus("NEW");
}
}
private void _LoadWebPage()
{
DataTable NhomDT = WebReg.GetByType(_TypePage);
lookUpEditPage.Properties.DataSource = NhomDT;
lookUpEditPage.Properties.DisplayMember = "Page";
lookUpEditPage.Properties.ValueMember = "ID";
DevExpress.XtraEditors.Controls.LookUpColumnInfo colun0 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo();
colun0.Caption = "Page";
colun0.FieldName = "Page";
lookUpEditPage.Properties.Columns.Add(colun0);
DevExpress.XtraEditors.Controls.LookUpColumnInfo colun1 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo();
colun1.Caption = "UserName";
colun1.FieldName = "UserName";
lookUpEditPage.Properties.Columns.Add(colun1);
DevExpress.XtraEditors.Controls.LookUpColumnInfo colun2 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo();
colun2.Caption = "Password";
colun2.FieldName = "Password";
colun2.Width = 40;
lookUpEditPage.Properties.Columns.Add(colun2);
}
private void cmbYillarDoldur()
{
var kolon1 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo();
kolon1.Caption = "Yıllar";
kolon1.FieldName = "Yil";
cmbBakimYili.Properties.DataSource = null;
cmbBakimYili.Properties.Columns.Clear();
cmbBakimYili.Properties.Columns.Add(kolon1);
cmbBakimYili.Properties.DataSource = new Services.Raporlama().GetBakimYillari();
cmbBakimYili.Properties.DisplayMember = "Yil";
cmbBakimYili.Properties.ValueMember = "Yil";
}
private void Init_Master_lookUp()
{
DataSet mds = new DataSet();
lk_MasterData.Properties.DataSource = "";
lk_MasterData.Properties.Columns.Clear();
string strSQL = "select * from tblMasterData where fShow=0 order by pkMasterData";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",mds,new string[] {"Table"}, new SqlParameter("@strSQL", strSQL) );
DataTable dtMaster = mds.Tables["Table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("pkMasterData","Screen ID",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.lk_MasterData.Properties,dtMaster,col,"strDescription","pkMasterData","Master Data");
}
private void Init_cmb_Type()
{
DataSet _ds = new DataSet();
string strSQL;
string strType=cmb_Type.Text;
strSQL = "select str" + strType + "Code , strDescription from Tbl" + strType + "";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
DataTable dt = _ds.Tables["table"];
luedtItem.Properties.DataSource = "";
luedtItem.Properties.Columns.Clear();
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("str" + strType + "Code","Code",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.luedtItem.Properties, dt, col, "strDescription", "str" + strType + "Code", strType);
}
private void cmbHamMalzemeDoldur()
{
DevExpress.XtraEditors.Controls.LookUpColumnInfo kolon1 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo();
DevExpress.XtraEditors.Controls.LookUpColumnInfo kolon2 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo();
kolon2.Caption = "Malzeme Adı";
kolon2.FieldName = "Adi";
kolon1.Caption = "Stok Kodu";
kolon1.FieldName = "No";
cmbSarjHamMalzeme.Properties.DataSource = null;
cmbSarjHamMalzeme.Properties.Columns.Clear();
cmbSarjHamMalzeme.Properties.Columns.Add(kolon1);
cmbSarjHamMalzeme.Properties.Columns.Add(kolon2);
cmbSarjHamMalzeme.Properties.DataSource = new Stok.Services.HamMalzeme().GetAllbyStatus(true);
cmbSarjHamMalzeme.Properties.DisplayMember = "No";
cmbSarjHamMalzeme.Properties.ValueMember = "Id";
cmbHamMalzeme.Properties.DataSource = null;
cmbHamMalzeme.Properties.Columns.Clear();
cmbHamMalzeme.Properties.Columns.Add(kolon1);
cmbHamMalzeme.Properties.Columns.Add(kolon2);
cmbHamMalzeme.Properties.DataSource = new Stok.Services.HamMalzeme().GetAllbyStatus(true);
cmbHamMalzeme.Properties.DisplayMember = "No";
cmbHamMalzeme.Properties.ValueMember = "Id";
}
private void load_EmployeeList()
{
DataSet _ds = new DataSet();
string strSQL;
strSQL = "select nEmployeeID, strEmployeeName from TblEmployee where nStatusID=1 and fSalesPerson=1";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
DataTable dt = _ds.Tables["table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nEmployeeID","ID",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strEmployeeName","Employee Name",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
//new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.luedtItemPromotion.Properties, dt, col, "strDescription", "strPromotionCode", "Promotion");
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.lk_Employee.Properties,dt,col,"strEmployeeName","nEmployeeID","Employee Name");
}
void BindGuarantor()
{
GuarantorFinancerManager oManager = new GuarantorFinancerManager();
DataTable dtGuarantor = new DataTable();
oManager.ConnectionString = this.ConnectionString;
oManager.Open();
dtGuarantor = oManager.GetGuarantorInfo();
oManager.Close();
cboGuarantorFinancer.Properties.DataSource = dtGuarantor;
cboGuarantorFinancer.Properties.DisplayMember = "GuarantorFinancerName";
cboGuarantorFinancer.Properties.ValueMember = "GuarantorFinancerName";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col;
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("GuarantorFinancerCode", "Code", 100);
cboGuarantorFinancer.Properties.Columns.Add(col);
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("GuarantorFinancerName", "Name", 100);
cboGuarantorFinancer.Properties.Columns.Add(col);
cboGuarantorFinancer.Refresh();
}
private void lk_CalMethod_Init()
{
DataSet _ds = new DataSet();
string strSQL;
strSQL = "select * from tblCommCalculation";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
DataTable dt = _ds.Tables["table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nCalMethod","Method ID",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(lk_CalMethod,dt,col,"strDescription","nCalMethod","Method");
}
private void mdPromotionInit()
{
DataSet _ds = new DataSet();
string strSQL;
string Condition = "";
strSQL = "select * from tblDiscountCategory";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
DataTable dt = _ds.Tables["table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nDiscountCategoryID","Discount Category Id",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(lk_DiscountCategory,dt,col,"strDescription","nDiscountCategoryID","Discount Category");
strSQL = "select * from tblPromotion where strPromotionCode like '%" + txtSearch.Text + "%' or strDescription like '%" + txtSearch.Text +"%'";
_ds = new DataSet();
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
dtPromotion = _ds.Tables["table"];
gridControlMd_Promotion.DataSource = dtPromotion;
strSQL = "select strPackageCode,strDescription from (select strPackageCode,strDescription from tblPackage Where strPackageCode Not In (Select strPackageCode From tblPromotionPackage Where strPromotionCode = '" + txtSearch.Text + "') union select strCreditPackageCode as strPackageCode,strDescription from tblCreditPackage Where strCreditPackageCode Not In (Select strPackageCode From tblPromotionPackage Where strPromotionCode = '" + txtSearch.Text + "')) t";
if (this.txtPcItemCode.EditValue.ToString() != "")
Condition = " strPackageCode like '%" + this.txtPcItemCode.EditValue + "%' And";
if (this.txtPcItemDesc.EditValue.ToString() != "")
Condition += " strDescription like '%" + this.txtPcItemDesc.EditValue + "%' And";
if (Condition != "")
strSQL = strSQL + " WHERE " + Condition.Substring(0, Condition.Length - 4);
_ds = new DataSet();
SqlHelper.FillDataset(connection, CommandType.StoredProcedure, "UP_GETDATA", _ds, new string[] { "table" }, new SqlParameter("@strSQL", strSQL));
gdPackage.DataSource = _ds.Tables["table"];
strSQL = "select A.strPackageCode,strDescription,nMaxQty from tblPromotionPackage A join tblPackage B on A.strPackageCode=B.strPackageCode where strPromotionCode='" + txtSearch.Text + "' union select A.strPackageCode,strDescription,nMaxQty from tblPromotionPackage A join tblCreditPackage B on A.strPackageCode=B.strCreditPackageCode where strPromotionCode='" + txtSearch.Text + "'";
if (this.txtPcItemCode.EditValue.ToString() != "")
Condition = " B.strPackageCode like '%" + this.txtSearch.Text + "%' And";
if (this.txtPcItemDesc.EditValue.ToString() != "")
Condition += " B.strDescription like '%" + this.txtSearch.Text + "%' And";
if (Condition != "")
strSQL = strSQL + " And " + Condition.Substring(0, Condition.Length - 4);
_ds = new DataSet();
SqlHelper.FillDataset(connection, CommandType.StoredProcedure, "UP_GETDATA", _ds, new string[] { "table" }, new SqlParameter("@strSQL", strSQL));
dtPackage = _ds.Tables["table"];
gdPackage2.DataSource = dtPackage;
}
private void mdPromotionInit()
{
DataSet _ds = new DataSet();
string strSQL;
strSQL = "select * from tblDiscountCategory";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
DataTable dt = _ds.Tables["table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nDiscountCategoryID","Discount Category Id",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(lk_DiscountCategory,dt,col,"strDescription","nDiscountCategoryID","Discount Category");
strSQL = "select * from tblPromotion where strPromotionCode like '%" + txtSearch.Text + "%' or strDescription like '%" + txtSearch.Text +"%'";
_ds = new DataSet();
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
dtPromotion = _ds.Tables["table"];
gridControlMd_Promotion.DataSource = dtPromotion;
}
private void frmItem_Edit_Load(object sender, System.EventArgs e)
{
DataSet _ds = new DataSet();
string strSQL;
strSQL = "select strPromotionCode, strDescription from TblPromotion";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
DataTable dt = _ds.Tables["table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strPromotionCode","Code",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.luedtItemPromotion.Properties, dt, col, "strDescription", "strPromotionCode", "Promotion");
_ds = new DataSet();
strSQL = "Select * from TblItemPromotion Where strPromotionCode = '" + PromotionCode + "' And strCode = '" + Code + "'";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
dt = _ds.Tables["table"];
luedtItemPromotion.EditValue = dt.Rows[0]["strPromotionCode"];
CategoryTypeID.EditValue = dt.Rows[0]["nCategoryTypeID"];
GroupID.EditValue = dt.Rows[0]["nGroupID"];
BindCode(CategoryTypeID.EditValue.ToString(),GroupID.EditValue.ToString());
this.luedtCode.EditValue = dt.Rows[0]["strCode"];
}
void BindPayDayCode()
{
PayDayCodeManager oManager = new PayDayCodeManager();
DataTable dtLines = new DataTable();
oManager.ConnectionString = this.ConnectionString;
oManager.Open();
dtLines = oManager.GetPayDayCodeHeader();
cboPayDayCode.Properties.DataSource = dtLines;
cboPayDayCode.Properties.DisplayMember = "Remarks";
cboPayDayCode.Properties.ValueMember = "PayDayCode";
DevExpress.XtraEditors.Controls.LookUpColumnInfo col;
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("PayDayCode", "Code", 100);
cboPayDayCode.Properties.Columns.Add(col);
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("Remarks", "Name", 100);
cboPayDayCode.Properties.Columns.Add(col);
cboPayDayCode.Refresh();
oManager.Close();
}
private void frmNewActivities_Load(object sender, System.EventArgs e)
{
DataSet _ds = new DataSet();
string strSQL;
strSQL = "select * from tblCourse where fValid=0";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
DataTable dt = _ds.Tables["table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nCourseID","Course ID",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
//new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.luedtItemPromotion.Properties, dt, col, "strDescription", "strPromotionCode", "Promotion");
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.lk_ActCourse.Properties,dt,col,"strDescription","nCourseID","Course Selection");
}
private void BindCode(string CatID, string GroupID)
{
DataSet _ds = new DataSet();
string strSQL;
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
lk_Code.DataSource = "";
if (CatID == "1" && GroupID == "0")
{
strSQL = "select strProductCode as strCode, strDescription from TblProduct";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
DataTable dt = _ds.Tables["table"];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strCode","Code",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.lk_Code, dt, col, "strDescription", "strCode", "Product");
}
else if (CatID == "1" && GroupID == "1")
{
strSQL = "select nProductTypeID as strCode, strDescription from TblProductType";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
DataTable dt = _ds.Tables["table"];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strCode","Product Type",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.lk_Code, dt, col, "strDescription", "strCode", "Product Type");
}
else if (CatID == "2" && GroupID == "0")
{
strSQL = "select strPackageCode as strCode, strDescription From tblPackage";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
DataTable dt = _ds.Tables["table"];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strCode","Code",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.lk_Code, dt, col, "strDescription", "strCode", "Package");
}
else if (CatID == "2" && GroupID == "1")
{
strSQL = "select nCategoryID as strCode, strDescription From tblCategory";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
DataTable dt = _ds.Tables["table"];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strCode","Code",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.lk_Code, dt, col, "strDescription", "strCode", "Package");
}
else if (CatID == "3" && GroupID == "0")
{
strSQL = "select strPackageGroupCode as strCode, strDescription From tblpackagegroup";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
DataTable dt = _ds.Tables["table"];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strCode","Code",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.lk_Code, dt, col, "strDescription", "strCode", "Package Group");
}
else if (CatID == "3" && GroupID == "1")
{
strSQL = "select distinct tblpackagegroup.ncategoryid as strCode, tblpackagegroup.strDescription from tblpackagegroup Inner Join TblCategory On TblCategory.nCategoryID = TblPackageGroup.nCategoryID";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
DataTable dt = _ds.Tables["table"];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strCode","Id",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.lk_Code, dt, col, "strDescription", "strCode", "Category");
}
else if (CatID == "4" && GroupID == "0")
{
strSQL = "select strCreditPackageCode as strCode, strDescription from tblcreditpackage";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
DataTable dt = _ds.Tables["table"];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strCode","Code",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.lk_Code, dt, col, "strDescription", "strCode", "Credit Package");
}
else if (CatID == "4" && GroupID == "1")
{
strSQL = "select distinct tblCreditPackage.ncategoryid as strCode, tblCreditPackage.strDescription from tblCreditPackage Inner Join TblCategory On TblCategory.nCategoryID = tblCreditPackage.nCategoryID";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
DataTable dt = _ds.Tables["table"];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strCode","Id",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.lk_Code, dt, col, "strDescription", "strCode", "Category");
}
}
private void _LoadWebPage()
{
DataTable NhomDT = WebPage.GetActive(_Type);
lookUpEditPage.Properties.DataSource = NhomDT;
lookUpEditPage.Properties.DisplayMember = "Page";
lookUpEditPage.Properties.ValueMember = "Page";
DevExpress.XtraEditors.Controls.LookUpColumnInfo colun0 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo();
colun0.Caption = "Page";
colun0.FieldName = "Page";
lookUpEditPage.Properties.Columns.Add(colun0);
}
private void frmPromotionItem_Load(object sender, System.EventArgs e)
{
DataSet _ds = new DataSet();
string strSQL;
strSQL = "select strPromotionCode, strDescription from TblPromotion";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
DataTable dt = _ds.Tables["table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strPromotionCode","Code",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.lk_PromotionCode, dt, col, "strDescription", "strPromotionCode", "Promotion");
BindGrid();
DataRow row = this.gridViewMd_ItemPromotion.GetDataRow(gridViewMd_ItemPromotion.FocusedRowHandle);
BindCode(row["nCategoryTypeID"].ToString(),row["nGroupID"].ToString());
}
private void LoadClassTypeList()
{
_ds = new DataSet();
strSQL = "select null [nClassTypeID],'' [strDescription] union select nClassTypeID, strDescription from tblClassType";
_ds = SqlHelperUtils.ExecuteDatasetText(strSQL,null);
//SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"Table"}, new SqlParameter("@strSQL", strSQL) );
dt = _ds.Tables["Table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nClassTypeID","Class Type",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
myLookUpEdit = new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(lkedtClassType.Properties,dt,col,"strDescription","nClassTypeID","ClassType");
}
private void BindCombo()
{
DataTable dt;
string strSQL = "select * from tblEmployee";
DataSet _ds = new DataSet();
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
dt = _ds.Tables["table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nEmployeeID","Employee Id",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strEmployeeName","Employee Name",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(lk_EmployeeID,dt,col,"strEmployeeName","nEmployeeID","Manager");
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.lk_RightLevelEmployeeID,dt,col,"strEmployeeName","nEmployeeID","Manager");
strSQL = "select strBranchCode, strBranchName from tblBranch";
_ds = new DataSet();
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
dt = _ds.Tables["table"];
myBranch = new ACMS.XtraUtils.LookupEditBuilder.BranchCodeLookupEditBuilder(dt,lk_BranchID);
strSQL = "select nRightsID, strDescription from tblRights";
_ds = new DataSet();
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
dt = _ds.Tables["table"];
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nRightsID","Rights Id",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.lk_Rights,dt,col,"strDescription","nRightsID","Rights");
strSQL = "select nRightsLevelID, strDescription from tblRightsLevel";
_ds = new DataSet();
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
dt = _ds.Tables["table"];
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nRightsLevelID","Rights Level Id",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.lk_RightsLevel,dt,col,"strDescription","nRightsLevelID","Rights");
}
private void LoadInstructorList()
{
_ds = new DataSet();
strSQL = "select null [nEmployeeID],'' [strEmployeeName] union select nEmployeeID, strEmployeeName from tblEmployee where fInstructor=1 order by strEmployeeName";
_ds.Tables.Add("Table");
_ds = SqlHelperUtils.ExecuteDatasetText(strSQL,null);
//(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"Table"}, new SqlParameter("@strSQL", strSQL) );
dt = _ds.Tables["Table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nEmployeeID","Employee ID",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strEmployeeName","Name",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
myLookUpEdit = new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(lkedtInstructor.Properties,dt,col,"strEmployeeName","nEmployeeID","Instructor");
}
private void mdInstructorTypeCommissionInit()
{
DataTable dt;
DataSet _ds;
_ds = new DataSet();
string strSQL = "select * from tblInstructorCommission";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"Table"}, new SqlParameter("@strSQL", strSQL) );
dt = _ds.Tables["Table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nCommissionTypeID","Commission Type ID",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
myManager = new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(repositoryItemLookUpEdit2,dt,col,"strDescription","nCommissionTypeID","Manager");
_ds = new DataSet();
strSQL = "select * from tblInstructorType";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"Table"}, new SqlParameter("@strSQL", strSQL) );
dt = _ds.Tables["Table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col1 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col1[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nInstructorTypeID","Instructor Type ID",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col1[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
myManager = new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(repositoryItemLookUpEdit1,dt,col1,"strDescription","nInstructorTypeID","Manager");
strSQL = "select A.*,B.strDescription as strITDescription, C.strDescription as strCommDescription from tblInstructorTypeCommission A join tblInstructorType B on A.nInstructorTypeID=B.nInstructorTypeID join tblInstructorCommission C on A.nCommissionTypeID=C.nCommissionTypeID";
_ds = new DataSet();
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
dtInstructorCommission=_ds.Tables["table"];
gridControlMd_InstructorTypeCommission.DataSource = dtInstructorCommission;
}
private void lookup_Report(int ReportID)
{
DataSet mdr = new DataSet();
lk_ReportView.Properties.DataSource = "";
lk_ReportView.Properties.Columns.Clear();
string strSQL = "select * from tblReportView where nReportID=" + ReportID +" and fShow=0 order by nReportID,strReportCode";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",mdr,new string[] {"Table"}, new SqlParameter("@strSQL", strSQL));
DataTable dtMaster = mdr.Tables["Table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strReportCode","Screen ID",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strReportName","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.lk_ReportView.Properties,dtMaster,col,"strReportName","strReportCode","Report");
}
private void frmPackage_Load(object sender, System.EventArgs e)
{
DataSet _ds = new DataSet();
string strSQL;
//strSQL = "select * from tblcategory where strDescription in ('Fitness Package','Fitness GIRO','PT Package','SPA Package','SPA Single Treatment','IPL Package','Courses & Events','Others','Spa Credit Package','Spa Credit Account','Fitness Combo Package','SPA Combo Package','Spa GIRO','Amore Holistic Credit')";
strSQL = "select * from tblcategory where strDescription in ('Fitness Package','Fitness GIRO','PT Package','SPA Package','SPA Single Treatment','IPL Package','Courses & Events','Others','Spa Credit Package','Spa Credit Account','Fitness Combo Package','SPA Combo Package','Spa GIRO','Holistic Fitness','Holistic Spa')";
comboBind(ddlPackageCategory,strSQL,"strDescription","nCategoryID");
strSQL = "select * from tblcategory where strDescription in ('Fitness Package','Fitness GIRO','PT Package','SPA Package','SPA Single Treatment','IPL Package','Courses & Events','Others','Spa Credit Account','Spa GIRO')";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
DataTable dt = _ds.Tables["table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nCategoryID","Category Id",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.lk_Category, dt, col, "strDescription", "nCategoryID", "Category");
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.lk_CreditCategoryID, dt, col, "strDescription", "nCategoryID", "Category");
strSQL = "select * from tblcategory where strDescription in ('Fitness Combo Package','SPA Combo Package')";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
dt = _ds.Tables["table"];
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nCategoryID","Category Id",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(this.lk_pkGroupCatID,dt,col,"strDescription","nCategoryID","Category");
strSQL = "select strPackageCode, strDescription from TblPackage";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
dt = _ds.Tables["table"];
col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strPackageCode","Package Code",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(lk_PackageCode,dt,col,"strDescription","strPackageCode","Package Code");
new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(lk_GrpPackageCode,dt,col,"strDescription","strPackageCode","Package Code");
LoadPackage();
}
private void mdServiceInit()
{
fMode="N";
string strSQL;
//strSQL = "select * from tblServiceType";
//comboBind(mdSV_cbNServiceTypeID,strSQL,"strDescription","nServiceTypeID",true);
DataTable dt;
DataSet _ds;
_ds = new DataSet();
strSQL = "select * from tblServiceType";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"Table"}, new SqlParameter("@strSQL", strSQL) );
dt = _ds.Tables["Table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nServiceTypeID","Service Type ID",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strDescription","Description",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
myManager = new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(repositoryItemLookUpEdit1,dt,col,"strDescription","nServiceTypeID","Manager");
strSQL = "select A.*,B.strDescription as ServiceTypeName from tblService A inner join tblServiceType B on A.nServiceTypeID=B.nServiceTypeID";
strSQL += " and (A.strServiceCode like '%" + txtSearch.Text + "%' or A.strDescription like '%" + txtSearch.Text + "%')";
_ds = new DataSet();
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"table"}, new SqlParameter("@strSQL", strSQL) );
dtService=_ds.Tables["table"];
this.gridControlMd_Service.DataSource = dtService;
}
private void cmbMusteriDoldur()
{
DevExpress.XtraEditors.Controls.LookUpColumnInfo kolon1 = new DevExpress.XtraEditors.Controls.LookUpColumnInfo();
kolon1.Caption = "Firmalar";
kolon1.FieldName = "Adi";
cmbMusteri.Properties.DataSource = null;
cmbMusteri.Properties.Columns.Clear();
cmbMusteri.Properties.Columns.Add(kolon1);
cmbMusteri.Properties.DataSource = new Stok.Services.Musteri().GetAllbyStatus(true);
cmbMusteri.Properties.DisplayMember = "Adi";
cmbMusteri.Properties.ValueMember = "Id";
}
private void LoadEmployeeList()
{
_ds = new DataSet();
strSQL = "select nEmployeeID, strEmployeeName from tblEmployee";
SqlHelper.FillDataset(connection,CommandType.StoredProcedure,"UP_GETDATA",_ds,new string[] {"Table"}, new SqlParameter("@strSQL", strSQL) );
dt = _ds.Tables["Table"];
DevExpress.XtraEditors.Controls.LookUpColumnInfo[] col = new DevExpress.XtraEditors.Controls.LookUpColumnInfo[2];
col[0] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("nEmployeeID","Employee ID",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
col[1] = new DevExpress.XtraEditors.Controls.LookUpColumnInfo("strEmployeeName","Name",15,DevExpress.Utils.FormatType.None,"",true,DevExpress.Utils.HorzAlignment.Default,DevExpress.Data.ColumnSortOrder.None);
myLookUpEdit = new ACMS.XtraUtils.LookupEditBuilder.CommonLookupEditBuilder(lkedtEmployee.Properties,dt,col,"strEmployeeName","nEmployeeID","Stock");
}