/// <summary>
/// 读取DataRow数据到Model中
/// </summary>
private void DutyUserDataRowToModel(RsDutyUser model, DataRow dr)
{
model.strDutyGUID = ObjectConvertClass.static_ext_string(dr["strDutyGUID"]);
model.strDutyNumber = ObjectConvertClass.static_ext_string(dr["strDutyNumber"]);
model.strDutyName = ObjectConvertClass.static_ext_string(dr["strDutyName"]);
model.strPassword = ObjectConvertClass.static_ext_string(dr["strPassword"]);
}
/// <summary>
/// 根据用户名获取登录人员信息
/// </summary>
/// <param name="strDutyNumber">工号</param>
/// <param name="bExist">返回参数，是否存在</param>
/// <returns></returns>
public RsDutyUser GetDutyUserByNumber(string strDutyNumber, out Boolean bExist)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from TAB_Org_DutyUser where strDutyNumber = @strDutyNumber");
SqlParameter[] sqlParams = { new SqlParameter("strDutyNumber", strDutyNumber) };
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0];
RsDutyUser _Org_DutyUser = null;
if (dt.Rows.Count > 0)
{
bExist = true;
_Org_DutyUser = new RsDutyUser();
DutyUserDataRowToModel(_Org_DutyUser, dt.Rows[0]);
}
else
{
bExist = false;
}
return(_Org_DutyUser);
}
