/// <summary> /// add by chr /// </summary> /// <param name="strUserName"></param> /// <returns></returns> public static int GetUserOrgId(string strUserName) { //构建查询条件 Parameter parameter = new Parameter(); parameter.SqlString = " SELECT [OrgId] FROM [PT_USER] WHERE [UserName]=@UserName "; SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar, 50) { Value = strUserName }, }; parameter.Parameters = parameters; return(Convert.ToInt32(CommonToolsBLL.ExcuteSqlReturnSingleObject(parameter))); }
/// <summary> /// add by chr /// </summary> /// <param name="OrgId">当前机构</param> /// <param name="OrgName">要查找机构名称(1-厨房 2-仓库)</param> /// <returns></returns> public static int GetFatherIdByOrg(string OrgId, string OrgName) { //构建查询条件 Parameter parameter = new Parameter(); parameter.SqlString = " SELECT [Id] FROM [PT_ORG] WHERE [FatherId]=@OrgId AND [OrgName]=@OrgName "; SqlParameter[] parameters = { new SqlParameter("@OrgId", SqlDbType.NVarChar, 50) { Value = OrgId }, new SqlParameter("@OrgName", SqlDbType.NVarChar, 50) { Value = OrgName } }; parameter.Parameters = parameters; return(Convert.ToInt32(CommonToolsBLL.ExcuteSqlReturnSingleObject(parameter))); }