protected override string GetFilterSql(UserModel user, T_UserGroupInfo model) { string strSql = base.GetFilterSql(user, model); string strAnd = " and "; if (!Common_Func.IsNullOrEmpty(model.UserGroupNo)) { strSql += strAnd; strSql += " (USERGROUPNO like '%" + model.UserGroupNo + "%') "; } if (!Common_Func.IsNullOrEmpty(model.UserGroupName)) { strSql += strAnd; strSql += " (USERGROUPNAME like '%" + model.UserGroupName + "%') "; } if (model.UserGroupType >= 1) { strSql += strAnd; strSql += " USERGROUPTYPE = " + model.UserGroupType + ""; } return(strSql); }
protected override bool CheckModelBeforeSave(T_MaterialInfo model, ref string strError) { T_Material_DB mdb = new T_Material_DB(); if (model == null) { strError = "客户端传来的实体类不能为空!"; return(false); } if (Common_Func.IsNullOrEmpty(model.MaterialNo)) { strError = "物料编号不能为空!"; return(false); } if (Common_Func.IsNullOrEmpty(model.MaterialDesc)) { strError = "物料名称不能为空!"; return(false); } //新增的情况需要验证物料编号是否存在 if (model.ID <= 0) { if (mdb.CheckMaterialExist(model) > 0) { strError = "物料编码已经存在!"; return(false); } } return(true); }
protected override string GetFilterSql(UserModel user, T_CustomerInfo customer) { string strSql = " where isnull(isDel,0) != 2 "; string strAnd = " and "; if (!Common_Func.IsNullOrEmpty(customer.CustomerNo)) { strSql += strAnd; strSql += " (CustomerNo like '%" + customer.CustomerNo + "%' or CustomerName like '%" + customer.CustomerNo + "%') "; } if (!string.IsNullOrEmpty(customer.ContactPerson)) { strSql += strAnd; strSql += " ContactPerson like '%" + customer.ContactPerson + "%'"; } if (!string.IsNullOrEmpty(customer.ContactTel)) { strSql += strAnd; strSql += " ContactTel like '%" + customer.ContactTel + "%'"; } if (!string.IsNullOrEmpty(customer.CustomerName)) { strSql += strAnd; strSql += " CustomerName like '%" + customer.CustomerName + "%'"; } return(strSql); }
//编号 名称 类型 产能 protected override string GetFilterSql(UserModel user, T_ProductLine customer) { string strSql = " where nvl(isDel,0) != 2 "; string strAnd = " AND "; if (!Common_Func.IsNullOrEmpty(customer.Sn)) { strSql += strAnd; strSql += " (SN like '%" + customer.Sn + "%') "; } if (!string.IsNullOrEmpty(customer.MachineLineName)) { strSql += strAnd; strSql += " MachineLineName like '%" + customer.MachineLineName + "%'"; } if (!string.IsNullOrEmpty(customer.LineType)) { strSql += strAnd; strSql += " LineType = '" + customer.LineType + "'"; } return(strSql); }
//编号 名称 类型 产能 protected override string GetFilterSql(UserModel user, T_Team customer) { string strSql = " where isnull(isDel,0) != 2 "; string strAnd = " AND "; if (!Common_Func.IsNullOrEmpty(customer.teamCode)) { strSql += strAnd; strSql += " (teamCode like '%" + customer.teamCode + "%') "; } if (!string.IsNullOrEmpty(customer.teamName)) { strSql += strAnd; strSql += " teamName like '%" + customer.teamName + "%'"; } if (!string.IsNullOrEmpty(customer.LeaderCode)) { strSql += strAnd; strSql += " LeaderCode like '%" + customer.LeaderCode + "%'"; } if (!string.IsNullOrEmpty(customer.Position)) { strSql += strAnd; strSql += " Position like '%" + customer.Position + "%'"; } return(strSql); }
protected override string GetFilterSql(UserModel user, T_Machine customer) { string strSql = " where nvl(isDel,0) != 2 "; string strAnd = " and "; if (!Common_Func.IsNullOrEmpty(customer.MachineCode)) { strSql += strAnd; strSql += " (MachineCode like '%" + customer.MachineCode + "%') "; } if (!string.IsNullOrEmpty(customer.MachineName)) { strSql += strAnd; strSql += " MachineName like '%" + customer.MachineName + "%'"; } if ((!string.IsNullOrEmpty(customer.MachineType))) { strSql += strAnd; strSql += " MachineType like '%" + customer.MachineType + "%'"; } return(strSql); }
protected override string GetFilterSql(UserModel user, T_TransportSupDetailInfo model) { string strSql = " where isnull(isDel,0) != 2"; string strAnd = " and "; if (!Common_Func.IsNullOrEmpty(model.PlateNumber)) { strSql += strAnd; strSql += " PlateNumber LIKE '%" + model.PlateNumber + "%' "; } if (!Common_Func.IsNullOrEmpty(model.PalletNo)) { strSql += strAnd; //strSql += " ID In (Select WarehouseID From T_House Where HouseNo LIKE '%" + model.HouseNo + "%' OR HouseName Like '%" + model.HouseNo + "%') "; strSql += " PalletNo LIKE '%" + model.PalletNo + "%' "; } if (!Common_Func.IsNullOrEmpty(model.ErpVoucherNo)) { strSql += strAnd; strSql += " ErpVoucherNo LIKE '%" + model.ErpVoucherNo + "%' "; } if (!Common_Func.IsNullOrEmpty(model.strType)) { strSql += strAnd; strSql += " strType = '" + model.strType + "' "; } if (!Common_Func.IsNullOrEmpty(model.VoucherNo)) { strSql += strAnd; strSql += " VoucherNo = '" + model.VoucherNo + "' "; } if (!Common_Func.IsNullOrEmpty(model.Creater)) { strSql += strAnd; strSql += " Creater Like '%" + model.Creater + "%' "; } if (model.DateFrom != null) { strSql += strAnd; strSql += " CreateTime >= " + model.DateFrom.ToDateTime().Date.ToOracleTimeString() + " "; } if (model.DateTo != null) { strSql += strAnd; strSql += " CreateTime <= " + model.DateTo.ToDateTime().AddDays(1).Date.ToOracleTimeString() + " "; } return(strSql); }
protected override string GetFilterSql(UserModel user, UserInfo model) { string strSql = base.GetFilterSql(user, model); string strAnd = " and "; if (!Common_Func.IsNullOrEmpty(model.UserNo)) { strSql += strAnd; strSql += " (USERNO like '%" + model.UserNo + "%') "; } if (!Common_Func.IsNullOrEmpty(model.UserName)) { strSql += strAnd; strSql += " (UserName like '%" + model.UserName + "%') "; } if (model.IsOnline >= 1) { strSql += strAnd; strSql += " LoginIP is " + (model.IsOnline.ToBoolean() ? "not" : "") + " null "; } if (!string.IsNullOrEmpty(model.Creater)) { strSql += strAnd; strSql += " Creater Like '%" + model.Creater + "%' "; } if (model.DateFrom != null) { strSql += strAnd; strSql += " CreateTime " + this.GetDateFromFilter(model); } if (model.DateTo != null) { strSql += strAnd; strSql += " CreateTime " + this.GetDateToFilter(model); } if (model.IsPick > 0) { strSql += strAnd; strSql += " IsPick ='" + model.IsPick + "' "; } if (model.LoginTime != null) { strSql += strAnd; strSql += " isnull(LoginTime,'') <> '' "; } return(strSql); }
protected override string GetFilterSql(UserModel user, T_MaterialInfo model) { string strSql = string.Empty; string strAnd = " and "; strSql += base.GetFilterSql(user, model); if (!Common_Func.IsNullOrEmpty(model.MaterialNo)) { strSql += strAnd; strSql += " (MaterialNo LIKE '" + model.MaterialNo + "%' ) "; } if (!Common_Func.IsNullOrEmpty(model.MaterialDesc)) { strSql += strAnd; strSql += " MaterialDesc Like '" + model.MaterialDesc + "%'"; } if (!Common_Func.IsNullOrEmpty(model.SupplierNo)) { strSql += strAnd; strSql += "( SupplierNo Like '" + model.SupplierNo + "%' or SupplierName Like '" + model.SupplierNo + "%' )"; } if (model.DateFrom != null) { strSql += strAnd; strSql += " CreateTime >= " + model.DateFrom.ToDateTime().Date.AddDays(-1).ToOracleTimeString() + " "; } if (model.DateTo != null) { strSql += strAnd; strSql += " CreateTime <= " + model.DateTo.ToDateTime().Date.AddDays(1).ToOracleTimeString() + " "; } if (!string.IsNullOrEmpty(model.BatchNo)) { strSql += strAnd; strSql += " Batchno = '" + model.BatchNo + "' "; } if (!string.IsNullOrEmpty(model.WareHouseNo)) { strSql += strAnd; strSql += " WareHouseNo = '" + model.WareHouseNo + "' "; } if (!string.IsNullOrEmpty(model.AreaNo)) { strSql += strAnd; strSql += " AreaNo = '" + model.AreaNo + "' "; } return(strSql); }
protected override string GetFilterSql(UserModel user, T_TransportSupplier model) { string strSql = base.GetFilterSql(user, model); string strAnd = " and "; if (!Common_Func.IsNullOrEmpty(model.TransportSupplierID.ToString()) || !Common_Func.IsNullOrEmpty(model.TransportSupplierName.ToString())) { strSql += strAnd; strSql += " (Transportsupplierid LIKE '%" + model.TransportSupplierID + "%' OR TransportSupplierName Like '%" + model.TransportSupplierName + "%') "; } return(strSql); }
protected override bool CheckModelBeforeSave(T_DepInterfaceInfo model, ref string strError) { if (model == null) { strError = "客户端传来的实体类不能为空!"; return(false); } if (model.VoucherName == 0) { strError = "请先选择单据名称!"; return(false); } if (model.VoucherType == 0) { strError = "请先选择单据类型!"; return(false); } if (model.Function == 0) { strError = "请先选择功能!"; return(false); } if (Common_Func.IsNullOrEmpty(model.Route)) { strError = "请先输入DLL文件路径!"; return(false); } if (Common_Func.IsNullOrEmpty(model.ClassName)) { strError = "请先输入类名!"; return(false); } if (Common_Func.IsNullOrEmpty(model.DLLName)) { strError = "请先输入DLL文件名称!"; return(false); } if (Common_Func.IsNullOrEmpty(model.FunctionName)) { strError = "请先输入函数名称!"; return(false); } return(true); }
protected override bool CheckModelBeforeSave(UserInfo model, ref string strError) { if (model == null) { strError = "客户端传来的实体类不能为空!"; return(false); } if (model.UserStatus <= 0) { strError = "用户状态必须选择!"; return(false); } if (model.UserType <= 0) { strError = "用户类型必须选择!"; return(false); } if (BILBasic.Common.Common_Func.IsNullOrEmpty(model.UserNo)) { strError = "登录名不能为空!"; return(false); } if (Common_Func.IsNullOrEmpty(model.UserName)) { strError = "用户姓名不能为空!"; return(false); } if (Common_Func.IsNullOrEmpty(model.PassWord) || Common_Func.IsNullOrEmpty(model.RePassword)) { strError = "登陆密码和确认密码不能为空!"; return(false); } //if (Common_Func.IsNullOrEmpty(model.GroupCode)) //{ // strError = "用户分组不能为空!"; // return false; //} if (!Common_Func.IsEqualString(model.PassWord, model.RePassword)) { strError = "确认密码与登陆密码不一致!"; return(false); } return(true); }
protected override string GetFilterSql(UserModel user, T_HouseInfo model) { string strSql = " where isnull(isDel,0) != 2"; string strAnd = " and "; if (model.WarehouseID > 0) { strSql += strAnd; strSql += " warehouseid = '" + model.WarehouseID + "' "; } if (!Common_Func.IsNullOrEmpty(model.WarehouseNo)) { strSql += strAnd; strSql += " (WarehouseNo LIKE '%" + model.WarehouseNo + "%' OR WarehouseName Like '%" + model.WarehouseNo + "%') "; } if (!Common_Func.IsNullOrEmpty(model.HouseNo)) { strSql += strAnd; //strSql += " ID In (Select WarehouseID From T_House Where HouseNo LIKE '%" + model.HouseNo + "%' OR HouseName Like '%" + model.HouseNo + "%') "; strSql += "(HouseNo LIKE '%" + model.HouseNo + "%' OR HouseName Like '%" + model.HouseNo + "%') "; } if (!Common_Func.IsNullOrEmpty(model.AreaNo)) { strSql += strAnd; strSql += " ID In (Select houseid From t_area Where AreaNo LIKE '" + model.AreaNo + "%' OR AreaName Like '" + model.AreaNo + "%') "; } if (!Common_Func.IsNullOrEmpty(model.Creater)) { strSql += strAnd; strSql += " Creater Like '%" + model.Creater + "%' "; } if (model.DateFrom != null) { strSql += strAnd; strSql += " CreateTime >= " + model.DateFrom.ToDateTime().Date.ToOracleTimeString() + " "; } if (model.DateTo != null) { strSql += strAnd; strSql += " CreateTime <= " + model.DateTo.ToDateTime().AddDays(1).Date.ToOracleTimeString() + " "; } return(strSql); }
protected override string GetFilterSql(UserModel user, T_AreaInfo model) { string strSql = " where isnull(isDel,0) != 2"; string strAnd = " and "; if (model.HouseID > 0) { strSql += strAnd; strSql += " HouseID = '" + model.HouseID + "' "; } if (!string.IsNullOrEmpty(model.AreaNo)) { strSql += strAnd; strSql += " areano like '" + model.AreaNo + "%' "; } if (!Common_Func.IsNullOrEmpty(model.WarehouseNo)) { strSql += strAnd; strSql += " (WarehouseNo LIKE '%" + model.WarehouseNo + "%' OR WarehouseName Like '%" + model.WarehouseNo + "%') "; } if (!Common_Func.IsNullOrEmpty(model.HouseNo)) { strSql += strAnd; strSql += " (HouseNo LIKE '%" + model.HouseNo + "%' OR HouseName Like '%" + model.HouseNo + "%') "; } //if (!Common_Func.IsNullOrEmpty(model.Creater)) //{ // strSql += strAnd; // strSql += " Creater Like '%" + model.Creater + "%' "; //} //if (model.DateFrom != null) //{ // strSql += strAnd; // strSql += " CreateTime >= " + model.DateFrom.ToDateTime().Date.ToOracleTimeString() + " "; //} //if (model.DateTo != null) //{ // strSql += strAnd; // strSql += " CreateTime <= " + model.DateTo.ToDateTime().AddDays(1).Date.ToOracleTimeString() + " "; //} return(strSql); }
protected override string GetFilterSql(UserModel user, T_AdvInStockDetailInfo model) { string strSql = " where isnull(isDel,0) != 2 "; string strAnd = " and "; if (!Common_Func.IsNullOrEmpty(model.ErpVoucherNo)) { strSql += strAnd; strSql += " ErpVoucherNo like '%" + model.ErpVoucherNo.Trim() + "%' "; } if (!Common_Func.IsNullOrEmpty(model.IsPrint)) { if (model.IsPrint == "是") { strSql += strAnd; strSql += " sumqty > 0"; } if (model.IsPrint == "否") { strSql += strAnd; strSql += " sumqty = 0"; } } if (!Common_Func.IsNullOrEmpty(model.MaterialNo)) { strSql += strAnd; strSql += " MaterialNo like '%" + model.MaterialNo.Trim() + "%' "; } if (!Common_Func.IsNullOrEmpty(model.Createname)) { strSql += strAnd; strSql += " Createname like '%" + model.Createname.Trim() + "%' "; } if (model.DateFrom != null) { strSql += strAnd; strSql += " CREATETIME>=to_date('" + model.DateFrom.ToDateTime().ToString("yyyy/MM/dd") + "','YYYY/MM/DD') "; } if (model.DateTo != null) { strSql += strAnd; strSql += " CREATETIME<=to_date('" + model.DateTo.ToDateTime().ToString("yyyy/MM/dd") + "','YYYY/MM/DD')+1 "; } return(strSql); }
protected override string GetFilterSql(UserModel user, T_WareHouseInfo model) { string strSql = base.GetFilterSql(user, model); string strAnd = " and "; if (!Common_Func.IsNullOrEmpty(model.WareHouseNo)) { strSql += strAnd; strSql += " (WarehouseNo LIKE '" + model.WareHouseNo + "%' OR WarehouseName Like '" + model.WareHouseNo + "%') "; } if (!Common_Func.IsNullOrEmpty(model.WareHouseName)) { strSql += strAnd; strSql += " WarehouseName Like '" + model.WareHouseName + "%' "; } if (!string.IsNullOrEmpty(model.HouseNo)) { strSql += strAnd; strSql += " ID In (Select WarehouseID From T_House Where HouseNo LIKE '%" + model.HouseNo + "%' OR HouseName Like '%" + model.HouseNo + "%') "; } if (!Common_Func.IsNullOrEmpty(model.Address)) { strSql += strAnd; strSql += " Address Like '%" + model.Address + "%'"; } if (!Common_Func.IsNullOrEmpty(model.Creater)) { strSql += strAnd; strSql += " Creater Like '%" + model.Creater + "%' "; } if (model.DateFrom != null) { strSql += strAnd; strSql += " CreateTime >= " + model.DateFrom.ToDateTime().Date.ToOracleTimeString() + " "; } if (model.DateTo != null) { strSql += strAnd; strSql += " CreateTime <= " + model.DateTo.ToDateTime().AddDays(1).Date.ToOracleTimeString() + " "; } return(strSql); }
protected override string GetFilterSql(UserModel user, MaterialPack_Model model) { string strSql = string.Empty; string strAnd = " and "; strSql += base.GetFilterSql(user, model); if (!Common_Func.IsNullOrEmpty(model.WATERCODE)) { strSql += strAnd; strSql += " (WATERCODE = '" + model.WATERCODE + "' ) "; } if (!Common_Func.IsNullOrEmpty(model.StrongHoldCode)) { strSql += strAnd; strSql += " (StrongHoldCode = '" + model.StrongHoldCode + "' ) "; } return(strSql); }
protected override string GetFilterSql(UserModel user, T_MouldType customer) { string strSql = " where 1=1 "; string strAnd = " and "; if (!Common_Func.IsNullOrEmpty(customer.MouldTypeCode)) { strSql += strAnd; strSql += " (ID like '%" + customer.MouldTypeCode + "%') "; } if (!string.IsNullOrEmpty(customer.MouldTypeName)) { strSql += strAnd; strSql += " Name like '%" + customer.MouldTypeName + "%'"; } return(strSql); }
protected override bool CheckModelBeforeSave(T_Team model, ref string strError) { if (model == null) { strError = "客户端传来的实体类不能为空!"; return(false); } if (Common_Func.IsNullOrEmpty(model.teamCode)) { strError = "班组编号不能为空!"; return(false); } if (Common_Func.IsNullOrEmpty(model.teamName)) { strError = "班组名称不能为空!"; return(false); } return(true); }
protected override bool CheckModelBeforeSave(T_CustomerAddressInfo model, ref string strError) { if (model == null) { strError = "客户端传来的实体类不能为空!"; return(false); } if (Common_Func.IsNullOrEmpty(model.ContactPerson)) { strError = "联系人不能为空!"; return(false); } if (Common_Func.IsNullOrEmpty(model.Address)) { strError = "地址不能为空!"; return(false); } return(true); }
protected override bool CheckModelBeforeSave(T_MouldType model, ref string strError) { if (model == null) { strError = "客户端传来的实体类不能为空!"; return(false); } if (Common_Func.IsNullOrEmpty(model.MouldTypeCode)) { strError = "模具型号编号不能为空!"; return(false); } if (Common_Func.IsNullOrEmpty(model.MouldTypeName)) { strError = "模具型号名称不能为空!"; return(false); } return(true); }
protected override bool CheckModelBeforeSave(T_Machine model, ref string strError) { if (model == null) { strError = "客户端传来的实体类不能为空!"; return(false); } if (Common_Func.IsNullOrEmpty(model.Sn)) { strError = "设备编号不能为空!"; return(false); } if (Common_Func.IsNullOrEmpty(model.MachineName)) { strError = "设备名称不能为空!"; return(false); } return(true); }
protected override bool CheckModelBeforeSave(T_CustomerInfo model, ref string strError) { if (model == null) { strError = "客户端传来的实体类不能为空!"; return(false); } if (Common_Func.IsNullOrEmpty(model.CustomerNo)) { strError = "客户编号不能为空!"; return(false); } if (Common_Func.IsNullOrEmpty(model.CustomerName)) { strError = "客户名称不能为空!"; return(false); } if (Common_Func.IsNullOrEmpty(model.CustomerAbridge)) { strError = "客户简称不能为空!"; return(false); } if (Common_Func.IsNullOrEmpty(model.EnglishName)) { strError = "英文名不能为空!"; return(false); } if (Common_Func.IsNullOrEmpty(model.ContactPerson)) { strError = "联系人不能为空!"; return(false); } return(true); }
protected override bool CheckModelBeforeSave(UserInfo model, ref string strError) { if (model == null) { strError = "客户端传来的实体类不能为空!"; return(false); } if (model.UserStatus <= 0) { strError = "用户状态必须选择!"; return(false); } if (model.UserType <= 0) { strError = "用户类型必须选择!"; return(false); } if (BILBasic.Common.Common_Func.IsNullOrEmpty(model.UserNo)) { strError = "登录名不能为空!"; return(false); } if (Common_Func.IsNullOrEmpty(model.UserName)) { strError = "用户姓名不能为空!"; return(false); } if (Common_Func.IsNullOrEmpty(model.PassWord) || Common_Func.IsNullOrEmpty(model.RePassword)) { strError = "登陆密码和确认密码不能为空!"; return(false); } //判断据点和仓库的关系 T_WareHouse_Func Wfunc = new T_WareHouse_Func(); string Msg = ""; string[] warehousenos = model.WarehouseCode.Split(','); for (int i = 0; i < warehousenos.Length; i++) { T_WareHouseInfo warehouse = new T_WareHouseInfo() { ID = Convert.ToInt16(warehousenos[i]) }; Wfunc.GetModelByID(ref warehouse, ref Msg); if (model.StrongHoldCode == "0300") { if (warehouse.WareHouseNo.Substring(0, 1) != "G") { strError = "仓库和据点没有对应关系!"; return(false); } } if (model.StrongHoldCode == "0401") { if (warehouse.WareHouseNo.Substring(0, 2) != "C1") { strError = "仓库和据点没有对应关系!"; return(false); } } if (model.StrongHoldCode == "0402") { if (warehouse.WareHouseNo.Substring(0, 2) != "C2") { strError = "仓库和据点没有对应关系!"; return(false); } } if (model.StrongHoldCode == "0403") { if (warehouse.WareHouseNo.Substring(0, 2) != "C3") { strError = "仓库和据点没有对应关系!"; return(false); } } } //if (Common_Func.IsNullOrEmpty(model.GroupCode)) //{ // strError = "用户分组不能为空!"; // return false; //} if (!Common_Func.IsEqualString(model.PassWord, model.RePassword)) { strError = "确认密码与登陆密码不一致!"; return(false); } return(true); }