public int Update_UMUserInfo(UMUserInfoInfo uMUserInfoInfo)
{
SqlParameter[] parm = new SqlParameter[8];
parm[0] = new SqlParameter("@BDOS_Code", SqlDbType.VarChar, 60);
parm[0].Value = uMUserInfoInfo.BDOS_Code;
parm[1] = new SqlParameter("@UMUI_UserID", SqlDbType.VarChar, 60);
parm[1].Value = uMUserInfoInfo.UMUI_UserID;
parm[2] = new SqlParameter("@UMUI_UserName", SqlDbType.VarChar, 60);
parm[2].Value = uMUserInfoInfo.UMUI_UserName;
parm[3] = new SqlParameter("@UMUI_UserRole", SqlDbType.VarChar, 1000);
parm[3].Value = uMUserInfoInfo.UMUI_UserRole == null ? "" : uMUserInfoInfo.UMUI_UserRole;
parm[4] = new SqlParameter("@UMUI_TotalLoginCount", SqlDbType.Int, 4);
parm[4].Value = uMUserInfoInfo.UMUI_TotalLoginCount == 0 ? 0 : uMUserInfoInfo.UMUI_TotalLoginCount;
parm[5] = new SqlParameter("@UMUI_TodayLoginCount", SqlDbType.Int, 4);
parm[5].Value = uMUserInfoInfo.UMUI_TodayLoginCount == 0 ? 0 : uMUserInfoInfo.UMUI_TodayLoginCount;
//parm[6] = new SqlParameter("@UMUI_Password", SqlDbType.VarChar, 200);
//parm[6].Value = uMUserInfoInfo.UMUI_Password == null ? "" : uMUserInfoInfo.UMUI_Password;
parm[6] = new SqlParameter("@UMUI_LastLoginTime", SqlDbType.DateTime);
if (uMUserInfoInfo.UMUI_LastLoginTime == DateTime.MinValue)
{
parm[6].Value = Convert.ToDateTime("1900-1-1");
}
else
{
parm[6].Value = uMUserInfoInfo.UMUI_LastLoginTime;
}
parm[7] = new SqlParameter("@UMUI_Isdeleted", SqlDbType.Bit);
parm[7].Value = 1;
return(SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction,
CommandType.StoredProcedure, "Proc_Update_UMUserInfo", parm));
}
public int Update_UMUserInfo(UMUserInfoInfo uMUserInfoInfo)
{
return(us.Update_UMUserInfo(uMUserInfoInfo));
}
public int Insert_UMUserInfo(UMUserInfoInfo uMUserInfoInfo)
{
return(us.Insert_UMUserInfo(uMUserInfoInfo));
}
