public static UserFingerInfo GetUserFingerInfoByID(string pID)
{
try
{
UserFingerInfo _UserFingerInfo = new UserFingerInfo();
DataTable taskDataTable = new DataTable();
using (SqlConnection conn = new SqlConnection(getTmpAppConnectionString()))
{
string sql = " select * from UserFingerInfo where UserID='" + pID + "' ";
using (SqlDataAdapter sd = new SqlDataAdapter(sql, conn))
{
sd.Fill(taskDataTable);
}
if (taskDataTable.Rows.Count > 0)
{
_UserFingerInfo = DataRowToUserFingerInfo(taskDataTable.Rows[0]);
}
else
{
_UserFingerInfo = null;
}
}
return(_UserFingerInfo);
}
catch (Exception ex)
{
LogService.WriteErr("程序错误，方法：GetUserFingerInfoByID 错误信息：" + ex.Message);
return(null);
}
}
/// 得到一个对象实体
/// </summary>
public static UserFingerInfo DataRowToUserFingerInfo(DataRow row)
{
UserFingerInfo model = new UserFingerInfo();
if (row != null)
{
if (row["UserID"] != null && row["UserID"].ToString() != "")
{
model.UserID = new Guid(row["UserID"].ToString());
}
if (row["FingerInfoStr1"] != null)
{
model.FingerInfoStr1 = row["FingerInfoStr1"].ToString();
}
if (row["FingerInfoStr2"] != null)
{
model.FingerInfoStr2 = row["FingerInfoStr2"].ToString();
}
if (row["FingerInfoStr3"] != null)
{
model.FingerInfoStr3 = row["FingerInfoStr3"].ToString();
}
}
return(model);
}
public bool UpdateUserFingerInfo(UserFingerInfo ur)
{
this.checkUrl();
try
{
return(this.service.UpdateUserFingerInfo(ur));
}
catch
{
try
{
return(this.service.UpdateUserFingerInfo(ur));
}
catch (System.Exception ex)
{
LogService.WriteErr("UserSynchroWebService，地址是：" + this.service.Url + " 方法：UpdateUserFingerInfo 原因：" + ex.Message);
return(false);
}
}
}
