//获取插件版本SWCodeVersion public string GetSWCodeVersion(string programname) { SQLHelper.connString = Globals.connStrGroupDBName; string sql = string.Format("select top 1 VersionNumber from sys_ProgramVersion where ProgramName='{0}' order by progid DESC", programname); return(SQLHelper.GetSingleResult(sql).ToString()); }
/// <summary> /// 判断图号+规格型号是否存在(DrawingCode+MaterialSpec)【规格型号=配置名】 /// </summary> /// <param name="drawingCode">图号</param> /// <param name="materialSpec">规格型号</param> /// <returns></returns> public bool IsExistDrawingCodeAndMaterialSpec(string drawingCode, string materialSpec) { SQLHelper.connString = Globals.connStrGroupDBName; string sql = string.Format("select count(*) from code_Drawing where DrawingCode='{0}' and MaterialSpec='{1}'", drawingCode, materialSpec); int result = Convert.ToInt32(SQLHelper.GetSingleResult(sql)); return(result != 0); }
//获取用户名BySQL(FullName) public static string GetLoginFullName(string PDMDbName) { SQLHelper.connString = Globals.connStrPDM; string loginId = PDMHelper.GetLoginID(); string sql = string.Format("select fullname from [{0}].dbo.Users where UserId='{1}'", PDMDbName, loginId); return(SQLHelper.GetSingleResult(sql).ToString()); }
//判断图号是否存在(DrawingCode)(新增/修改) public bool IsExistDrawingCode(string drawingCode, string drawingId = null) { SQLHelper.connString = Globals.connStrGroupDBName; string sql = string.Format("select count(*) from code_Drawing where DrawingCode='{0}'", drawingCode); if (drawingId != null) { sql += (" and DrawingId <> '" + drawingId + "'"); } int result = Convert.ToInt32(SQLHelper.GetSingleResult(sql)); return(result != 0); }
//获取插件版本SWCodeVersion public string GetSWCodeVersion(string programname) { try { SQLHelper.connString = Globals.connStrFactoryDBName; string sql = string.Format("select top 1 Revision from sys_ProgramInfo where ProgramName='{0}' order by progid DESC", programname); return(SQLHelper.GetSingleResult(sql).ToString()); } catch (Exception ex) { throw ex; } }
//查询PDM登录名是否与CODE程序登录名相同 public bool IsExistUserName(string username) { SQLHelper.connString = Globals.connStrGroupDBName; string sql = string.Format("select count(*) from tb_MyUser where Account='{0}'", username); //return SQLHelper.Update(strSql.ToString(), SqlPara, false) > 0 ? true : false; int result = Convert.ToInt32(SQLHelper.GetSingleResult(sql)); if (result > 0) { return(true); } else { return(false); } }
/// <summary> /// DAL获取新的图号编码(6位流水码:T123456) /// </summary> /// <param name="myPrefix">前缀字母</param> /// <param name="myNolen">流水号长度</param> /// <param name="myListna">流水单号对应的列名</param> /// <param name="myTablena">表名</param> /// <returns></returns> public string GetNewDrawingCode(string myPrefix, string myNolen, string myListna, string myTablena) { try { SQLHelper.connString = Globals.connStrGroupDBName; //【1】自定义存储过程 string sql = "usp_AutoFlowNum"; //【2】存储过程的参数(5个变量) SqlParameter[] param = new SqlParameter[] { new SqlParameter("@prefix", myPrefix), //前缀字母 new SqlParameter("@nolen", myNolen), //流水号长度 new SqlParameter("@listna", myListna), //流水单号对应的列名 new SqlParameter("@tablena", myTablena), //表名 new SqlParameter("@runningnum", string.Empty) //生成流水码 }; //【3】执行并返回新的图号编码 return(SQLHelper.GetSingleResult(sql, param, true).ToString()); } catch (Exception ex) { throw ex; } }