//是否是唯一的物料（三个条件+自身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);
}
