/// <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 = 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.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> private string GetConditionSql() { //如果存在高级查询对象信息,则使用高级查询条件,否则使用主表条件查询 SearchCondition condition = advanceCondition; if (condition == null) { condition = new SearchCondition(); condition.AddCondition("设备名称", this.txt设备名称.Text.Trim(), SqlOperator.Like); condition.AddCondition("IP", this.txtIp.Text.Trim(), SqlOperator.Like); 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); }