query(2)

public static DataTable GetvwEmploteesHave(string departmentName)
{
Query q = DAL.VwEmplotee.CreateQuery();
if (departmentName != "全部")
{
q.AddWhere(DAL.VwEmplotee.Columns.DepartmentName, departmentName);
}
object[] employees = new object[] { "销售代表", "销售助理","工程师","部门经理" }; q.IN(DAL.VwEmplotee.Columns.RoleName, employees);
q.ORDER_BY(DAL.VwEmplotee.Columns.CreateDate, "ASC");
string SQL = q.GetSql();
DataTable dt = q.ExecuteDataSet().Tables[0];
return dt;
}
public DataTable GetCountByArticleName(string articleName)
{
Query q = StockIn.CreateQuery();
q.AddWhere(StockIn.Columns.ArticleName, articleName);
q.AddWhere(StockIn.Columns.Deleted, Comparison.NotEquals, true);
q.AddWhere(StockIn.Columns.Remain, Comparison.GreaterThan, 0);
q.ORDER_BY(StockIn.Columns.StockInId, "ASC");
return q.ExecuteDataSet().Tables[0];
}
///<summary>
///获取部门ParentId= 1
///</summary>
///<returns>DataTable</returns>
public static DataTable GetDepartment()
{
Query q = DAL.Department.CreateQuery();
q.AddWhere(DAL.Department.Columns.Deleted, false);
q.AddWhere(DAL.Department.Columns.ParentId, 1);//顶层为1
q.ORDER_BY(DAL.Department.Columns.DepartmentCode, "ASC");
return q.ExecuteDataSet().Tables[0];
}
//<summary>
///根据DepartmentId获取Department
///</summary>
///<param name="id">DepartmentId</param>
///<returns>Department</returns>
public static Department GetDepartmentById(string id)
{
Supplies.DAL.Department department = new Supplies.DAL.Department(id);
Department dept = new Department();
dept.DepartmentId = department.DepartmentId;
dept.DepartmentName = department.DepartmentName;
dept.DepartmentCode = department.DepartmentCode;
dept.ParentId = department.ParentId;
dept.TopId = int.Parse(Common.GetRowValue(department.TopId));
dept.State = department.State;
dept.Deleted = department.Deleted;
return dept;
}
///<summary>
///检测部门是否在使用，在使用true，没使用false
///</summary>
///<param name="departmentId"></param>
///<returns></returns>
public static bool ChechDepartmentUse(int departmentId)
{
Query q = DAL.StockIn.CreateQuery();
q.AddWhere(DAL.StockIn.Columns.SectionId, departmentId);
q.AddWhere(DAL.StockIn.Columns.Deleted, false);
int n = q.GetCount(DAL.StockIn.Columns.SectionId);
q = DAL.StockOut.CreateQuery();
q.AddWhere(DAL.StockOut.Columns.SectionId, departmentId);
q.AddWhere(DAL.StockOut.Columns.Deleted, false);
int m = q.GetCount(DAL.StockOut.Columns.SectionId);
if (n > 0 || m > 0)
{
return true;
}
else
{
return false;
}
}
like 查询Comparison
public static DataTable GetContractDataByNumber(string number)
{
Query q = DAL.VwContract.CreateQuery();
if(!String.IsNullOrEmpty(number)){
q.AddWhere(DAL.VwContract.Columns.Number, Comparison.Like, number + "%"); }
q.ORDER_BY(DAL.VwContract.Columns.ContractDate, "DESC");
DataTable dt = q.ExecuteDataSet().Tables[0];
return dt;
}
or 查询
public static String[] salemgr()
{
Query salemgr = DAL.Employee.CreateQuery();
salemgr.AddWhere(DAL.Employee.Columns.Job, "销售经理
").OR(DAL.Employee.Columns.Job,"销售代表");
salemgr.SelectList = DAL.Employee.Columns.RealName;
DataTable tb = salemgr.ExecuteDataSet().Tables[0];
String[] mgr = new String[tb.Rows.Count];
for (int i = 0; i < tb.Rows.Count; i++)
{
mgr[i] = tb.Rows[i][0].ToString();
}
return mgr;
}
count==============
/// <summary>
/// 共有多少国家孵化器
/// </summary>
/// <returns></returns>
public int countNumberContry()
{
Query q = DAL.Incubator.CreateQuery();
q.AddWhere(DAL.Incubator.Columns.IncLevel, "国家级孵化器");
int count = q.GetCount(DAL.Incubator.Columns.IncubatorId);
return count;
}。