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