/// <summary>
/// 根据查询条件构造查询语句
/// </summary>
private string GetConditionSql()
{
//如果存在高级查询对象信息，则使用高级查询条件，否则使用主表条件查询
SearchCondition condition = advanceCondition;
if (condition == null)
{
condition = new SearchCondition();
condition.AddDateCondition("NG替换时间", this.txtNg替换时间1, this.txtNg替换时间2); //日期类型
condition.AddCondition("物料生产批次号", this.txt物料生产批次号.Text.Trim(), SqlOperator.Like);
condition.AddNumericCondition("设备ID", this.txt设备id1, this.txt设备id2); //数值类型
condition.AddCondition("设备名称", this.txt设备名称.Text.Trim(), SqlOperator.Like);
condition.AddCondition("工位号", this.txt工位号.Text.Trim(), SqlOperator.Like);
condition.AddCondition("物料GUID", this.txt物料guid.Text.Trim(), SqlOperator.Like);
condition.AddCondition("替换前治具GUID", this.txt替换前治具guid.Text.Trim(), SqlOperator.Like);
condition.AddCondition("替换前治具RFID", this.txt替换前治具rfid.Text.Trim(), SqlOperator.Like);
condition.AddNumericCondition("替换前治具孔号", this.txt替换前治具孔号1, this.txt替换前治具孔号2); //数值类型
condition.AddCondition("前治具生产批次号", this.txt前治具生产批次号.Text.Trim(), SqlOperator.Like);
condition.AddCondition("替换后治具GUID", this.txt替换后治具guid.Text.Trim(), SqlOperator.Like);
condition.AddCondition("替换后治具RFID", this.txt替换后治具rfid.Text.Trim(), SqlOperator.Like);
condition.AddNumericCondition("替换后治具孔号", this.txt替换后治具孔号1, this.txt替换后治具孔号2); //数值类型
condition.AddCondition("后治具生产批次号", this.txt后治具生产批次号.Text.Trim(), SqlOperator.Like);
}
string where = condition.BuildConditionSql().Replace("Where", "");
return(where);
}
/// <summary>
/// 根据查询条件构造查询语句
/// </summary>
private string GetConditionSql()
{
//如果存在高级查询对象信息，则使用高级查询条件，否则使用主表条件查询
SearchCondition condition = new SearchCondition();
condition.AddCondition("LoginName", this.txtLoginName.Text.Trim(), SqlOperator.Like);
condition.AddCondition("TableName", this.txtTableName.Text.Trim(), SqlOperator.Like);
condition.AddCondition("OperationType", this.txtOperationType.Text.Trim(), SqlOperator.Like);
condition.AddDateCondition("CreateTime", this.txtCreateTime1, this.txtCreateTime2); //日期类型
//如果是公司管理员，增加公司标识
if (Portal.gc.UserInRole(RoleInfo.CompanyAdminName))
{
condition.AddCondition("Company_ID", Portal.gc.UserInfo.Company_ID, SqlOperator.Equal);
}
string where = condition.BuildConditionSql().Replace("Where", "");
//如果是单击节点得到的条件，则使用树列表的，否则使用查询条件的
if (!string.IsNullOrEmpty(treeConditionSql))
{
where = treeConditionSql;
}
// 增加系统可以访问的公司部门的权限
where += " and (Company_ID " + canOptCompanyID + ")";
return(where);
}
/// <summary>
/// 根据查询条件构造查询语句
/// </summary>
private string GetConditionSql()
{
//如果存在高级查询对象信息，则使用高级查询条件，否则使用主表条件查询
SearchCondition condition = advanceCondition;
if (condition == null)
{
condition = new SearchCondition();
condition.AddCondition("CardID", this.txtCardID.Text.Trim(), SqlOperator.Like);
condition.AddCondition("CarNo", this.txtCarNo.Text.Trim(), SqlOperator.Like);
condition.AddCondition("TransportUnit", this.txtTransportUnit.Text.Trim(), SqlOperator.Like);
condition.AddDateCondition("RegisterTime", this.txtRegisterTime1, this.txtRegisterTime2); //日期类型
condition.AddDateCondition("ExpireTime", this.txtExpireTime1, this.txtExpireTime2); //日期类型
}
string where = condition.BuildConditionSql().Replace("Where", "");
return(where);
}
/// <summary>
/// 根据查询条件构造查询语句
/// </summary>
private string GetConditionSql()
{
//如果存在高级查询对象信息，则使用高级查询条件，否则使用主表条件查询
SearchCondition condition = advanceCondition;
if (condition == null)
{
condition = new SearchCondition();
condition.AddDateCondition("时间", this.txt时间1, this.txt时间2); //日期类型
condition.AddCondition("班次", this.txt班次.Text.Trim(), SqlOperator.Like);
condition.AddCondition("组装线体号", this.txt组装线体号.Text.Trim(), SqlOperator.Like);
condition.AddCondition("机种", this.txt机种.Text.Trim(), SqlOperator.Like);
condition.AddDateCondition("镜框日期", this.txt镜框日期1, this.txt镜框日期2); //日期类型
condition.AddCondition("镜筒模穴号", this.txt镜筒模穴号.Text.Trim(), SqlOperator.Like);
condition.AddCondition("镜框批次", this.txt镜框批次.Text.Trim(), SqlOperator.Like);
condition.AddCondition("穴号105", this.txt穴号105.Text.Trim(), SqlOperator.Like);
condition.AddCondition("穴号104", this.txt穴号104.Text.Trim(), SqlOperator.Like);
condition.AddCondition("穴号102", this.txt穴号102.Text.Trim(), SqlOperator.Like);
condition.AddDateCondition("日期105", this.txt日期1051, this.txt日期1052); //日期类型
condition.AddDateCondition("日期104", this.txt日期1041, this.txt日期1042); //日期类型
condition.AddDateCondition("日期102", this.txt日期1021, this.txt日期1022); //日期类型
condition.AddCondition("角度", this.txt角度.Text.Trim(), SqlOperator.Like);
condition.AddCondition("系列号", this.txt系列号.Text.Trim(), SqlOperator.Like);
condition.AddNumericCondition("镜框投料数", this.txt镜框投料数1, this.txt镜框投料数2); //数值类型
condition.AddCondition("隔圈模穴号113B", this.txt隔圈模穴号113b.Text.Trim(), SqlOperator.Like);
condition.AddDateCondition("成型日113B", this.txt成型日113b1, this.txt成型日113b2); //日期类型
condition.AddCondition("隔圈模穴号112", this.txt隔圈模穴号112.Text.Trim(), SqlOperator.Like);
condition.AddDateCondition("成型日112", this.txt成型日1121, this.txt成型日1122); //日期类型
condition.AddNumericCondition("隔圈投料数", this.txt隔圈投料数1, this.txt隔圈投料数2); //数值类型
condition.AddCondition("G3来料供应商", this.txtG3来料供应商.Text.Trim(), SqlOperator.Like);
condition.AddDateCondition("G3镜片来料日期", this.txtG3镜片来料日期1, this.txtG3镜片来料日期2); //日期类型
condition.AddCondition("G1来料供应商", this.txtG1来料供应商.Text.Trim(), SqlOperator.Like);
condition.AddDateCondition("G1来料日期", this.txtG1来料日期1, this.txtG1来料日期2); //日期类型
condition.AddNumericCondition("镜片105投料数", this.txt镜片105投料数1, this.txt镜片105投料数2); //数值类型
condition.AddNumericCondition("镜片104投料数", this.txt镜片104投料数1, this.txt镜片104投料数2); //数值类型
condition.AddNumericCondition("镜片G3投料数", this.txt镜片g3投料数1, this.txt镜片g3投料数2); //数值类型
condition.AddNumericCondition("镜片102投料数", this.txt镜片102投料数1, this.txt镜片102投料数2); //数值类型
condition.AddNumericCondition("镜片95B投料数", this.txt镜片95b投料数1, this.txt镜片95b投料数2); //数值类型
condition.AddCondition("配对监控批次", this.txt配对监控批次.Text.Trim(), SqlOperator.Like);
condition.AddNumericCondition("计划投入数", this.txt计划投入数1, this.txt计划投入数2); //数值类型
condition.AddNumericCondition("上线数", this.txt上线数1, this.txt上线数2); //数值类型
condition.AddNumericCondition("下线数", this.txt下线数1, this.txt下线数2); //数值类型
condition.AddCondition("状态", this.txt状态.Text.Trim(), SqlOperator.Like);
condition.AddCondition("生产批次号", this.txt生产批次号.Text.Trim(), SqlOperator.Like);
}
string where = condition.BuildConditionSql().Replace("Where", "");
return(where);
}
/// <summary>
/// 根据查询条件构造查询语句
/// </summary>
private string GetConditionSql()
{
//如果存在高级查询对象信息，则使用高级查询条件，否则使用主表条件查询
SearchCondition condition = advanceCondition;
if (condition == null)
{
condition = new SearchCondition();
condition.AddCondition("CarNo", this.txtCarNo.Text.Trim(), SqlOperator.Like);
condition.AddCondition("CardID", this.txtCardID.Text.Trim(), SqlOperator.Like);
condition.AddCondition("MZ_BalanceNo", this.txtMZ_BalanceNo.Text.Trim(), SqlOperator.Like);
condition.AddDateCondition("MZ_Time", this.txtMZ_Time1, this.txtMZ_Time2); //日期类型
condition.AddCondition("PZ_BalanceNo", this.txtPZ_BalanceNo.Text.Trim(), SqlOperator.Like);
condition.AddDateCondition("PZ_Time", this.txtPZ_Time1, this.txtPZ_Time2); //日期类型
//condition.AddDateCondition("MZ_Time", this.txtMZ_Time1.Text.ToString(), this.txtMZ_Time2.Text.ToString()); //日期类型
}
string where = condition.BuildConditionSql().Replace("Where", "");
return(where);
}
public virtual string GetPagerCondition()
{
string where = "";
string CustomedCondition = Request["CustomedCondition"] ?? "";
if (!string.IsNullOrWhiteSpace(CustomedCondition))
{
where = CustomedCondition;
}
else
{
SearchCondition condition = new SearchCondition();
DataTable dt = baseBLL.GetFieldTypeList();
foreach (DataRow dr in dt.Rows)
{
string columnName = dr["ColumnName"].ToString();
string dataType = dr["DataType"].ToString();
string columnValue = Request[columnName] ?? "";
if (columnName.ToUpper().Equals("URL"))
{
continue;
}
if (IsDateTime(dataType))
{
condition.AddDateCondition(columnName, columnValue);
}
else if (IsNumericType(dataType))
{
bool boolValue = false;
if (bool.TryParse(columnValue, out boolValue))
{
condition.AddCondition(columnName, boolValue ? 1 : 0, SqlOperator.Equal);
}
else
{
condition.AddNumberCondition(columnName, columnValue);
}
}
else
{
if (ValidateUtil.IsNumeric(columnValue))
{
condition.AddCondition(columnName, columnValue, SqlOperator.Equal);
}
else
{
condition.AddCondition(columnName, columnValue, SqlOperator.Like);
}
}
}
where = condition.BuildConditionSql().Replace("Where", "");
}
return(where);
}
/// <summary>
/// 根据查询条件构造查询语句
/// </summary>
private string GetConditionSql()
{
//如果存在高级查询对象信息，则使用高级查询条件，否则使用主表条件查询
SearchCondition condition = advanceCondition;
if (condition == null)
{
condition = new SearchCondition();
condition.AddDateCondition("发生时间", this.txt发生时间1, this.txt发生时间2); //日期类型
condition.AddNumericCondition("设备id", this.txt设备id1, this.txt设备id2); //数值类型
condition.AddCondition("设备名称", this.txt设备名称.Text.Trim(), SqlOperator.Like);
condition.AddCondition("设备状态", this.txt设备状态.Text.Trim(), SqlOperator.Like);
condition.AddCondition("报警信息", this.txt报警信息.Text.Trim(), SqlOperator.Like);
}
string where = condition.BuildConditionSql().Replace("Where", "");
return(where);
}
/// <summary>
/// 获取分页操作的查询条件
/// </summary>
/// <returns></returns>
protected virtual string GetPagerCondition()
{
string where = "";
//增加一个CustomedCondition条件，根据客户这个条件进行查询
string CustomedCondition = Request["CustomedCondition"] ?? "";
if (!string.IsNullOrWhiteSpace(CustomedCondition))
{
where = CustomedCondition;//直接使用条件
}
else
{
#region 根据数据库字段列，对所有可能的参数进行获值，然后构建查询条件
SearchCondition condition = new SearchCondition();
DataTable dt = baseBLL.GetFieldTypeList();
foreach (DataRow dr in dt.Rows)
{
string columnName = dr["ColumnName"].ToString();
string dataType = dr["DataType"].ToString();
//字段增加WHC_前缀字符，避免传递如URL这样的Request关键字冲突
string columnValue = Request["WHC_" + columnName] ?? "";
//对于数值型，如果是显示声明相等的，一般是外键引用，需要特殊处理
bool hasEqualValue = columnValue.StartsWith("=");
if (IsDateTime(dataType))
{
condition.AddDateCondition(columnName, columnValue);
}
else if (IsNumericType(dataType))
{
//如果数据库是数值类型，而传入的值是true或者false,那么代表数据库的参考值为1,0，需要进行转换
bool boolValue = false;
bool isBoolenValue = bool.TryParse(columnValue, out boolValue);
if (isBoolenValue)
{
condition.AddCondition(columnName, boolValue ? 1 : 0, SqlOperator.Equal);
}
else if (hasEqualValue)
{
columnValue = columnValue.Substring(columnValue.IndexOf("=") + 1);
condition.AddCondition(columnName, columnValue, SqlOperator.Equal);
}
else
{
condition.AddNumberCondition(columnName, columnValue);
}
}
else
{
if (ValidateUtil.IsNumeric(columnValue))
{
condition.AddCondition(columnName, columnValue, SqlOperator.Equal);
}
else
{
condition.AddCondition(columnName, columnValue, SqlOperator.Like);
}
}
}
#endregion
#region MyRegion
//string SystemType_ID = Request["SystemType_ID"] ?? "";
//string LoginName = Request["LoginName"] ?? "";
//string FullName = Request["FullName"] ?? "";
//string Note = Request["Note"] ?? "";
//string IPAddress = Request["IPAddress"] ?? "";
//string MacAddress = Request["MacAddress"] ?? "";
//string LastUpdated = Request["LastUpdated"] ?? "";
//SearchCondition condition = new SearchCondition();
//condition.AddCondition("SystemType_ID", SystemType_ID, SqlOperator.Like);
//condition.AddCondition("LoginName", LoginName, SqlOperator.Like);
//condition.AddCondition("FullName", FullName, SqlOperator.Like);
//condition.AddCondition("Note", Note, SqlOperator.Like);
//condition.AddCondition("IPAddress", IPAddress, SqlOperator.Like);
//condition.AddCondition("MacAddress", MacAddress, SqlOperator.Like);
//condition.AddDateCondition("LastUpdated", LastUpdated);
#endregion
where = condition.BuildConditionSql().Replace("Where", "");
}
return(where);
}
