//是否是唯一的物料(三个条件+自身MaterialId) public DataRow IsUniqueMaterial(string materialclassId, string parameter1, string parameter2, string materialId = null) { SQLHelper.connString = Globals.connStrGroupDBName; StringBuilder sb = new StringBuilder(); sb.Append("SELECT * FROM code_Material WHERE StatusId < 5 "); //默认不显示历史(5)【包含禁用(4)的数据】 if (materialclassId.StartsWith("3")) //自制件3开头,图号DrawingCode+颜色PaintingColor { if (string.IsNullOrEmpty(parameter2)) { sb.Append(" AND DrawingCode='" + parameter1 + "' and (PaintingColor IS NULL OR PaintingColor='')"); } else { sb.Append(" AND DrawingCode='" + parameter1 + "' and PaintingColor='" + parameter2 + "' "); } } else if (materialclassId.StartsWith("50") || materialclassId.StartsWith("51"))//外购件50、51开头,型号MaterialType+品牌BrandId { if (string.IsNullOrEmpty(parameter2)) { sb.Append(" AND MaterialType='" + parameter1 + "' and (BrandId IS NULL OR BrandId='')"); } else { sb.Append(" AND MaterialType='" + parameter1 + "' and BrandId='" + parameter2 + "' "); } } else if (materialclassId.StartsWith("52"))//标准件52开头,型号MaterialType+名称MaterialName { sb.Append(" AND MaterialType='" + parameter1 + "' and MaterialName='" + parameter2 + "' "); } else//其他的,图号DrawingCode+名称MaterialName { sb.Append(" AND DrawingCode='" + parameter1 + "' and MaterialName='" + parameter2 + "' "); } if (String.IsNullOrEmpty(materialId) == false) { sb.Append(" AND MaterialId <> '" + materialId + "' "); } //DataTable dt = DataProvider.Instance.GetTable(_Loginer.GroupDBName, sb.ToString(), "IsUniqueMaterial"); DataTable dt = SQLHelper.GetDataSet(sb.ToString()).Tables[0]; if (dt != null && dt.Rows.Count > 0) { return(dt.Rows[0]); } else { return(null); } }
//通过查询获取编码系统的用户信息 public DataRow GetUserInfo(string username) { SQLHelper.connString = Globals.connStrFactoryDBName; string sql = string.Format("select * from tb_MyUser where PDMAccount='{0}'", username); DataTable dt = SQLHelper.GetDataSet(sql).Tables[0]; if (dt.Rows.Count > 0) { return(dt.Rows[0]); } else { return(null); } }
//从数据库获取选中节点的完整信息 public DataRow GetMaterialClassById(string materialclassId) { SQLHelper.connString = Globals.connStrGroupDBName; string sql = string.Format("select * from code_MaterialClass where MaterialClassId='{0}'", materialclassId); DataTable dt = SQLHelper.GetDataSet(sql).Tables[0]; if (dt.Rows.Count > 0) { return(dt.Rows[0]); } else { return(null); } }
/// <summary> /// 根据DocIdModel查找图号相关信息(可能是多条记录) /// </summary> /// <param name="fileId">文件ID</param> /// <param name="materialSpec">规格型号(配置名)</param> /// <returns>返回dt表(DrawingId,DrawingClassId)</returns> public DataTable GetDrawingInfoByDocumentId(string fileId, string materialSpec = null) { SQLHelper.connString = Globals.connStrGroupDBName; StringBuilder sb = new StringBuilder(); sb.Append("select DrawingId,DrawingClassId from code_Drawing where 1=1 "); if (String.IsNullOrEmpty(fileId) == false) { sb.Append(" AND DocIdModel='" + fileId + "'"); } if (String.IsNullOrEmpty(materialSpec) == false) { sb.Append(" AND MaterialSpec='" + materialSpec + "'"); } string sql = sb.ToString(); return(SQLHelper.GetDataSet(sql).Tables[0]); }
//如果通过文件ID可以查询到图号编码等信息(图号状态是1),则返回4个字符串,否则返回空的List public DrawingModel GetFileDrawingInfo(string fileID) { SQLHelper.connString = Globals.connStrGroupDBName; StringBuilder strSql = new StringBuilder(); strSql.Append(" select * from code_Drawing"); strSql.Append(" where DocIdModel={0} and DrawingStatusId=1"); strSql.Append(" ORDER BY DrawingId DESC"); string sql = string.Format(strSql.ToString(), fileID); DataTable dt = SQLHelper.GetDataSet(sql).Tables[0]; DrawingModel objDrawing = null; if (dt.Rows.Count >= 1) { objDrawing = new DrawingModel() { DrawingCode = dt.Rows[0]["DrawingCode"].ToString(), MaterialName = dt.Rows[0]["MaterialName"].ToString(), MaterialSpec = dt.Rows[0]["MaterialSpec"].ToString(), DocIdModel = Convert.ToInt32(dt.Rows[0]["DocIdModel"]) }; } return(objDrawing); }