public static UserLoginEx[] GetUserLoginListExByUserName(string pUserLoginName)
{
try
{
UserLoginEx[] _UserLoginExList = null;
DataTable taskDataTable = new DataTable();
using (SqlConnection conn = new SqlConnection(getTmpAppConnectionString()))
{
string sql = " select * from UserLoginEx where UserLoginName='" + pUserLoginName + "' ";
using (SqlDataAdapter sd = new SqlDataAdapter(sql, conn))
{
sd.Fill(taskDataTable);
}
if (taskDataTable.Rows.Count > 0)
{
_UserLoginExList = new UserLoginEx[taskDataTable.Rows.Count];
for (int i = 0; i < taskDataTable.Rows.Count; i++)
{
_UserLoginExList[i] = DataRowUserLoginEx(taskDataTable.Rows[i]);
}
}
else
{
_UserLoginExList = null;
}
}
return(_UserLoginExList);
}
catch (Exception ex)
{
LogService.WriteErr("程序错误，方法：GetUserLoginListExByUserName 错误信息：" + ex.Message);
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static UserLoginEx DataRowUserLoginEx(DataRow row)
{
UserLoginEx model = new UserLoginEx();
if (row != null)
{
if (row["UserLoginName"] != null && row["UserLoginName"].ToString() != "")
{
model.UserLoginName = row["UserLoginName"].ToString();
}
if (row["UserLoginEx1"] != null && row["UserLoginEx1"].ToString() != "")
{
model.UserLoginEx1 = row["UserLoginEx1"].ToString();
}
else
{
model.UserLoginEx1 = "";
}
if (row["UserLoginEx2"] != null && row["UserLoginEx2"].ToString() != "")
{
model.UserLoginEx2 = row["UserLoginEx2"].ToString();
}
else
{
model.UserLoginEx2 = "";
}
if (row["UserLoginEx3"] != null && row["UserLoginEx3"].ToString() != "")
{
model.UserLoginEx3 = row["UserLoginEx3"].ToString();
}
else
{
model.UserLoginEx3 = "";
}
if (row["UserLoginEx4"] != null && row["UserLoginEx4"].ToString() != "")
{
model.UserLoginEx4 = row["UserLoginEx4"].ToString();
}
else
{
model.UserLoginEx4 = "";
}
if (row["UserLoginEx5"] != null && row["UserLoginEx5"].ToString() != "")
{
model.UserLoginEx5 = row["UserLoginEx5"].ToString();
}
else
{
model.UserLoginEx5 = "";
}
}
return(model);
}
public bool UpdateUserLoginEx(UserLoginEx ur)
{
this.checkUrl();
try
{
return(this.service.UpdateUserLoginEx(ur));
}
catch
{
try
{
return(this.service.UpdateUserLoginEx(ur));
}
catch (System.Exception ex)
{
LogService.WriteErr("UserSynchroWebService，地址是：" + this.service.Url + "方法：UpdateUserLoginEx 原因：" + ex.Message);
return(false);
}
}
}
