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