/// <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)));
}
