/// <summary>
/// 获取用户ID
/// </summary>
///
public int GetIDByAccount(string strAccount, out string strErrMsg)
{
SqlParameter[] arrParm =
{
new SqlParameter("@Account", SqlDbType.VarChar, 20)
};
arrParm[0].Value = strAccount;
return(DB.RunProcedureReturnInt("Shine_Admins_GetID_ByAccount", arrParm, out strErrMsg));
}
/// <summary>
/// 添加特殊工种进出区域配置信息
/// </summary>
/// <param name="intEmpID">员工流水</param>
/// <param name="intTerrialID">区域流水</param>
/// <param name="intWorkTypeID">工种流水</param>
/// <param name="bIsAlarm">是否报警标志</param>
/// <param name="strRemark">备注</param>
/// <param name="strErr">带出的错误</param>
/// <returns></returns>
public int Insert_SpecialWorkTypeTerrialSet(int intEmpID, int intTerrialID, int intWorkTypeID, bool bIsAlarm, string strRemark, out string strErr)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@EmpID", SqlDbType.Int, 4),
new SqlParameter("@AreaID", SqlDbType.Int, 4),
new SqlParameter("@workTypeID", SqlDbType.Int, 4),
new SqlParameter("@IsAlarm", SqlDbType.Bit),
new SqlParameter("@Remark", SqlDbType.NVarChar, 300)
};
parameters[0].Value = intEmpID;
parameters[1].Value = intTerrialID;
parameters[2].Value = intWorkTypeID;
parameters[3].Value = bIsAlarm;
parameters[4].Value = strRemark;
return(DB.RunProcedureReturnInt("KJ128N_Insert_SpecialWorkTypeTerrial", parameters, out strErr));
}