//获取插件版本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;
}
}
