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